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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.