06-10-2016 12:29 PM
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
06-14-2016 04:10 PM
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.