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);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.