Hi all,
I need to make a sub-dataset out of the main data in a way that two controls are stacked below their respective case. Any opinion or hint!
Thanks
1. Number each Case/Control set with a unique ID -> SetID
2. Create a variable where Case are 1, controls are 2 ->Case_Control
Then you can sort by SetID, Case_Control
Thanks Reeza!
Attached is my sample datasets wtih id numbers from sample and controls as paris; can you guide me how to do stacking with individual paris together?
data sample;
input id age edu race parity wt ht;
datalines;
05 32 9 1 0 90 5.2
12 35 12 1 2 110 5.0
17 40 10 2 1 130 4.9
22 25 14 3 0 110 5.4
29 27 12 2 1 95 5.0
40 28 10 3 2 130 6
;
data controls;
input id age edu race parity wt ht;
datalines;
10 33 11 2 1 98 5.7
11 35 10 2 2 120 5.9
19 42 11 1 3 139 5.9
26 26 14 0 1 99 5.0
31 27 10 2 1 95 5.5
32 29 12 2 2 125 6.2
37 31 10 2 1 190 7.2
43 35 12 1 1 110 5.0
46 45 10 1 1 130 4.9
51 28 12 3 0 110 5.4
55 22 10 1 1 95 5.0
58 28 10 3 2 130 6
70 32 9 1 0 90 5.2
79 37 11 1 2 110 5.0
85 48 14 2 1 130 4.9
88 29 14 3 0 110 5.4
90 25 14 2 1 95 5.0
93 27 11 3 2 130 6
99 35 10 1 0 90 5.2
101 33 11 1 2 110 5.0
114 38 16 2 1 130 4.9
125 25 13 3 0 110 5.4
129 25 10 2 1 95 5.0
130 24 11 3 2 130 6
;
run;
Matched pairs with original IDs | ||
Sample | Control 1 | Control 2 |
5 | 70 | 99 |
12 | 43 | 101 |
22 | 125 | 51 |
ie create a table that looks like the following from your third table. Them merge in table 1/2 by ID and sort by N and Type2, I would recommend SQL.
N Type Type2 ID
1 Sample 1 5
1 Control 2 70
1 Control 2 99
2 Sample 1 12
2 Control 2 43
2 Control 2 101
Thanks. Can you give me the code?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.