Hi team, My inputa dat set is as below mentioned in sas code: So input data set contains amt column as character data type(as it is having both numeric and character values) but in final report i want to show numeric rows of column amt as numeric with some format and charcater rows as character. expected outp data tmp;
name="megha";
amt="17000000.03";
flg="N";
output;
name="Alok";
amt="12200000.04";
flg="N";
output;
name="Bittu";
amt="Bit";
flg="C";
output;
name="Cittu";
amt="Cit";
flg="C";
output;
run; ut is attached in excel sheet.
... View more