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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: