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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.