topic Re: question about substr in SAS Programming

question about substr

cecily — Wed, 10 Aug 2016 18:44:47 GMT

data a;
sub1="*"||substr(1234.5678,1,6)||"*";

run;

why in the result there are some blanks before 1234？

Re: question about substr

PGStats — Wed, 10 Aug 2016 19:09:39 GMT

Read the SAS log!

The first argument to SUBSTR must be of type character. A number will be converted to a right justified character string using sometinng like the BEST12. format, i.e. including some leading blanks.

You can control the convertion result with functions PUT, LEFT, and STRIP.

Re: question about substr

cecily — Wed, 10 Aug 2016 19:17:11 GMT

thanks!