use data step to read comma separated datalines. The code is given below. Help me fix this error, pl

[contactnishan]

Please help me figure this out. I cannot correctly make a table with 4 columns and values in them.

data staff;
  infile datalines delimiter=',';  
   input name $25. dept $40. Salary month;
   datalines;                      
John Ivan,Sales,55000,1
Mary Persi,Acctng,49000,7
Davidsons,Storage Management,67000,5
;
run;

[ed_sas_member · Accepted solution]

Hi @contactnishan 

You can use : to specify an informat in the input statement.

It will force SAS to read the data up to the delimiter.

data staff;
	infile datalines delimiter=',';
	input name:$25. dept:$40. Salary month;
	datalines;
John Ivan,Sales,55000,1
Mary Persi,Acctng,49000,7
Davidsons,Storage Management,67000,5
;
run;

[contactnishan]

That was quick, it worked. Thank you so much. 😁

[ed_sas_member]

You're welcome @contactnishan 😊