ods pdf file fit on one page. when user oopen the pdf file, by defualt the viewable size very small, they need to resize make it readable. If they want to print ,  pdf file always stay on small size, how to solve this issue, how to set uo pdf default size as the normall readable size?   thank yo ... View more

agrere, that is the solution! ... View more

data _null_; dEnd=intnx('dtmonth', dhms(today(),0,0,0),-1,'e'); dStart=intnx('dtMonth', dhms(today(),0,0,0),-1,'b'); Call symputx('dmstart',PUT(dStart,DATEampm22.)); Call symputx('dmEnd',PUT(dEnd,DATEampm22.)); run; %PUT &dmstart &dmEnd   result is:   01APR2017:12:00:00 AM 30APR2017:11:59:59 PM   Extra in red.  how to remove extra.   ... View more

I need 4 digital of the year.   01APR2017:12:00:00 AM 30APR2017:11:59:59 PM   this would not work:becasue it has 2 digital of the year. data _null_; dEnd=intnx('dtmonth', dhms(today(),0,0,0),-1,'e'); dStart=intnx('dtMonth', dhms(today(),0,0,0),-1,'b'); Call symputx('dmstart',PUT(dStart,dateampm.)); Call symputx('dmEnd',PUT(dEnd,dateampm.)); run; %PUT &dmstart &dmEnd; ... View more

If  I need out put as this format:   01APR2017:12:00:00 AM 30APR2017:11:59:59 PM   How to get...   data _null_; dEnd=intnx('dtmonth', dhms(today(),0,0,0),-1,'e'); dStart=intnx('dtMonth', dhms(today(),0,0,0),-1,'b'); Call symputx('dmstart',PUT(dStart,dateampm.)); Call symputx('dmEnd',PUT(dEnd,dateampm.)); run; %PUT &dmstart &dmEnd;   01APR17:12:00:00 AM 30APR17:11:59:59 PM   not as 2017     ... View more

Peferct it works. Thank you Very much. ... View more

Perfect, it works. ... View more

thank you !, going  to try ... View more

Thank you I am goign to try. ... View more

HI data _null_; dEnd =intnx('Month', today(), -1,'e'); dStart =intnx('Month', today(), -1,'b'); Call symput('dmstart',CATS("'",PUT(dStart,DATE9.),"'")) Call symput('dmEnd',CATS("'",PUT(dEnd,DATE9.),"'"));   run;   iI want reult :      dmStart 00:00:00                           dmEnd  23:59:59 ... View more

Thank  you ! it works! Wonderful. ... View more

if Need put mutiple report for same PDF file, but would be mutiple page, this would not working.   ods listing close; options orientation=landscape papersize=(100in 100in) nonumber topmargin=.25in bottommargin=.25in leftmargin=.25in rightmargin=.25in; ods escapechar='^'; ods pdf file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/TPL_Membership/Summary/TPL_Membership_Summary.pdf"; PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0100; COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY; DEFINE MONTH/GROUP; DEFINE MONTH/ORDER descending; title " LOB 0100 TPL Membership" ; footnote" Run at &sDay &stime" ; RUN; options orientation=landscape papersize=(100in 100in) nonumber topmargin=.25in bottommargin=.25in leftmargin=.25in rightmargin=.25in; ods escapechar='^'; PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0500; COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY; DEFINE MONTH/GROUP; DEFINE MONTH/ORDER descending; title "LOB 0500 TPL Membership"; footnote" Run at &sDay &stime" ; RUN; ods pdf close; ... View more

This works!   Thank you !   ods listing close; options orientation=landscape papersize=(100in 100in) nonumber topmargin=.25in bottommargin=.25in leftmargin=.25in rightmargin=.25in; ods escapechar='^'; ods pdf file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/TPL_Membership/Summary/TPL_Membership_Summary.pdf"; PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0100; COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY; DEFINE MONTH/GROUP; DEFINE MONTH/ORDER descending; title " LOB 0100 TPL Membership" ; footnote" Run at &sDay &stime" ; RUN; ods pdf close; ... View more

thank you ... View more