I have submitted below program , but its showing invalid data for variable 'sal'
data Emp;
informat sal comma8.;
input name $ 1-4 sal 5-9 ;
datalines;
John12,360
;
run;
what is the issue?
The input statement is incorrect, you'rer trying to use fixed format method to read the file. Your data appears to be comma delimited instead. Specify the delimiter using DLM.
Infile cards dlm=",";
Input name $ sal;
If you just put the start column ans informat into input line it works.
data Emp;
informat sal comma6.;
input name $ 1-4 @5 sal comma8. ;
datalines;
John12,360
;
run;
Thanks all for replying. Now i understand that in column input, informats are ignored.
Thanks.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.