Hi, the purpose of this exercise is to create a table showing how many subjects populate for each flag. This is a data manipulation exercise, and the main thing i'm struggling with is trying to output a 0 count for flag2. Ideally, I'd like to be able to do it in PROC SQL.
data have;
infile datalines dsd dlm=",";
input subjid $ trtan flag1 $ flag2 $ flag3 $ flag4 $ flag5 $;
datalines;
001, 1, Y, , , Y, Y
002, 2, , , , ,
003, 1, Y, , Y, Y,
004, 2, Y, , Y, ,
005, 2, , , , Y,
006, 2, , , , , Y
007, 1, Y, , Y, ,
008, 1, Y, , , , Y
009, 2, Y, , , ,
010, 1, , , y, ,
;
run;
data have1; set have;
output;
trtan=3; output;
run;
The output is supposed to have 4 columns, and 5 rows. The first two rows are only supposed to output values for the flag label column and overall column (TRTAN3).
Desired output;
FLAG TRTAN1 TRTAN2 TRTAN3
Flag1 6
Flag2 0
Flag3 3 1 4
Flag4 2 1 3
Flag5 2 1 3
... View more