cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
michokwu
‎01-05-2023
  • 107 Posts
  • 13 Likes Given
  • 1 Solutions
  • 4 Likes Received

Re: Multiple graphs per page to multiple PDF pages

by Quartz | Level 8 in ODS and Base Reporting
‎08-22-2019 12:41 PM
‎08-22-2019 12:41 PM
options leftmargin=.25in rightmargin=.25 topmargin=.25in bottommargin=.25 number date; ods pdf file="&path/tasks/stl_conf/conf_new/report18.pdf" style=calibri startpage=never notoc dpi=300; title font=Helvetica bold h=10pt "Group1 vs Group2: Charts showing the change in variables with confidence interval"; ods layout gridded rows=2 columns=2 column_widths=(3in 3in); ods region; ods graphics/height=5in width=4in; /*Plot age group1*/ proc sgplot data=hist2.pop_by_age1 noautolegend; styleattrs datacolors=(BIB VLIGB) datacontrastcolors=(gray); vbarparm category=Age_group response=Delta_Age /group=group groupdisplay=cluster fillpattern limitlower=L_Age limitupper=U_Age limitattrs=(color=vipr); title font=Helvetica bold h=8pt 'Population Change by Age'; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='Age' labelattrs=(size=8pt); run; ods region; ods graphics/height=5in width=4in; /*Plot age group2*/ proc sgplot data=kansas1.pop_by_age noautolegend; styleattrs datacolors=(virp parp) datacontrastcolors=(gray); vbarparm category=var1 response=Delta_Total /group=group groupdisplay=cluster fillpattern limitlower=L_Total limitupper=U_Total limitattrs=(color=vipr); title font=Helvetica bold h=8pt 'Population Change by Age'; title 'Kansas City Population Change 2010 to 2017 by Age'; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='Age' labelattrs=(size=8pt); run; ods region; ods graphics/height=5in width=4in; /*Plot educational attainment - 25years and over1*/ proc sgplot data=hist2.age25_above1 noautolegend; styleattrs datacolors=(BIB VLIGB) datacontrastcolors=(gray); vbarparm category=educational_attainment response=Delta_25_above / group=group groupdisplay=cluster fillpattern limitlower=L_Ed limitupper=U_Ed limitattrs=(color=vipr); title font=Helvetica bold h=8pt "Population Change by Educational attainment for 25 Years and Above"; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='Educational attainment' labelattrs=(size=8pt); run; ods region; ods graphics/height=5in width=4in; /*Plot educational attainment - 25years and over2*/ proc sgplot data=kansas1.edu_attainment noautolegend; styleattrs datacolors=(virp parp) datacontrastcolors=(gray); vbarparm category=educational_attainment response=Delta_Total / group=group groupdisplay=cluster fillpattern limitlower=L_Total limitupper=U_Total limitattrs=(color=vipr); title font=Helvetica bold h=8pt "Population Change by Educational attainment for 25 Years and Above"; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='Educational attainment' labelattrs=(size=8pt); run; ods startpage=now; ods layout gridded rows=2 columns=2 column_widths=(3in 3in); ods region; ods graphics/height=5in width=4in; /*Plot population by race1*/ proc sgplot data=hist2.race1 noautolegend; styleattrs datacolors=(BIB VLIGB)datacontrastcolors=(gray); vbarparm category=race response=Delta_Race / group=group groupdisplay=cluster fillpattern limitlower=L_Race limitupper=U_Race limitattrs=(color=vipr); title font=Helvetica bold h=8pt "Population Change by Race"; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='Race' labelattrs=(size=8pt); run; ods region; ods graphics/height=5in width=4in; /*Plot population by race2*/ proc sgplot data=kansas1.race1 noautolegend; styleattrs datacolors=(virp parp) datacontrastcolors=(gray); vbarparm category=race response=Delta_Total / group=group groupdisplay=cluster fillpattern limitlower=L_Total limitupper=U_Total limitattrs=(color=vipr); title font=Helvetica bold h=8pt "Population Change by Race"; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='Race' labelattrs=(size=8pt); run; ods region; ods graphics/height=5in width=4in; /*Plot population by school enrollment1*/ proc sgplot data=hist2.sch_enrollment1 noautolegend; styleattrs datacolors=(BIB VLIGB)datacontrastcolors=(gray); vbarparm category=school_enrollment response=Delta_Enrol / group=group groupdisplay=cluster fillpattern limitlower=L_Enrol limitupper=U_Enrol limitattrs=(color=vipr); title font=Helvetica bold h=8pt "Population Change by School Enrollment"; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='School Enrollment' labelattrs=(size=8pt); run; ods region; ods graphics/height=5in width=4in; /*Plot population by school enrollment2*/ proc sgplot data=kansas1.sch_enrollment noautolegend; styleattrs datacolors=(virp parp) datacontrastcolors=(gray); vbarparm category=school_enrollment response=Delta_Total / group=group groupdisplay=cluster fillpattern limitlower=L_Total limitupper=U_Total limitattrs=(color=vipr); title font=Helvetica bold h=8pt "Population Change by School Enrollment"; yaxis valueattrs=(size=4pt) label='Population change' labelattrs=(size=8pt); xaxis valueattrs=(size=4pt) label='School Enrollment' labelattrs=(size=8pt); run; ods layout end; ods _all_ close; ... View more

