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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.