Re: modified list input

anming · Posted 12-22-2020 09:17 PM

data list_modified;
input name $ & +3 lastname & $16. team $;
datalines;
Joseph     Joergensen White  Red
Mitchel     Mc Allister      blue
Su Ellen     Fischer Simon   green
;
run;

what does '+3' mean? without '+' only letter at position 3 is loaded for the name.

mkeintz · Posted 12-22-2020 10:28 PM

Change the +3 to, say, +6, and look at the result for lastname.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

anming · Posted 12-22-2020 11:25 PM

it works from without, +0 to +3. but from +4 the last name will be truncated.

mkeintz · Posted 12-23-2020 07:51 AM

@anming wrote:
it works from without, +0 to +3. but from +4 the last name will be truncated.

Truncated on which side?

What does that tell you about the function of prefixing a number with a "+"?

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------