Hi, i have a problem regarding the following data
101-lily,5000
102=jasmine*3000
103_daniel'9000
the following is the solution i tried. but in the dlm='- , = * _' i am unable to insert ' in the dlm.
data b;
infile "/folders/myfolders/sasuser.v94/task2today.txt" dlm='- , = * _' dsd;
input id name : $9. sal;
run;
this is my output. the third row is not visible. please help me fix this . thanks in advance.
101 lily 5000
102 jasmine 3000
change
dlm='- , = * _'
to, note the double quotes
dlm="- , = '* _"
this should work
yes, it worked. thank you.
Use double quotes 🙂
yes it worked .thank you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.