Understood. ... View more

The NOTE means that SAS does not know how to "match" the records in the two data sets. One should never ignore that note and instead perform a correct merge. ... View more

Hi. You cannot do a many-to-many merge via data steps if you only have one common key variable (in your case, ID) because SAS does not know how to "match" the say 11 records from B to the 35 records in A? So you need at least another "key" variable that will help you identify uniquely each record in your data set (s). For example, it would be very helpful if the dollar amt breakdown would have a code associated with it. Then you could sort both data sets by ID Code, then merge them by ID Code. PROC SQL would work very well on your problem.:smileycool: ... View more

Hi, one way that would work nicely would be to use PROC GREPLAY. First, for each of your graphs (graph 1, graph2, graph3) you will need to assign a name to them. You can do that by simply adding the name = "graph1" option for each of your graphs.(please make sure to name them differently, such as graph1, graph2 and graph3). You also need to modify the size of your window by using goptions hsize = 6in vsize = 6in (for each of your three graphs) Once that is accomplished, you can then use the GREPLAY procedure (please note the change in window size, again) goptions reset = all; options orientation = landscape; ods pdf file = "&your_path.\test.pdf"; goptions device = pdf rotate = landscape gsfmode = replace        hsize = 12in vsize = 12in; proc greplay igout = work.gseg   tc = sashelp.templt template = u1d2s     nofs nobyline ;     treplay 1:graph1 2:graph2 3:graph3; run;quit; ods pdf close; I hope this helps. Best of luck! ... View more

Hi, If you cannot use SGPANEL then you are left with the PROC GREPLAY option. In order to use this PROC you need to assign a name to each of your four charts by adding the option  name = "first" (or name = "second") ... PROC GCHART DATA=final4;       VBAR3D        MONTH/ descending  name = "fourth"       SUMVAR=answered_cnt       group=abondoned_cnt       SHAPE=BLOCK FRAME TYPE=SUM       LEGEND=LEGEND1       COUTLINE=BLACK          RAXIS=AXIS1       MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; You will then have to invoke PROC GREPLAY three times. Each of these times you will use the "h2" template, which is 2 horizontal plots. You also need to "adjust" the graphing window accordingly, thus making the horizontal line 6 inches, and the vertical one stays 3 inches. goptions hsize = 6in vsize = 3in; proc greplay igout = work.gseg   tc = sashelp.templt template = h2     nofs nobyline ;     treplay 1:one 2:two; run;quit; goptions hsize = 6in vsize = 3in; proc greplay igout = work.gseg   tc = sashelp.templt template = h2     nofs nobyline ;     treplay 1:three 2:four; run;quit; Both of these GREPLAY PROCs will produce 'template" and "templat1" in your work.gseg folde goptions reset = all; options orientation = landscape; ods pdf file = "&path.\test.pdf"; goptions device = pdf rotate = landscape gsfmode = replace        hsize = 12in vsize = 3in; proc greplay igout = work.gseg   tc = sashelp.templt template = h2     nofs nobyline ;     treplay 1:template 2:templat1; run;quit; ods pdf close; The downsize of this approach is that everytime you run your PROC GCHART/GREPLAY you will first need to delete the content of your work.gseg folder, otherwise you will get a warning such as, "Graph's name, FOUR, changed to FOUR1. FOUR is already used or not a valid SAS name." A way to fix this would be to use proc greplay igout = work gseg nofs;      delete _all_; run;quit; All the best! ... View more

Could you provide an example (visual example) of what you want? It's not very clear to me. Thanks. ... View more

Hi. PROC EXPORT does not keep formats, but the ODS tagsets does. Below is a sample code that will keep ALL your formats.        ods listing close;              ods tagsets.excelxp path = "&output_path." file="&data..xml"              style=analysis      options(absolute_column_width='10,10,8,8,10,10,15,8,15,8,15,10,8,8,8,8,10,10,15,8,15,8,15,10,8,8,8,8,20'          sheet_label=' ');         ods tagsets.excelxp options(sheet_name="sheetname");              proc print noobs label data = &data.;                  var your_variables;              run;         ods tagsets.excelxp close;         ods listing; Good luck! ... View more

I assume something is not quite right with your data, but maybe I don't understand it. The reason for me saying this is because I can't figure out what the n12, n24 and n36 variables represent. Anyhow, here is a code that will create a table of your data below the plot. proc template;        define statgraph cmtrix;  begingraph / includeMissingDiscrete=true border=false; layout gridded; layout datalattice columnvar = qstest/ ; layout prototype; barchart X=week y=mean / group=week barlabel=false orient=vertical name='a'; endlayout; endlayout; layout lattice / columns = 1 rowweights = (.15 .25); blockplot x=qstest block=n12 /class = week repeatedvalues=true display=(values label outline) valuehalign=center label='Week 12' valueattrs=graphdata1 labelattrs=graphdata1; blockplot x=qstest block=n24 /class = week repeatedvalues=true display=(values label outline) valuehalign=center label='Week 24' valueattrs=graphdata2 labelattrs=graphdata2; blockplot x=qstest block=n36 /class = week repeatedvalues=true display=(values label outline) valuehalign=center label='Week 36' valueattrs=graphdata3 labelattrs=graphdata3; discretelegend 'a' / title='Week: ' across=3 border=false; endlayout; endlayout; endgraph; end;      run; Let me know if this makes any sense to you. (It hardly does to me) Good luck! ... View more

Instead of proc datasets library=data; modify population_2012; format birth_date ddmmyy10.; run; quit; You may want data want;      set  population_2012;      new_dob = birthdate;      format new_dob  ddmmyy10.; run; Then you may want to try to use ODS Tagset instead of export (be sure to change the bolded items) (because the proc export does not keep formats)         ods listing close;         ods tagsets.excelxp path = "&output_path." file="&data..xml"         style=analysis         options(absolute_column_width='10,10,8,8,10,10,15,8,15,8,15,10,8,8,8,8,10,1­0,15,8,15,8,15,10,8,8,8,8,20'         sheet_label=' ');         ods tagsets.excelxp options(sheet_name="sheetname");         proc print noobs label data = &data.;         var your_variables;         run;         ods tagsets.excelxp close;         ods listing; Good luck! ... View more