input wiht ampersand (&)

[Tal]

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?

[Tom · Accepted solution]

& 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.

[Tal]

That was quick and sweet

Thanks Tom

[stat_sas]

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

[Tom]

Start a new thread and explain in more detail what you want.