topic how to input the different length name ? in SAS Programming

how to input the different length name ?

tianerhu — Sat, 07 Aug 2021 17:48:11 GMT

data work.homework;
infile datalines dsd;
input    name  $  
         age 
         height;

datalines;
John McCloskey 35 71
June Rosesette 10 43
TinekeJones 9 37
;
proc print data = work.homework;
run;

Re: how to input the different length name ?

tianerhu — Sat, 07 Aug 2021 17:52:57 GMT

this program above does not work. Please give me a help.

Re: how to input the different length name ?

PaigeMiller — Sat, 07 Aug 2021 18:11:09 GMT

If you have two spaces after the name, and you use the & to read in the names, then everything will work.

https://www.geeksforgeeks.org/sas-how-to-read-character-using-ampersand/

Re: how to input the different length name ?

Tom — Sat, 07 Aug 2021 18:11:32 GMT

The main thing is you need to fix the data so that it can be parsed.

Either use a delimiter other than space between the values on the lines. Your current code is expecting a comma as the delimiter as that is the default when the DSD option is used.

data homework;
  infile datalines dsd;
  input name :$30. age height;
datalines;
John McCloskey,35,71
June Rosesette,10,43
TinekeJones,9,37
;

Or insure there are at least two spaces after the name (and no more than one space in a row in the name) so you can use the & modifier.

data homework;
  input name &:$30. age height;
datalines;
John McCloskey  35 71
June Rosesette  10 43
TinekeJones      9 37
;

Re: how to input the different length name ?

tianerhu — Sat, 07 Aug 2021 19:52:00 GMT

Thank you for your help.

Re: how to input the different length name ?

tianerhu — Sat, 07 Aug 2021 19:52:20 GMT

Thanks a lot.