Transforming numeric to character variable

mark_ph — Fri, 27 Feb 2015 20:33:47 GMT

Dear All;

I have the following dataset:

data have;

input ID Var;

datalines;

10 550

20 440

;

where Var is a numeric variable, I would like to transform it to a character variable and obtain the following

data want;

input ID Var;

datalines;

10 5-50

20 4-40

;

This my unsuccessful attempt:

data want;

set have;

Var1 = put(Var,10.);

run;

data want; set want;

if Var1 = '550' then Var1 = '5-50';

if Var1 = '440' then Var1 = '4-40';

run;

Any help would be highly appreciated.

Re: Transforming numeric to character variable

Reeza — Fri, 27 Feb 2015 21:06:23 GMT

Change your put statement to use the -l option, it will align your variable to the left.

For your conversion you may want to use substr/catt functions instead of harding it.

Var1 = put(Var,10. -l);