topic Re: Transforming table in SAS Programming

Transforming table

Betty_sam — Tue, 06 Apr 2021 16:37:08 GMT

Hi,

I have data like this :

I want to transform it into

How can I do this please ?

Thank you

Sajid01 — Tue, 06 Apr 2021 16:43:07 GMT

One way of doing this is as follows.
You can modify as needed.

data test;
input full_name $ Q1 Q2 Q3;
datalines;
A 1 . .
B . 2 .
C . . 3
;
run;
data test( drop=q1 q2 q3);
set test;
Q=sum(q1,q2,q3);
run;

Reeza — Tue, 06 Apr 2021 17:00:28 GMT

COALESCE()

Q = coalesce(of Q1-Q3);