topic Re: Adding trailing blanks to alphanumeric characters in SAS Procedures

Adding trailing blanks to alphanumeric characters

chennupriya — Mon, 24 Nov 2014 15:14:37 GMT

Adding trailing blanks to alphanumeric characters SAS code

Re: Adding trailing blanks to alphanumeric characters

RW9 — Mon, 24 Nov 2014 15:56:51 GMT

Hi,

data want;

length b $200;

a="ABCD1234";

b=repeat("0",20-length(strip(a)))||strip(a);

run;

For trailing, just move the strip(a) before the repeat.

Re: Adding trailing blanks to alphanumeric characters

stat_sas — Mon, 24 Nov 2014 16:10:17 GMT

data want;

length b $20;

a="ABCD1234";

b=a;

run;

Re: Adding trailing blanks to alphanumeric characters

RW9 — Mon, 24 Nov 2014 16:15:32 GMT

Oh, trailing blanks, I should read the question more thoroughly.

Re: Adding trailing blanks to alphanumeric characters

chennupriya — Mon, 24 Nov 2014 16:33:30 GMT

hi ,

i want to export to Csv file after coding

sso we use something like dat_null_

AAnd put function now length is $12.

and it shd be A25

Re: Adding trailing blanks to alphanumeric characters

Astounding — Mon, 24 Nov 2014 16:44:47 GMT

If you are using DATA _NULL_ and a PUT statement to write out the data, it is easy to write out trailing blanks. Add a format specification to the PUT statement, for example:

put varname $25. ',' ... more variables ...;

This will write a total of 25 characters for VARNAME, including trailing blanks as needed to reach that length of 25.

Good luck.

Re: Adding trailing blanks to alphanumeric characters

Tom — Mon, 24 Nov 2014 17:33:41 GMT

Why? You mention writing a CSV, but by definition a CSV file would normally NOT have trailing blanks.