BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
contactnishan
Obsidian | Level 7

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
ed_sas_member
Meteorite | Level 14

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;

Capture d’écran 2020-04-20 à 10.28.02.png

View solution in original post

3 REPLIES 3
ed_sas_member
Meteorite | Level 14

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;

Capture d’écran 2020-04-20 à 10.28.02.png

contactnishan
Obsidian | Level 7

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1142 views
  • 1 like
  • 2 in conversation