Put in column

[tmm]

I want to take a table that has the following: there are 86k rows that vary

memberID     yes         no

111                0            1

222                1            0

I want my output to be:

who              admission            count

national          yes                       0

national          no                         1

national         yes                        1

national          no                         0

The code I have is:

data chi (drop = yes no);

set final;

array _col(2) yes no;

do _n_=1to2;

who = vname (national);

admission = vname(_col(_n_));

count = _col(_n_);

output;

end;

run;

The table looks like this:

who                  national                admission          count

national                                            yes                  0

national                                             no                   1

national                                            yes                  1

national                                             no                   0

I do not want the national colunmn. Just the who column with national in it and then admission with yes and no and then the count

[PGStats]

What is the relationship between WHO and memberID?

PG

[Hima · Accepted solution]

Code:

DATA TEMP;
INPUT memberID     yes         no;
CARDS;
111                0            1
222                1            0
;
RUN;

data chi (drop = yes no);
set TEMP;
array _col(2) yes no;
do _n_= 1,2;
who = vname (national);
admission = vname(_col(_n_));
count = _col(_n_);
output;
end;
DROP NATIONAL;
run;

PROC PRINT;
RUN;

Output:

                         member
                        Obs      ID        who       admission    count

                         1       111     national       yes         0
                         2       111     national       no          1
                         3       222     national       yes         1
                         4       222     national       no          0