Hi, I use put to
such as :
"data Liutwo.Dealissueyear2006alta;
set Liutwo.Dealissueyear2006alta;
MTM1=put(MTM,12.);
SCORE1=put(SCORE,12.);
DROP MTM SCORE;
run;"
and they are tranformed to Character format, and then i can combine the files together as they are the same format after the transforming.
But if i use input.. it shows error... (Probaly because, there are a lot of missing data coded as "N/A" in excel)
BTW: can i convert the character to numericals after i combine all the files.
> Lucilla,
> you should remember about informat using the input
> function and format using put function.
> If you want to convert text variable MTM to numeric
> and text looks like "111,233,654" then you should use
> the following informat to function input:
> mtm1=input(mtm,comma17.);
> See your data before proceeding.