About JHE

JHE · ‎08-24-2017

I resolved myself. Paid_Fina&lobname.TRANS ---- name too long , change to Paid&lobname.TRANS it works. Thank you all !

JHE · ‎08-24-2017

you mean &lobname.trans? &lobname i sMacro Varible.

JHE · ‎08-24-2017

My code: %MACRO lobcodecount(lobname); PROC SORT DATA=REWORKO.REWORK&lobname._CODECOUNT; BY LOB Category Code CODE_DESCRIPTION; RUN; PROC SORT DATA=Paid_Fina&lobnameTRANS; BY LOB Category Code CODE_DESCRIPTION; RUN; DATA REWORKO.REWORK&lobname._CODECOUNT_FINAL; MERGE REWORKO.REWORK&lobname._CODECOUNT WORK.PAID_FINA&lobnameTRANS; BY LOB Category Code CODE_DESCRIPTION; RUN; %Mend lobcodecount; %lobcodecount(0500); WORK.Paid_Fina&lobnameTRANS; macro varible &lobnameTRANS would not be able applyied. why ? Had the errors on Merger step. Error message: REWORKO.REWORK&lobname._CODECOUNT WORK.Paid_Fina&lobnameTRANS; BY LOB Category Code CODE_DESCRIPTION; RUN; _ 22 200 WARNING: Apparent symbolic reference LOBNAMETRANS not resolved. ERROR: File WORK.PAID_FINA.DATA does not exist. ERROR: File WORK.LOBNAMETRANS.DATA does not exist. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, END, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored.

JHE · ‎08-22-2017

I have LOB = 0100, there is a leading Zero. After ods excel using PROC REPORT, define LOB/style(column)={tagattr='Format:@' just=center cellwidth=0.9 in}; the excel file , LOB has the value =100, missing the leading zero.

JHE · ‎08-22-2017

My code: ODS LISTING CLOSE; ods excel file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/Rework/&dtMonth._Rework.xlsx" style=Print; ods excel options( sheet_name = '0100' embedded_titles='yes' EMBEDDED_FOOTNOTES= 'Yes' sheet_interval="table" orientation='landscape' ); RUN; PROC REPORT DATA=REWORKO.REWORK0100_SUMAMRY STYLE(COLUMN)= [font_size=10 pt cellwidth=.14 in height=.2in] style(header)=[font_size=11 pt height=.4in background=silver ] style(summary)=[font_weight=bold]; /*define LOB / style(column)=[cellwidth=.6in];*/ define LOB/style(column)={tagattr='Format:Text:$4.' just=left cellwidth=0.6 in}; run; ods _all_ close; LOB =0100, but when ods to excel output , LOB = 0100, what I should do can fix this.

JHE · ‎08-21-2017

works now... thank you

JHE · ‎08-21-2017

Not sure why this code has the errors, could not find out why : %macro dellob(lobname,lobdate); PROC SQL; delete * from reworko.rework&lobname_sumamry WHERE MONTH=&lobdate; QUIT; %mend dellob; %dellob(0500,'2017-07'); Error message: delete * from reworko.rework&lobname_sumamry WHERE MONTH=&lobdate; QUIT; _ 22 200 WARNING: Apparent symbolic reference LOBNAME_SUMAMRY not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, AS, WHERE. ERROR 200-322: The symbol is not recognized and will be ignored.

JHE · ‎08-16-2017

I need to use ods create excel report. need side by side for two defferent tables . Report excel format as attached. How to I can creat an ampty excel cell between two report columns.

JHE · ‎08-10-2017

ok, will do

JHE · ‎08-10-2017

A date value , = 8Feb2017:00:00:00

JHE · ‎08-10-2017

Oh, I see, what I should do ,,,, the correct way ?

JHE · ‎08-10-2017

Yes, it is 08FEB2017:00:00:00 Other condition as below: ((substr(t1.bill_type,1,2) not in('11','12','21','22','26') and substr(t1.bill_type,2,2) not in('11','12','21','22','26'))) If I am using : WHERE (t1.CLAIM_ADMIT_DATE BETWEEN '8Feb2017:0:0:0'dt AND '8Aug2017:0:0:0'dt) AND (substr(t1.bill_type,1,2) not in('11','12','21','22','26') and substr(t1.bill_type,2,2) not in('11','12','21','22','26')); I am able to have reult. but If I am using: WHERE (t1.CLAIM_ADMIT_DATE >= TODAY()-183 AND t1.CLAIM_ADMIT_DATE <=TODAY()-7)) AND (substr(t1.bill_type,1,2) not in('11','12','21','22','26') and substr(t1.bill_type,2,2) not in('11','12','21','22','26')); Will no result at all. also if I am only using: WHERE (t1.CLAIM_ADMIT_DATE >= TODAY()-183 AND t1.CLAIM_ADMIT_DATE <=TODAY()-7) I will get the result. make me cry.

JHE · ‎08-10-2017

My code, in a Proc SQL 1. if I am using : WHERE (t1.CLAIM_ADMIT_DATE BETWEEN '8Feb2017:0:0:0'dt AND '8Aug2017:0:0:0'dt) it will have data return. with 'other' condition. 2. If I am using: (t1.CLAIM_ADMIT_DATE >= TODAY()-183 AND t1.CLAIM_ADMIT_DATE <=TODAY()-7) only, will have data return. 3. but If I am using: (t1.CLAIM_ADMIT_DATE >= TODAY()-183 AND t1.CLAIM_ADMIT_DATE <=TODAY()-7) with same 'other' condition, wil no data return. why

JHE · ‎08-10-2017

after start new session, it works. Thank you

JHE · ‎08-10-2017

agree, I am starting a new sestion.

Online Status	Offline
Date Last Visited	‎01-18-2024 01:58 AM

Calculation of member enrollment by month -- member month MM

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Member enrollment month

Re: Count monthly disenrollment

Count monthly disenrollment

Re: Date format

Re: Date format

Re: integrate rows

Re: Dollar format

Re: Merge or cancandinate the row with same ID

Re: Dynamic Varible in the table

Re: how to check if a variable not exists in a dataset first then proc...

Re: Dynamic Varible in the table

Re: %macro?

Re: %macro?

%macro?

Re: ods excel proc report output

ods excel proc report output

Re: Macro

Macro

ods excel report

Re: PROC SQL

Re: PROC SQL

Re: PROC SQL

Re: PROC SQL

PROC SQL

Re: Expected numeric precision behaviour or unexpected issue?

Re: Expected numeric precision behaviour or unexpected issue?