topic Re: Concatenation with put statement in SAS Procedures

Concatenation with put statement

mlogan — Thu, 26 May 2016 15:05:25 GMT

Can someone tell me how do I insert 5 spaces between last name and first name?

line1 = CAT(put(Student_ID, 7.), put(Last_Name, 5.), put(First_Name, 3.));

Expected Output

123456 JHANG Will

1234658MICHA Don

Thanks,

Re: Concatenation with put statement

Haris — Thu, 26 May 2016 15:16:15 GMT

line1 = CAT(put(Student_ID, 7.), put(Last_Name, 5.), ' ', put(First_Name, 3.));

but you can't fit 'Will' into three characters of the first name...

Re: Concatenation with put statement

LinusH — Thu, 26 May 2016 15:38:45 GMT

You can't (espacially by using numerical format) and there is no need to use put() function on character values.
Why do you want to concatenate those in the first place?

Re: Concatenation with put statement

ballardw — Thu, 26 May 2016 15:43:01 GMT

line1 = CAT(put(Student_ID, 7.), put(Last_Name, $5.), ' ', put(First_Name, $3.));

line1 = CAT(put(Student_ID, 7.),substr(Last_Name,1, 5), ' ', substr(First_Name, 1, 3))

And if I were writing directly to listing output or a text file would consider

put student_d @8 Last_name $5. @13 First_name $3.;