Re: Multiple graphs per page to multiple PDF pages

by Quartz | Level 8 in ODS and Base Reporting
‎08-22-2019 11:16 AM
‎08-22-2019 11:16 AM
I used the same code as pasted, however, I have been tweaking it to see what works When I included ods startpage=now/ reset; before the graphs in the 2nd page, it changes the page setup to 2 graphs per page with the graphs overlaying after the 4th graph   When I tried this after the 1st graph on the second page (i.e after the 5th graph)  it worked for the remaining graphs on the page but the 5th graph was on a single page. When I tried it before the 1st graph on the second page, the graphs overlay. ods startpage=now; ods region; ods graphics/height=5in width=4in; /*Plot Graphs*/ - proc sgplot procedure for the next set of graphs    Per your observation, it could be a case of me not applying the code correctly, if you can help with the correct code, that will be helpful. The original code is included in the post.   Thank you.   ... View more

Re: Multiple graphs per page to multiple PDF pages

by Quartz | Level 8 in ODS and Base Reporting
‎08-21-2019 12:20 PM
‎08-21-2019 12:20 PM
I just did! did not help ... View more

Re: Multiple graphs per page to multiple PDF pages

by Quartz | Level 8 in ODS and Base Reporting
‎08-21-2019 09:44 AM
‎08-21-2019 09:44 AM
No, I did not reset the startpage option ... View more

Re: Multiple graphs per page to multiple PDF pages

by Quartz | Level 8 in ODS and Base Reporting
‎08-21-2019 09:24 AM
‎08-21-2019 09:24 AM
No, I did not ... View more

Multiple graphs per page to multiple PDF pages

by Quartz | Level 8 in ODS and Base Reporting
‎08-19-2019 05:56 PM
‎08-19-2019 05:56 PM
Hello experts,   My SAS output is a collection of graphs, the destination is PDF and the graphs are grouped by 4 per page. After the first page, the the graphs reverts to 1 per page. I used the startpage=now option after the first 4 graphs to signal the beginning of the 2nd page but still have the graphs 1 per page.    I want the graphs to take the format of the 1st page where they are displayed 4 by page.   Thank you.   My code  ods pdf file="&path/tasks/stl_conf/conf_new/report14.pdf" style=calibri startpage=never notoc dpi=300; title font=Helvetica bold h=10pt "Charts showing the change in variables with confidence interval"; ods layout gridded rows=2 columns=2 column_widths=(3in 3in); ods region; ods graphics/height=5in width=4in; /*Plot Graphs*/ - proc sgplot procedure for the first 4 graphs ods startpage=now; ods region; ods graphics/height=5in width=4in; /*Plot Graphs*/ - proc sgplot procedure for the next set of graphs   ... View more

