Hello Everybody I have a table with DX codes from 1 to 13. I received codes dx1-dx10 from one source and DX11-13 from another sources. Now I want to create a final file which has columns upto DX10 with update. since some of the ids do not have DX codes upto 10 I want to update values from DX11-DX13 into DX1-10 when there is no dx code and I have values in DX11-DX13.    Attached documents has current and expected table structure.      Thank you for your help.     ... View more

Hello Everybody,   I am using Below SAS code to combine my PDF files . I am using EG 7.1  /* Method 1 */ /* Turn off the Output window */ ods listing close; /* Open two ODS PDF instances, one creating COMBINED_1.PDF, and the other creating A.PDF */ ods pdf file="combined_1.pdf"; ods pdf(a) file="a.pdf"; proc report nowd data=sashelp.class(obs=10); title "In COMBINED.pdf and A.pdf"; run; /* Close A.PDF, but COMBINED.PDF remains open */ ods pdf(a) close; ods pdf(b) file="b.pdf"; proc report nowd data=sashelp.vtable(obs=20); title "In COMBINED.pdf and B.pdf"; column libname memname nobs nvar crdate; run; ods pdf(b) close; ods pdf(c) file="c.pdf" ; proc report nowd data=sashelp.class; title "In COMBINED.pdf and C.pdf"; run; ods pdf(c) close; ods pdf close;   which is from  http://support.sas.com/kb/35/375.html   I am able to append the pdf files with the no problem but TOC(Table of contents) looks different then what it was for individual PDF. I am wondering what am I missing here.             ... View more

Hello Everybody, I want to create one table and one graph in the same page of PDF output. I found SAS program  options nodate nonumber; ods pdf file='LayoutGriddedTitles.pdf'; title 'This is TITLE1'; footnote 'This is FOOTNOTE1'; ods layout gridded; ods region; title 'This is the REGION TITLE'; footnote 'This is the REGION FOOTNOTE'; proc print data=sashelp.class(obs=10); run; goptions hsize=4in vsize=4in; proc gchart data=sashelp.class; vbar age / name='gtitle'; title 'This is the PROCEDURE TITLE'; footnote 'This is the PROCEDURE FOOTNOTE'; run; quit; ods layout end; ods pdf close; from http://support.sas.com/documentation/cdl/en/odsug/67921/HTML/default/viewer.htm#p06ji2uhvayhq5n1eik2z2rf2ga8a.htm . My result output in SAS EG result window  looks fine but output file "LayoutGridedTitles.pdf" has two pages. Should not I get 1 page output rather than 2 here. I am wondering what did I miss here.           ... View more