Raw File :
---------10---------20---------30
72 95
SAS Program :
data test;
infile "Rawfile";
input @1 height 2. @4 weight 2;
run;
why weight variable is taking a value specified to next to it (only single digit) instead of 95 from raw file.
Output is :
_____________
Height Weight
--------------------
95 2
It's interpreted as taking the contents of column 2. You could code:
input @4 col1 1 @4 col2 2;
The @4 is irrelevant, overridden by the later instructions. COL1 will be the contents of column 1, and COL2 the contents of column 2.
Your missing a period at the end of your second format.
If you exclude formats and @ position SAS will most likely read it correctly by default.
@Reeza, yet the "2" didn't generate an error. How is it interpreted?
It's interpreted as taking the contents of column 2. You could code:
input @4 col1 1 @4 col2 2;
The @4 is irrelevant, overridden by the later instructions. COL1 will be the contents of column 1, and COL2 the contents of column 2.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.