hi guys
I want SAS to read in the following:
data one;
input name & :$20. age;
cards;
Marry lee Jones 40
Arnold Jonson 45
;
but i get errors
What am i doing wrong here?
please help?
& says to keep reading until it sees two or more spaces. So the 40 on the first line becomes part of the name. It then needs to go to the next line to read the age and cannot translate Arnold into a number. Hence the error message.
Add an extra space in front of the age on each row.
& says to keep reading until it sees two or more spaces. So the 40 on the first line becomes part of the name. It then needs to go to the next line to read the age and cannot translate Arnold into a number. Hence the error message.
Add an extra space in front of the age on each row.
That was quick and sweet
Thanks Tom
Hi Tom,
Based on this discussion, I need to learn how can we refer variable names with spaces or dash - or dots (.) betwen them in arrays?
e.g. NON BUYERS
Thanks,
Naeem
Start a new thread and explain in more detail what you want.
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.