- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
& 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
& 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
That was quick and sweet
Thanks Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Start a new thread and explain in more detail what you want.