Preface
Introduction to PowerExchange for SAS
Installation and Configuration
Working with SAS Sources
Working with SAS Targets
Working with SAS Sessions
Appendix A: SAS Datatype Reference
- SAS Data Types and Formats
Appendix B: SPI Server Configuration Parameters
- Configuration Parameters
Appendix C: Error Messages

PowerExchange for SAS User Guide for PowerCenter

10.5.3
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Reading SAS Character Columns with Binary Zeros

SAS allows the binary zero bytes inside character columns but PowerCenter do not allow characters with the binary zeros. You can replace the binary zeros with NULL characters before passing the data to PowerCenter.

To replace the binary zeros by NULL character, assign the macro variable

CHCKNLLS

in the SAS autoexec file.

Add the following line in the SAS autoexec file:

%let CHCKNLLS=YES;

Configuring the SAS Autoexec File

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for SAS User Guide for PowerCenter

PowerExchange for SAS User Guide for PowerCenter

Reading SAS Character Columns with Binary Zeros

Reading SAS Character Columns with Binary Zeros