topic pick up variables in one column in SAS Programming

pick up variables in one column

Barney1998 — Tue, 06 Jun 2023 10:17:55 GMT

Hallo to everyone.

I have this problem. I have a big data set so this i will try to explain you it was difficult to be implemented by hand.

First of all i have one data set which looks like:

qq1 qq2 qq3 qq4
1
0

0
2
11
i want to pick up all the variables in one new column
like
qq
1
0
0
2
11

from the first table if one column value is not missing means that all the other columns are missing in the same row
thank you in advance

Re: pick up variables in one column

FreelanceReinh — Tue, 06 Jun 2023 11:36:16 GMT

Hallo @Barney1998,

If qq1 - qq4 are numeric variables, you can use the COALESCE function to obtain the first non-missing value:

data have;
input qq1-qq4;
cards;
1 . . .
. 0 . .
. 0 . .
. . 2 .
. . . 11
;

data want(drop=qq1-qq4);
set have;
qq=coalesce(of qq1-qq4);
run;

For character variables there is the similar COALESCEC function.