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.
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);
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);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: