https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548857#M7341 Thank you very much! Fri, 05 Apr 2019 17:50:18 GMT superbibi 2019-04-05T17:50:18Z https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548796#M7339 <P>Hi SAS Users,</P><P>&nbsp;</P><P>I am using SAS University&nbsp;Edition.&nbsp;</P><P>&nbsp;</P><P>I know how to generate the AUC graph for each ID. But how to generate an overlay graph for the two IDs?</P><P>&nbsp;</P><P>Thank you.</P><P>&nbsp;</P><PRE><CODE class=" language-sas"> 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;</CODE></PRE> Fri, 05 Apr 2019 14:58:15 GMT https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548796#M7339 superbibi 2019-04-05T14:58:15Z https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548810#M7340 <P>Generally the approach is not to use a WHERE clause eliminating any of the groups and then use a GROUP option.</P> <P>&nbsp;</P> <PRE>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;</PRE> <P>Depending on your data you may need to look at some other options like TRANSPARENCY = 0.5 to display something when bands overlap</P> Fri, 05 Apr 2019 15:36:06 GMT https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548810#M7340 ballardw 2019-04-05T15:36:06Z https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548857#M7341 Thank you very much! Fri, 05 Apr 2019 17:50:18 GMT https://communities.sas.com/t5/SAS-Studio/Stack-band-using-SAS-University-Edition/m-p/548857#M7341 superbibi 2019-04-05T17:50:18Z