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.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Removing Leading Spaces in Text Fields

PowerCenter Connect™ for SAS 3.2.3.0 and earlier, removes the leading spaces in text fields in a SAS source and trims the leading spaces when you write to a SAS target.

You can add the following statement to the SAS autoexec file to remove leading spaces:

%let TRMLDSPC=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

Removing Leading Spaces in Text Fields

Removing Leading Spaces in Text Fields