Hi SAS Users,
I am using SAS University Edition.
I know how to generate the AUC graph for each ID. But how to generate an overlay graph for the two IDs?
Thank you.
data have;
input id $7. day value start auc;
cards;
LND-002 0 0 0 23.5
LND-002 1 0 0 23.5
LND-002 2 0 0 23.5
LND-002 3 0 0 23.5
LND-002 4 0 0 23.5
LND-002 5 0 0 23.5
LND-002 6 0 0 23.5
LND-002 7 0 0 23.5
LND-002 8 0 0 23.5
LND-002 9 0 0 23.5
LND-002 10 0 0 23.5
LND-002 11 0 0 23.5
LND-002 12 0 0 23.5
LND-002 13 0 0 23.5
LND-002 14 0 0 23.5
LND-002 15 0 0 23.5
LND-002 16 0 0 23.5
LND-002 17 0 0 23.5
LND-002 18 0 0 23.5
LND-002 19 0 0 23.5
LND-002 20 0 0 23.5
LND-002 21 0 0 23.5
LND-002 22 0 0 23.5
LND-002 23 0 0 23.5
LND-002 24 0 0 23.5
LND-002 25 0 0 23.5
LND-002 26 0 0 23.5
LND-002 27 0 0 23.5
LND-002 28 0 0 23.5
LND-002 29 0 0 23.5
LND-002 30 0 0 23.5
LND-002 31 0 0 23.5
LND-002 32 0 0 23.5
LND-002 33 0 0 23.5
LND-002 34 0 0 23.5
LND-002 35 3 0 23.5
LND-002 36 3 0 23.5
LND-002 37 2 0 23.5
LND-002 38 2 0 23.5
LND-002 39 4 0 23.5
LND-002 40 1 0 23.5
LND-002 41 0 0 23.5
LND-002 42 1 0 23.5
LND-002 43 0 0 23.5
LND-002 44 1 0 23.5
LND-002 45 0 0 23.5
LND-002 46 0 0 23.5
LND-002 47 0 0 23.5
LND-002 48 0 0 23.5
LND-002 49 0 0 23.5
LND-002 50 0 0 23.5
LND-002 51 0 0 23.5
LND-002 52 1 0 23.5
LND-002 53 1 0 23.5
LND-002 54 1 0 23.5
LND-002 55 1 0 23.5
LND-002 56 0 0 23.5
LND-002 57 0 0 23.5
LND-002 58 0 0 23.5
LND-002 59 0 0 23.5
LND-002 60 0 0 23.5
LND-002 61 0 0 23.5
LND-002 62 0 0 23.5
LND-002 63 1 0 23.5
LND-002 64 1 0 23.5
LND-002 65 . 0 23.5
LND-002 66 0 0 23.5
LND-002 67 0 0 23.5
LND-002 68 0 0 23.5
LND-002 69 0 0 23.5
LND-002 70 0 0 23.5
LND-002 71 0 0 23.5
LND-002 72 0 0 23.5
LND-002 73 0 0 23.5
LND-002 74 0 0 23.5
LND-002 75 0 0 23.5
LND-002 76 0 0 23.5
LND-002 77 0 0 23.5
LND-002 78 0 0 23.5
LND-002 79 0 0 23.5
LND-002 80 0 0 23.5
LND-002 81 0 0 23.5
LND-002 82 0 0 23.5
LND-002 83 0 0 23.5
LND-002 84 0 0 23.5
LND-002 85 0 0 23.5
LND-002 86 0 0 23.5
LND-002 87 0 0 23.5
LND-002 88 0 0 23.5
LND-002 89 0 0 23.5
LND-002 90 0 0 23.5
LND-002 91 0 0 23.5
LND-002 92 . 0 23.5
LND-003 0 0 0 3.0
LND-003 1 0 0 3.0
LND-003 2 0 0 3.0
LND-003 3 0 0 3.0
LND-003 4 0 0 3.0
LND-003 5 0 0 3.0
LND-003 6 0 0 3.0
LND-003 7 0 0 3.0
LND-003 8 0 0 3.0
LND-003 9 0 0 3.0
LND-003 10 0 0 3.0
LND-003 11 0 0 3.0
LND-003 12 0 0 3.0
LND-003 13 0 0 3.0
LND-003 14 0 0 3.0
LND-003 15 0 0 3.0
LND-003 16 1 0 3.0
LND-003 17 1 0 3.0
LND-003 18 0 0 3.0
LND-003 19 0 0 3.0
LND-003 20 0 0 3.0
LND-003 21 0 0 3.0
LND-003 22 0 0 3.0
LND-003 23 0 0 3.0
LND-003 24 0 0 3.0
LND-003 25 0 0 3.0
LND-003 26 0 0 3.0
LND-003 27 0 0 3.0
LND-003 28 0 0 3.0
LND-003 29 0 0 3.0
LND-003 30 1 0 3.0
LND-003 31 0 0 3.0
LND-003 32 0 0 3.0
LND-003 33 0 0 3.0
LND-003 34 0 0 3.0
LND-003 35 0 0 3.0
LND-003 36 0 0 3.0
LND-003 37 0 0 3.0
LND-003 38 0 0 3.0
LND-003 39 0 0 3.0
LND-003 40 0 0 3.0
LND-003 41 0 0 3.0
LND-003 42 0 0 3.0
LND-003 43 0 0 3.0
LND-003 44 0 0 3.0
LND-003 45 0 0 3.0
LND-003 46 0 0 3.0
LND-003 47 0 0 3.0
LND-003 48 0 0 3.0
LND-003 49 0 0 3.0
LND-003 50 0 0 3.0
LND-003 51 0 0 3.0
LND-003 52 0 0 3.0
LND-003 53 0 0 3.0
LND-003 54 0 0 3.0
LND-003 55 0 0 3.0
LND-003 56 0 0 3.0
LND-003 57 0 0 3.0
LND-003 58 0 0 3.0
LND-003 59 0 0 3.0
LND-003 60 0 0 3.0
LND-003 61 0 0 3.0
LND-003 62 0 0 3.0
LND-003 63 0 0 3.0
LND-003 64 0 0 3.0
LND-003 65 0 0 3.0
LND-003 66 0 0 3.0
LND-003 67 0 0 3.0
LND-003 68 0 0 3.0
LND-003 69 0 0 3.0
LND-003 70 0 0 3.0
LND-003 71 0 0 3.0
LND-003 72 0 0 3.0
LND-003 73 0 0 3.0
LND-003 74 0 0 3.0
LND-003 75 0 0 3.0
LND-003 76 0 0 3.0
LND-003 77 0 0 3.0
LND-003 78 0 0 3.0
LND-003 79 0 0 3.0
LND-003 80 0 0 3.0
LND-003 81 0 0 3.0
LND-003 82 0 0 3.0
LND-003 83 0 0 3.0
LND-003 84 0 0 3.0
LND-003 85 0 0 3.0
LND-003 86 0 0 3.0
LND-003 87 0 0 3.0
;
run;
proc sgplot data = have;
where id = "LND-002";
band x= day lower = start upper = value;
xaxis values=(0 to 100 by 5);
yaxis values=(0 to 5 by 1);
run;
Generally the approach is not to use a WHERE clause eliminating any of the groups and then use a GROUP option.
proc sgplot data = have; band x= day lower = start upper = value / group=ID; xaxis values=(0 to 100 by 5); yaxis values=(0 to 5 by 1); run;
Depending on your data you may need to look at some other options like TRANSPARENCY = 0.5 to display something when bands overlap
Generally the approach is not to use a WHERE clause eliminating any of the groups and then use a GROUP option.
proc sgplot data = have; band x= day lower = start upper = value / group=ID; xaxis values=(0 to 100 by 5); yaxis values=(0 to 5 by 1); run;
Depending on your data you may need to look at some other options like TRANSPARENCY = 0.5 to display something when bands overlap
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.