Add in subject specific values in each subject's graph

RubyS_ — Mon, 06 Apr 2015 18:34:30 GMT

Hi All,

First time posting!

I have a dataset with 127 subjects with a questionaire score everyday for 1 year. The subject numbers are not in order and range from 1 to 152. I plotted each subject's yearlong score using proc sgpanel so there is a time-series graph of scores for each subject. I have 127 subject-specific time series graphs. I also have information about the percentage of missing scores, percentage of scores equal to 0, and some other descriptive stats. I would like to add these subject specific variable values onto the graph somehow. I tried using #byvar and #byval in a footnote statment but I believe a by statement must be used and proc sgpanel required the use of panelby. I also tried creating subject speific macros using symputx where &subjectmiss1=2.4, &subjectzero1=5, etc. But I do not know how to implement these to get what I want. I would like to add in these subject specific values either in a small table underneath each graph or into a footnote. (Also, my dataset is laid out similar to below). Any help would be greatly appreciated! Thank you!

Subject	Day	Score	Percent Missing	Percent Zero	Range
1	1	7	2.4	5	3
1	2	5	2.4	5	3
1	3	3	2.4	5	3
4	1	10	1.5	4.4	11
4	2	12	1.5	4.4	11
4	3	16	1.5	4.4	11
4	4	12	1.5	4.4	11
4	5	18	1.5	4.4	11
4	6	7	1.5	4.4	11
4	7	9	1.5	4.4	11

data DATASET:

panelby SUBJECT;

series y=score x=day;

run;

Re: Add in subject specific values in each subject's graph

ballardw — Mon, 06 Apr 2015 19:19:05 GMT

If you are using a version later than SAS 9.2 you can use an annotate data set to add specific text.

Subject	Day	Score	Percent Missing	Percent Zero	Range
1	1	7	2.4	5	3
1	2	5	2.4	5	3
1	3	3	2.4	5	3
4	1	10	1.5	4.4	11
4	2	12	1.5	4.4	11
4	3	16	1.5	4.4	11
4	4	12	1.5	4.4	11
4	5	18	1.5	4.4	11
4	6	7	1.5	4.4	11
4	7	9	1.5	4.4	11

Subject	Day	Score	Percent Missing	Percent Zero	Range
1	1	7	2.4	5	3
1	2	5	2.4	5	3
1	3	3	2.4	5	3
4	1	10	1.5	4.4	11
4	2	12	1.5	4.4	11
4	3	16	1.5	4.4	11
4	4	12	1.5	4.4	11
4	5	18	1.5	4.4	11
4	6	7	1.5	4.4	11
4	7	9	1.5	4.4	11

topic Re: Add in subject specific values in each subject's graph in SAS Procedures

Add in subject specific values in each subject's graph

Re: Add in subject specific values in each subject's graph

Subject	Day	Score	Percent Missing	Percent Zero	Range
1	1	7	2.4	5	3
1	2	5	2.4	5	3
1	3	3	2.4	5	3
4	1	10	1.5	4.4	11
4	2	12	1.5	4.4	11
4	3	16	1.5	4.4	11
4	4	12	1.5	4.4	11
4	5	18	1.5	4.4	11
4	6	7	1.5	4.4	11
4	7	9	1.5	4.4	11