Transforming numeric to character variable

[mark_ph]

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.

[Reeza · Accepted solution]

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);