topic Re: Coding to re-arrange variables in SAS Programming

Coding to re-arrange variables

desireatem — Tue, 05 Oct 2021 01:45:58 GMT

Hello I have this data with four variables A, B, C D that I want to make it one variable A. THe data is as such.

A B C D

1 1 1 .

2 1 . 1

. 2 1 .

. . 2 .

. . . 3

I want to create this data with one variable call A as above

The variable A B C D are in order and F takes the first number. If all are missing, F will be missing otherwise F takes the first value from the variable A, B, C, D.

Re: Coding to re-arrange variables

desireatem — Tue, 05 Oct 2021 02:34:35 GMT

Actually F is: F

Re: Coding to re-arrange variables

Patrick — Tue, 05 Oct 2021 03:50:21 GMT

The coalesce() function will pick the first non-missing value.

data sample;
  input A B C D;
  F=coalesce(a,b,c,d);
datalines;
1 1 1 .
2 1 . 1
. 2 1 .
. . 2 .
. . . 3
;