topic Re: Why the following DATA step doesn't create the correct output? in SAS Programming

Why the following DATA step doesn't create the correct output?

Zhanxiong — Sun, 25 Jun 2017 21:25:19 GMT

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.

Re: Why the following DATA step doesn't create the correct output?

Shmuel — Sun, 25 Jun 2017 22:48:21 GMT

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;

Re: Why the following DATA step doesn't create the correct output?

Zhanxiong — Sun, 25 Jun 2017 23:41:31 GMT

It works, thank you so much!