topic Re: converting num to char in SAS Procedures

converting num to char

Tal — Wed, 17 Jun 2015 19:42:34 GMT

tryiing to conver a num var (id) to char by writing this step:

data new;

set old (rename=(id=id1));

id=put(id1,2.);

drop id1;

run;

and i am getting asterix in the column of id. Does anyone know why?

Re: converting num to char

dcruik — Wed, 17 Jun 2015 19:49:23 GMT

Looks like you're using a numeric format in your put statement. Also, when converting a numeric variable to character, often times it gives you leading blanks. Try modifying your code to this:

data new;

set old (rename=(id=id1));

id=strip(put(id1,$2.);

drop id1;

run;

Hope that helps!

Re: converting num to char

Astounding — Wed, 17 Jun 2015 20:08:10 GMT

You will get an asterisk whenever the numeric value is 100 or more ... so that it won't fit in a 2. format. You could guess at the right width to use:

id = put(id1, 4.);

Or, you could run a PROC MEANS and see what the maximum value is.

Good luck.

Re: converting num to char

Steelers_In_DC — Wed, 17 Jun 2015 20:11:05 GMT

Here you go:

data have;

infile cards dsd;

input num;

cards;

;

run;

data want(rename=(num2=num));

set have;

num2 = put(num,8.);

drop num;

run;

Re: converting num to char

jsasusr — Thu, 18 Jun 2015 14:03:47 GMT

The last time I did this, I didn't create a new table I just kept the old, so I wrote:

data oldtable;

set oldtable;

newvar=put(oldvar, 2.);

drop oldvar;

run;

(Actually I dropped the old variable in a different step because I needed it in another join.

Re: converting num to char

Tal — Thu, 18 Jun 2015 19:04:43 GMT

right!

i thought the numbers were two digit numbers and was expecting so but it turns out they were all between 100 and 500 so my formatting was not correct .

Thanks

Thank you all guys for the quick reponse