I want to create a data set as shown below:
I used the following (column input) code:
data GYM_UPDATE; infile datalines pad; input @1 ID @3 Gender $ Age 5-6 Vault 8-10 Floor 12-14 P_BAR 16-18; datalines;
3 6.7
5 15 8.1 7.2
7 F
;
run;
The output is strange:
I am able to create the correct data set by using the listing input with comma as the delimiter. However, I still want to figure out what goes wrong in the above column input code. Thanks in advance.
You miss gender length - how many characters to input.
Try next code:
data GYM_UPDATE;
infile datalines pad;
input @1 ID @3 Gender $1.
Age 5-6 Vault 8-10 Floor 12-14 P_BAR 16-18;
datalines;
3 6.7
5 15 8.1 7.2
7 F
;
run;
You miss gender length - how many characters to input.
Try next code:
data GYM_UPDATE;
infile datalines pad;
input @1 ID @3 Gender $1.
Age 5-6 Vault 8-10 Floor 12-14 P_BAR 16-18;
datalines;
3 6.7
5 15 8.1 7.2
7 F
;
run;
It works, thank you so much!
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.