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;
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;
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;
That was quick, it worked. Thank you so much. 😁
You're welcome @contactnishan 😊
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.