Libname sasuser 'C:\Users\Ifeoma\Downloads';
Data sasuser.epilepsy;
SET epilepsy;
input ID $ Treatment Age ESC TSC1 TSC2 TSC3 TSC4 $;
datalines;
1 0 31 11 5 3 3 3
2 0 30 11 3 5 3 3
3 0 25 6 2 4 0 5
4 0 36 8 4 4 1 4
5 0 22 66 7 18 9 21
6 0 29 27 5 2 8 7
7 0 31 12 6 4 0 2
8 0 36 52 40 20 23 12
9 0 37 23 5 6 6 5
10 0 28 10 14 13 6 0
11 0 36 52 26 12 6 22
12 0 24 33 12 6 8 5
13 0 28 18 4 4 6 2
14 0 36 42 7 9 12 14
15 0 26 87 16 24 10 9
16 0 26 50 11 0 0 5
17 0 28 18 0 0 3 3
18 0 31 111 37 29 28 29
19 0 32 18 3 5 2 5
20 0 21 20 3 0 6 7
21 0 29 12 3 4 3 4
22 0 21 9 3 4 3 4
23 0 32 17 2 3 3 5
24 0 25 28 8 12 2 8
25 0 30 55 18 24 76 25
26 0 40 9 2 1 2 1
27 0 19 10 3 1 4 2
28 0 22 47 13 15 13 12
29 1 18 76 11 14 9 8
30 1 32 38 8 7 9 4
31 1 20 19 0 4 3 0
32 1 20 10 3 6 1 3
33 1 18 19 2 6 7 4
34 1 24 24 4 3 1 3
35 1 30 31 22 17 19 16
36 1 35 14 5 4 7 4
37 1 57 11 2 4 0 4
38 1 20 67 3 7 7 7
39 1 22 41 4 18 2 5
40 1 28 7 2 1 1 0
41 1 23 22 0 2 4 0
42 1 40 13 5 4 0 3
43 1 43 46 11 14 25 15
44 1 21 36 10 5 3 8
45 1 35 38 19 7 6 7
46 1 25 7 1 1 2 4
47 1 26 36 6 10 8 8
48 1 25 11 2 1 0 0
49 1 22 151 102 65 72 63
50 1 32 22 4 3 2 4
51 1 25 42 8 6 5 7
52 1 35 32 1 3 1 5
53 1 21 56 18 11 28 13
54 1 41 24 6 3 4 0
55 1 32 16 3 5 4 3
56 1 26 22 1 23 19 8
57 1 21 25 2 3 0 1
58 1 36 13 0 0 0 0
59 1 37 12 1 4 3 2
;
run;
Data epilepsy1;
Set epilepsy;
Week = 1;
Seizurecount = TSC1;
drop TSC1 TSC2 TSC3 TSC4;
run;
Data epilepsy2;
Set epilepsy;
Week = 2;
Seizurecount = TSC2;
drop TSC1 TSC2 TSC3 TSC4;
run;
Data epilepsy3;
Set epilepsy;
Week = 3;
Seizurecount = TSC3;
drop TSC1 TSC2 TSC3 TSC4;
run;
Data epilepsy4;
Set epilepsy;
Week = 4;
Seizurecount = TSC4;
drop TSC1 TSC2 TSC3 TSC4;
run;
Data sasuser.epilepsylong;
Set epilepsy1 epilepsy2 epilepsy3 epilepsy4;
run; After running the code, I got the following errors; NOTE: Variable TSC1 is uninitialized.
WARNING: The variable TSC2 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC3 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC4 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY.
NOTE: The data set WORK.EPILEPSY1 has 94 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
2243 Data epilepsy2;
2244 Set epilepsy;
2245 Week = 2;
2246 Seizurecount = TSC2;
2247 drop TSC1 TSC2 TSC3 TSC4;
2248 run;
NOTE: Variable TSC2 is uninitialized.
WARNING: The variable TSC1 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC3 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC4 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY.
NOTE: The data set WORK.EPILEPSY2 has 94 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
2249 Data epilepsy3;
2250 Set epilepsy;
2251 Week = 3;
2252 Seizurecount = TSC3;
2253 drop TSC1 TSC2 TSC3 TSC4;
2254 run;
NOTE: Variable TSC3 is uninitialized.
WARNING: The variable TSC1 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC2 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC4 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY.
NOTE: The data set WORK.EPILEPSY3 has 94 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
2255 Data epilepsy4;
2256 Set epilepsy;
2257 Week = 4;
2258 Seizurecount = TSC4;
2259 drop TSC1 TSC2 TSC3 TSC4;
2260 run;
NOTE: Variable TSC4 is uninitialized.
WARNING: The variable TSC1 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC2 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable TSC3 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY.
NOTE: The data set WORK.EPILEPSY4 has 94 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
2261 Data sasuser.epilepsylong;
2262 Set epilepsy1 epilepsy2 epilepsy3 epilepsy4;
2263 run;
NOTE: There were 94 observations read from the data set WORK.EPILEPSY1.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY2.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY3.
NOTE: There were 94 observations read from the data set WORK.EPILEPSY4.
NOTE: The data set SASUSER.EPILEPSYLONG has 376 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
... View more
