topic Re: create the line chart in SAS Programming

create the line chart

Alexxxxxxx — Tue, 19 Nov 2019 17:06:36 GMT

Dear all,

for the .excel file in the attachment, how to create the line chart of each "person_ctry_code" group, which just like the following picture?

The Y-axis is the no_app_per_year and no_app_per_year;

the X-axis is the years from 1990 to 2012.

Re: create the line chart

PaigeMiller — Tue, 19 Nov 2019 17:09:31 GMT

Use PROC SGPLOT with the SERIES statement and the GROUP= option.

Re: create the line chart

Reeza — Tue, 19 Nov 2019 17:36:46 GMT

https://documentation.sas.com/?docsetId=grstatproc&docsetVersion=9.4&docsetTarget=n06fb9ichgg6akn18060gbtvw9pw.htm&locale=en

Instead of SCATTER use SERIES but the rest is the same.

@Alexxxxxxx wrote:

Dear all,

for the .excel file in the attachment, how to create the line chart of each "person_ctry_code" group, which just like the following picture?

The Y-axis is the no_app_per_year and no_app_per_year;

the X-axis is the years from 1990 to 2012.

Re: create the line chart

Alexxxxxxx — Tue, 19 Nov 2019 21:27:33 GMT

thanks for your suggestion.

however, when I use

proc sgplot data=Results.PATSTAT_no_full_hrm_with_ctry5;
   SERIES x=year y=no_app_per_year / group=person_ctry_code;
   SERIES x=year y=no_cit_per_year / group=person_ctry_code;
run;

all the lines are shown in one picture.

Could you please give me more suggestions about this?

Re: create the line chart

Reeza — Tue, 19 Nov 2019 22:00:07 GMT

For the split within a single graph you put the variable in the GROUP = section.
For splitting it to mulitple graphs, put that variable in the BY statement instead.

You don't provide data so we're kinda guessing here.

proc sgplot data=have;
by var_for _each graph;
series x= year y=no_cit_per_year / group = person_ctry_code;
run;

If you want multiple graphs with different variables it's probably easiest to use multiple SGPLOT statements or restructure your data to support the BY processing.

Re: create the line chart

Alexxxxxxx — Tue, 19 Nov 2019 22:39:40 GMT

the file is added in the attachment. please have a look.

besides, by using the code

proc sgplot data=Results.PATSTAT_no_full_hrm_with_ctry5;
by person_ctry_code;
series x= year y=no_app_per_year / group = person_ctry_code;
series x= year y=no_cit_per_year / group = person_ctry_code;
run;

I get a serious picture like

it looks much better now,

however, I expect to get a picture of each "person_ctry_cod" and for each picture, there are two lines, one is the no_app_per_year, one is no_cit_per_year. for current picture, the explanation of line and Y-axis are wrong.

Could you please give me some suggestions about this?

thanks in advance

Re: create the line chart

Reeza — Tue, 19 Nov 2019 22:46:27 GMT

Remove the GROUP variable entirely.

Re: create the line chart

Alexxxxxxx — Tue, 19 Nov 2019 23:15:44 GMT

Thanks,

now I get a serious picture like

Is there any method to put them together like the Figure2.1,

and

1.delete the explanation at the Y-axis

2. replace ALL with no_app_per_year, replace By corporation with no_cit_per_year,

3. replace "PERSON_CTRY_CODE=AT" with "AT"?

Sorry, I have a lot of questions. I just start to learn how to use SAS to draw the line chart

Re: create the line chart

Reeza — Tue, 19 Nov 2019 23:17:50 GMT

You really should start with what you have and what you want. Use SGPANEL for this type of graph.
Not sure how the legend part would work you'll need to customize that with keylegend.

Re: create the line chart

Ksharp — Wed, 20 Nov 2019 12:28:10 GMT

Heat Map ?