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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.