Re: Multiple graphs per page to PDF using sgplot

by Quartz | Level 8 in Graphics Programming
‎08-15-2019 03:22 PM
‎08-15-2019 03:22 PM
Thank you! ... View more

Re: Multiple graphs per page to PDF using sgplot

by Quartz | Level 8 in Graphics Programming
‎08-15-2019 03:22 PM
‎08-15-2019 03:22 PM
Thanks for the feedback. Cynthia's option worked. ... View more

Multiple graphs per page to PDF using sgplot

by Quartz | Level 8 in Graphics Programming
‎08-15-2019 12:48 PM
‎08-15-2019 12:48 PM
Hello experts,   I am using proc sgplot to graph and sending my output, which is multiple graphs in one page to PDF, however, when I run the code the graphs are placed vertically instead of horizontally. I am obviously doing something wrong. Please see my code below. ods _all_ close; ods pdf file="&path/tasks/stl_conf/conf_new/report9.pdf" style=calibri startpage=never notoc dpi=300; ods graphics / reset=all height=3in width=4in; ods layout gridded columns=2; proc sgplot data=hist2.pop_by_age1 noautolegend; styleattrs datacolors=(BIB VLIGB) datacontrastcolors=(gray); vbarparm category=Age_group response=Delta_Age /group=group groupdisplay=cluster fillpattern limitlower=L_Age limitupper=U_Age limitattrs=(color=vipr); title 'Change by Age'; yaxis label='change'; xaxis label='Age'; run; proc sgplot data=hist2.age25_above1 noautolegend; styleattrs datacolors=(BIB VLIGB) datacontrastcolors=(gray); vbarparm category=educational_attainment response=Delta_25_above / group=group groupdisplay=cluster fillpattern limitlower=L_Ed limitupper=U_Ed limitattrs=(color=vipr); title "Change by Educational attainment for 25 Years and Above"; yaxis label='change'; xaxis label='Level of educational attainment'; run; ods pdf close; ods preferences; ods layout end;     ... View more

Re: Using group and styleattrs statements in proc sgplot

by Quartz | Level 8 in Graphics Programming
‎06-20-2019 12:23 PM
‎06-20-2019 12:23 PM
Thank you so much. It works. ... View more

Using group and styleattrs statements in proc sgplot

by Quartz | Level 8 in Graphics Programming
‎06-20-2019 10:58 AM
‎06-20-2019 10:58 AM
Hello Experts,   I use SAS 9.4 and am trying to plot bar charts with confidence intervals using proc sgplot. I want to differentiate one bar from the others by using a different color and created a column for group, assigning '1' to it and '2' to the rest.  'Test' is the output without assigning color to the groups 'Test1' is the output when I assign color (notice the error bars are gone) I would like to have the different colors but retain the error bars and remove the group label at the bottom of the chart. See code below: For test /*Plot age group*/ ods listing gpath="&path/tasks/stl_conf/conf_new"; ods graphics / imagename="test1" imagefmt=png; proc sgplot data=hist2.pop_by_age1; styleattrs datacolors=(STYBR LIGRYBR); vbarparm category=age_group response=Delta_Age / limitlower=L_Age limitupper=U_Age; title 'City Population Change by Age Group'; yaxis label='Population change'; xaxis label='Age'; run; For test1 /*Plot age group*/ ods listing gpath="&path/tasks/stl_conf/conf_new"; ods graphics / imagename="test1" imagefmt=png; proc sgplot data=hist2.pop_by_age1; styleattrs datacolors=(STYBR LIGRYBR); vbarparm category=age_group response=Delta_Age / group=group limitlower=L_Age limitupper=U_Age; title 'City Population Change by Age Group'; yaxis label='Population change'; xaxis label='Age'; run;   Thank you. ... View more

Re: SGPLOT not returning desired result

by Quartz | Level 8 in New SAS User
‎05-28-2019 03:51 PM
‎05-28-2019 03:51 PM
data WORK.ED_TABLE; infile datalines dsd truncover; input Year:$8. Total:$3. Bachelors:$3. Doctorate:$3. HSG:$3. Non_HSG:$3. Masters:$3. Professional:$3. Some_College:$3.; label Year="NAME OF FORMER VARIABLE"; datalines; 2010 100 100 100 100 100 100 100 100 2011 100 104 96 98 94 107 96 105 2012 101 108 106 94 92 109 97 109 2013 103 114 129 94 90 113 99 110 2014 103 117 133 92 89 119 101 111 2015 104 124 136 90 85 127 103 112 2016 104 126 157 88 83 132 111 112 2017 105 129 166 90 77 139 122 112 ;;;; NOTE: There were 8 observations read from the data set WORK.ED_TABLE. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

Re: SGPLOT not returning desired result

by Quartz | Level 8 in New SAS User
‎05-28-2019 03:43 PM
‎05-28-2019 03:43 PM
Sorry, I don't have the log details anymore. I already updated the code using @PeterClemmensen 's suggestion.   I can go back, try using my initial input and revert ... View more

Re: SGPLOT not returning desired result

by Quartz | Level 8 in New SAS User
‎05-28-2019 03:34 PM
‎05-28-2019 03:34 PM
Thank you so much. It works. Does that mean we can't plot data using SAS dataset? How do we use datalines when we have a large data set? ... View more

SGPLOT not returning desired result

by Quartz | Level 8 in New SAS User
‎05-28-2019 03:11 PM
‎05-28-2019 03:11 PM
Hello,   I have the following SAS dataset , original data was adjusted using 2010 as a baseline Year Total Bachelors Doctorate HSG Non_HSG Masters Professional Some_College 2010 100 100 100 100 100 100 100 100 2011 100 104 96 98 94 107 96 105 2012 101 108 106 94 92 109 97 109 2013 103 114 129 94 90 113 99 110 2014 103 117 133 92 89 119 101 111 2015 104 124 136 90 85 127 103 112 2016 104 126 157 88 83 132 111 112 2017 105 129 166 90 77 139 122 112   and this is my code /* Plot the data */ proc sgplot data=ed_table; series x = Year y = Total / markers markerattrs=(symbol=plus) lineattrs=(pattern=solid); series x = Year y = Non_HSG / markers markerattrs=(symbol=diamondfilled) lineattrs=(pattern=solid); series x = Year y = HSG / markers markerattrs=(symbol=diamond) lineattrs=(pattern=solid); series x = Year y = Some_College / markers markerattrs=(symbol=starfilled) lineattrs=(pattern=solid); series x = Year y = Bachelors / markers markerattrs=(symbol=sqaurefilled) lineattrs=(pattern=solid); series x = Year y = Masters / markers markerattrs=(symbol=trianglefilled) lineattrs=(pattern=solid); series x = Year y = Professional / markers markerattrs=(symbol=homedownfilled) lineattrs=(pattern=solid); series x = Year y = Doctorate / markers markerattrs=(symbol=circlefilled) lineattrs=(pattern=solid); xaxis values= (2010 to 2017 by 1) label='5-Year Annual Estimate'; yaxis Label = 'Educational attainment adjusted for 2010 Baseline Year' Grid Values = (60 to 180 by 20); title1 "Educational attainment for 25years and above"; title2 "Annual Data - Baseline 2010";   Please see attached the output I am getting. I don't know why the graph is turning out empty.    Thank you.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-05-2023 12:58 PM
Group Hubs for michokwu
View All
Likes given to
Likes from
View All
Quick links