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);
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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: