Hi All, I need some help using custom colors in Vertical Bar Charts. I am using SGPLOT / VBAR statement and version is SAS 9.3. Here is the simple example of what I have. But I would like to use user defined colors (let's say blue green yellow black brown etc etc). Is there a quick and simple way to do that? Thank you for all your help. P.S. data shoes; set sashelp.shoes; where region in ('Africa', 'Middle East', 'United States', 'Canada'); run; proc sgplot data=shoes; vbar region / response=sales group=product groupdisplay=stack stat=sum; run; ... View more

Hi All, This is my first attempt to use Proc Document while still preserving the ODS Layout in my PDF Output Destination. I am using SAS 9.3. For this example I am using sashelp.stocks dataset. Here is what I am trying to achieve: I want 3 plots in each page. 1st page will have 1 column and 3 plots. 2nd page has 2 columns: Column 1 has 2 plots & Column 2 has 1 plot. I was able to achieve it with the code below using ODS Gridded Layout but I want to preserve this layout when I use PROC DOCUMENT Later on. /*This codes gives me the layout I want*/ %macro plot_stocktrend(company); ods graphics on /height=4in width=5in border=on; proc sgplot data=sashelp.stocks(where=(date >= "01jan2000"d and stock = "&company.")) description= "Stock Trend : &company";; title "Stock Trend : &company"; series x=date y=close; series x=date y=low; series x=date y=high; run; title; %mend plot_stocktrend; %macro plot_volume(company);   proc sgplot data=sashelp.stocks (where=(date >= "01jan2000"d                                     and date <= "01jan2001"d                                    and stock = "&company.")) description= "Stock Volume : &company";;   title "Stock Volume vs. Close : &company."; vbar date  /response=volume; vline date /response=close y2axis; run; title; %mend plot_volume; title; goptions reset=goptions device=sasprtc target=sasprtc ftext='Arial' ftitle='Arial/bold' ; options orientation = portrait papersize = letter nodate nonumber; ods _all_ close; ods noproctitle; ods pdf file     ="~/gridded_layout.pdf"  pdftoc=1 startpage=never; ods layout gridded columns=1 rows=3 row_heights = (3in 3in 3in ) row_gutter=.5in;   ods region height = 3in ;   %plot_stocktrend(IBM);   ods region height = 3in;   %plot_stocktrend(Intel);   ods region height = 3in;   %plot_stocktrend(Microsoft);   ods layout end;   ods pdf startpage=now;   ods layout gridded columns=2 rows=3 row_heights = (3in 3in 3in ) row_gutter=.5in;   ods region height = 3in ;   %plot_volume(IBM);   ods region height = 3in;   %plot_volume(Intel);   ods region height = 3in;   %plot_volume(Microsoft);   ods layout end;   ods pdf close; OUTPUT: PAGE 1 This example has just 6 plots arranged in 2 pages. But in reality I have over 150 plots that I need to output to PDF. Thus in my PDF, I also need a good bookmark so that it will be easy to navigate the plots. To achieve that I want to use ODS Document Destination and Proc Document. But at the same time I want to preserve my original layout that I have shown above. I have used the code below. This creates a good navigation panel. But the layout is not preserved. It outputs one plot in each page. I need to modify this code so that I can somehow  use my ODS Gridded Layout statement. If there is any other techniques to achieve this, I would be happy to use that as well. Please advise. ods document name=mydocument(write);   %plot_stocktrend(IBM);   %plot_stocktrend(Intel);   %plot_stocktrend(Microsoft);    %plot_volume(IBM);   %plot_volume(Intel);   %plot_volume(Microsoft);   ods document close; proc document name=mydocument; list / levels=all; run; proc document name=mydocument;   make trend,volume; setlabel \trend#1  "Stock Trend"; setlabel \volume#1 "Stock Volume"; copy \Sgplot#1\SGPlot#1 to \trend#1; copy \Sgplot#2\SGPlot#1 to \trend#1; copy \Sgplot#3\SGPlot#1 to \trend#1;   copy \Sgplot#4\SGPlot#1 to \volume#1;   copy \Sgplot#5\SGPlot#1 to \volume#1;   copy \Sgplot#6\SGPlot#1 to \volume#1;   run; quit; title;   goptions reset=goptions device=sasprtc target=sasprtc ftext='Arial' ftitle='Arial/bold' ;   options orientation = portrait papersize = letter nodate nonumber;   ods _all_ close;   ods noproctitle;   ods pdf file     ="~/gridded_layout_w_doc.pdf"  pdftoc=1;   proc document name=mydocument;   replay \trend#1;   replay \volume#1;   run;   quit;   ods pdf close; RESULTS: Navigation Panel is exactly what I need. But plots are one per page. ... View more

Hi All, I am plotting some descriptive statistics of a variable over time to visualize the variable coverage. X axis is the month.It spans from 2004-01-01 to 2014-05-01 on a monthly basis. I am using SGPLOT on sas 9.3 and here is the code I am using. (The data is also attached below). proc sgplot data=percentiles; where portfolio='AAA'; series x=date y=score_p5       / lineattrs=(color=CXAAA03E    thickness=2 pattern=solid) curvelabel='P05'  curvelabelloc=inside curvelabelpos=max; series x=date y=score_p25      / lineattrs=(color=CXff750         thickness=2 pattern=solid) curvelabel='P25'  curvelabelloc=inside curvelabelpos=max; series x=date y=score_mean     / lineattrs=(color=CX84351D   thickness=2 pattern=solid) curvelabel='MEAN' curvelabelloc=inside curvelabelpos=max; series x=date y=score_p50      / lineattrs=(color=CXD1836D    thickness=2 pattern=solid) curvelabel='P50'  curvelabelloc=inside curvelabelpos=max; series x=date y=score_p75      / lineattrs=(color=CX5A1804     thickness=2 pattern=solid) curvelabel='P75'  curvelabelloc=inside curvelabelpos=max; series x=date y=score_p95      / lineattrs=(color=black             thickness=2 pattern=solid) curvelabel='P95'  curvelabelloc=inside curvelabelpos=max; needle x=date y=score_miss_pct / y2axis lineattrs=(thickness=3 color=CX4D946E ) transparency=.70; xaxis label="Month"  grid values=("01Jan2004"d to "01Dec2015"d by 1) interval=month type=discrete fitpolicy=rotatethin; yaxis  label="SCORE"; y2axis grid label="Percent Missing"; title "VAR = Score; PORTFOLIO=AAA"; run; I need help with the following: 1. The date on the x axis is at an angle. I want to rotate that vertically. In SAS GRAPH there was a rotate option. I need to find a way to do that in SGPLOT. 2. I want the title inside of the box. 3. In the data (attached below), there are two portfolio - AAA and BBB. This plot is only for AAA. I want to show the same plot but in a panel for both the portfolios. This will help me see it across different portfolio. I tried    SGPANEL but with not much success. I am hoping someone could help. I have not used GTL but would be open to that if there is a way to display this in a panel. 4.Eventually i want this to output on a PDF. In the PDF however, the image seems a little distorted. I have tried DPI but still it is not as good. Please share tips that has worked for you. I would appreciate any help/suggestions, codes would be even better Thank you, ... View more

Hi Everyone, I need a statistical test to show that the distribution of two samples are the same. I was thinking I could probably test to see if both the distributions are normal or not but then it necessarily does not have to be a normal distribution and these could be any other distribution. So this might not work for my case. Is there a way i could test that the distibutions are the same. Any code/examples will be very helpful. Thank you, PS. ... View more