Hello,
why I can't convert the character m to numeric s?
data a;
m='12345678';
run;
data b;
set a;
s=put(m, $8.);
run;
Thanks
PUT always creates a character variable used the way you did
Try
data b;
set a;
s= input(m, 8.);
run;
thank you, but s is still a char.
It shouldn't be. Double check your code and output. Was your log clean? Is S already in your dataset, you can't change a variable type if it already exists in the dataset.
data a;
m='12345678';
run;
data b;
set a;
s=input(m, 8.);
run;
proc contents data=b;
run;
Alphabetic List of Variables and Attributes
#Variable Type Len
1m Char 8
2 s Num 8
I found the problem, the import excel file including special characters which make SAS function can't recginize that variable.
the special characters are something like ctrl+ enter in excel.
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.