I have this SAS code,   why Merge the last step dose not working:   PROC SORT DATA=REWK0.REWORK0500_CODECOUNT; BY LOB Category Code CODE_DESCRIPTION; RUN;   PROC SORT DATA=REWK0.Paid0500TRANS OUT=Paid0500TRANS; BY LOB Category Code CODE_DESCRIPTION; RUN;   DATA work.REWORK0500_codecount; MERGE REWK0.REWORK0500_CODECOUNT Work.Paid0500TRANS; BY LOB Category Code CODE_DESCRIPTION; RUN; ... View more

I have data set as attached excel file as HDM_PAYMENT_PLAN, try to have report as   LOB  Service _Type  Month  HDM_PROVIDER   HDM_PAYMENT   with grand total monthly, and YTD.   My SAS code: PROC REPORT DATA=HDM_PAYMENT_PLAN; COLUMNS LOB SERVICE_TYPE MONTH HDM_PROVIDER HDM_PAYMNET TOTAL; DEFINE LOB/DISPLAY 'LOB'; DEFINE MONTH/DISPLAY 'MONTH'; DEFINE SERVICE_TYPE/DISPLAY 'SERVICE_TYPE'; DEFINE HDM_PROVIDER/DISPLAY 'HDM_PROVIDER'; DEFINE TOTAL/COMPUTED FORMAT= DOLLAR12.2 'HDM_PAYMNET'; RBREAK AFTER MONTH/SUMMARIZE UL; COMPUTE BEFORE MONTH; TOTAL=SUM(HDM_PAYMNET); ENDCOMP; RUN;   But code dose not working.   Also, if I want using Proc Traspose   PROC SORT DATA=HDM_PAYMENT_PLAN OUT=HDM_PAYMENT_PLANSORT;   BY MONTH LOB SERVICE_TYPE HDM_PROVIDER RUN;   PROC TRANSPOSE DATA = HDM_PAYMENT_PLANSORT (NAME=DAOP) LET; ID MONTH; BY SERVICE_TYPE HDM_PROVIDER; RUN;   Dose not working either, do not know what is wrong , what supporse chane can make it working.                   ... View more

I need to have a report, only need past 12  month data, is there a way from PROC Report to achieve it.   My Code:     data _null_; dMEnd=intnx('month', today(), -12, 'e'); Call symput('dtMEnd', PUT(dMEnd, YYMMD.)); run; %PUT &dtMEnd; PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0100 (MONTH >="&dtMEnd"); 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;     The code would not working... how to ? need advise. ... View more

ods output,   PROC REPORT ... define ConfigRework_Percent/computed format=percent10.2 style=[tagattr="format:##00.##00%"]; compute ConfigRework_Percent; ConfigRework_Percent=_c19_/_c12_; endcomp;   From SAS Proc Report output data:   I have data as: it should be the same value and format on excel file.                         0.002%                         1.60%                         0.61%   but ods Excel file the data change to:                       02.17696%                       159.6430%                        60.9298%   in order maintain the same value and format, what I should change ?    style=[tagattr="format:##00.##00%"];                 ... View more

I have tow questions about PROC REPORT:   1. My SAS code :   I need computed column with Cellwidth wide enough to hold % with certain length, otherwise will miss value or empty, the following code no errors but would not working either.     My Code as following:   define ConfigRework_Percent/COMPUTED 'ConfigRework_Percent' FORMAT=percent10.2 style=[tagattr="format:#,###.00%"] style(column)=[cellwidth=1.4in];   compute ConfigRework_Percent;      ConfigRework_Percent=_c19_/_c12_; endcomp;       ... View more