Newbie! Using array statement to make data table not working

user1942 — Tue, 22 Oct 2019 20:54:14 GMT

Hello experts! I need to use an array to make my data table, but for some reason the data in the last column isn't being output. Here is the directions for my problem:

Patients underwent knee replacement surgeries for one or both knees. The data record patient id, the replaced knee number (1 or 2), and satisfaction scores pre-operatively, one day, one week, and one month after the surgery. The data are

Patient Knee Score Score at Score at Score at

ID Number Pre-op one day one week one month

01 1 0 5 7 10

02 1 0 10 15 15

02 2 3 5 8 10

03 1 0 3 3 3

03 2 0 6 9 9

04 1 0 4 10 10

(a) Use the ARRAY statement to create a data set containing satisfaction scores for knee 1.

(b) Use the ARRAY statement to create a data set containing satisfaction scores for knee 2.

Here is my code for part a:

data exercise3;
input ID $ KneeNumber PreOp OneDay OneWeek OneMonth;
cards;
01 1 0 5 7 10
02 1 0 10 15 15
02 2 3 5 8 10
03 1 0 3 3   3
03 2 0 6 9   9
04 1 0 4 10 10
;
data A (keep=id visit score);
set exercise3;
array x{4} preop day1 week1 month1;
   do i=1 to 4;
   visit = i;
   score = x{i};
   if kneenumber = 1;
     output;
     end;
run;
proc print noobs;
run;

And this is my output:

ID visit score

                                       01      1        0
                                       01      2        .
                                       01      3        .
                                       01      4        .
                                       02      1        0
                                       02      2        .
                                       02      3        .
                                       02      4        .
                                       03      1        0
                                       03      2        .
                                       03      3        .
                                       03      4        .
                                       04      1        0
                                       04      2        .
                                       04      3        .
                                       04      4        .

I'm not sure what I'm doing wrong, please help!!!

Re: Newbie! Using array statement to make data table not working

ballardw — Tue, 22 Oct 2019 21:44:16 GMT

@user1942 wrote:

Hello experts! I need to use an array to make my data table, but for some reason the data in the last column isn't being output. Here is the directions for my problem:

Patients underwent knee replacement surgeries for one or both knees. The data record patient id, the replaced knee number (1 or 2), and satisfaction scores pre-operatively, one day, one week, and one month after the surgery. The data are

Patient Knee       Score     Score at     Score at     Score at

   ID       Number   Pre-op   one day     one week   one month

   01          1              0            5             7                10

   02          1              0            10              15               15

   02          2              3             5             8                10

   03          1             0             3               3                   3

   03          2             0             6               9                   9

   04          1             0             4              10                10

(a) Use the ARRAY statement to create a data set containing satisfaction scores for knee 1.

(b) Use the ARRAY statement to create a data set containing satisfaction scores for knee 2.

(c) Use the MERGE statement to create the merged file

Here is my code for part a:

data exercise3;
input ID $ KneeNumber PreOp OneDay OneWeek OneMonth;
cards;
01 1 0 5 7 10
02 1 0 10 15 15
02 2 3 5 8 10
03 1 0 3 3   3
03 2 0 6 9   9
04 1 0 4 10 10
;
data A (keep=id visit score);
set exercise3;
array x{4} preop day1 week1 month1;
   do i=1 to 4;
   visit = i;
   score = x{i};
   if kneenumber = 1;
     output;
     end;
run;
proc print noobs;
run;

And this is my output:

ID    visit    score

                                       01      1        0
                                       01      2        .
                                       01      3        .
                                       01      4        .
                                       02      1        0
                                       02      2        .
                                       02      3        .
                                       02      4        .
                                       03      1        0
                                       03      2        .
                                       03      3        .
                                       03      4        .
                                       04      1        0
                                       04      2        .
                                       04      3        .
                                       04      4        .

I'm not sure what I'm doing wrong, please help!!!

Please closely examine the names of the variables highlighted.

An array statement will create new variables if the name referenced on the array statement does not already exist.

You used three variable names on the array statement that were not already in the input data set.

topic Re: Newbie! Using array statement to make data table not working in SAS Programming

Newbie! Using array statement to make data table not working

Re: Newbie! Using array statement to make data table not working