BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
superbibi
Obsidian | Level 7

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;
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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

View solution in original post

2 REPLIES 2
ballardw
Super User

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

superbibi
Obsidian | Level 7
Thank you very much!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 407 views
  • 0 likes
  • 2 in conversation