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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.