topic Re: input wiht ampersand (&) in SAS Programming

input wiht ampersand (&)

Tal — Thu, 14 Mar 2013 22:21:07 GMT

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?

Re: input wiht ampersand (&)

Tom — Thu, 14 Mar 2013 22:30:12 GMT

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

Re: input wiht ampersand (&)

Tal — Thu, 14 Mar 2013 22:34:53 GMT

That was quick and sweet

Thanks Tom

Re: input wiht ampersand (&)

stat_sas — Fri, 15 Mar 2013 20:24:39 GMT

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

Re: input wiht ampersand (&)

Tom — Sat, 16 Mar 2013 02:45:13 GMT

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