Data visualization with SAS programming

panel data visualization

Accepted Solution Solved
Reply
Learner
Posts: 1
Accepted Solution

panel data visualization

We have a panel data (longitudinal data) that every subject in it has different begin dates and end dates. We want to make a plot such that the times series for each individual can be visualized in a single plot. So we have each plot for each individual. And Each individual has several time series in the plot. The problem is that we want to add some notes about the individual's basic information right under the main title of the plot. We also want to add notes of the begin dates and end dates of every time series in it. Then the plot looks messy... Some individuals have tens of time series and others have only four or five. And we need to add notes to each time series in the plot. Or we want a way that this information can be read at some notes in the plot...Can anyone provide me with a clue of solving this problem? Thanks a lot.

Accepted Solutions
Solution
yesterday
Super User
Posts: 19,058

Re: panel data visualization

BY processing should handle 99% of these. 

You can look into using #byval in footnote/title statements. 

Or you can create a custom macro that you execute multiple times. 

 

Either way, start with a single ID and get a single graph working. Then you can expand it to multiple. 

You should be using SGPLOT most likely. If your plot is really complex you may want to look at GTL as well.

 

Given what you've stated I'm not sure what more we can provide in terms of assistance. 

 

A very brief and basic example:

proc sort data=sashelp.stocks out=stocks;
    by stock date;
run;

proc sgplot data=stocks;
    by stock;
    series x=date y=open / markers;
run;

 

View solution in original post


All Replies
Solution
yesterday
Super User
Posts: 19,058

Re: panel data visualization

BY processing should handle 99% of these. 

You can look into using #byval in footnote/title statements. 

Or you can create a custom macro that you execute multiple times. 

 

Either way, start with a single ID and get a single graph working. Then you can expand it to multiple. 

You should be using SGPLOT most likely. If your plot is really complex you may want to look at GTL as well.

 

Given what you've stated I'm not sure what more we can provide in terms of assistance. 

 

A very brief and basic example:

proc sort data=sashelp.stocks out=stocks;
    by stock date;
run;

proc sgplot data=stocks;
    by stock;
    series x=date y=open / markers;
run;

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation