cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JHE
‎01-18-2024
  • 164 Posts
  • 10 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: Expected numeric precision behaviour or unexpected issue?

by Obsidian | Level 7 in SAS Programming
‎08-10-2017 09:56 AM
‎08-10-2017 09:56 AM
run this. %macro liblonname (lib=,lob=); data claims_&lob, (keep=lob--medicare_indicator); set &lib..facets_claims; where '01JUN2017'd <= datepart(service_from_date) <= '31JUL2017'd and medicare_indicator="N"; run; %mend liblobname;   please see attach log file. ... View more

Re: Expected numeric precision behaviour or unexpected issue?

by Obsidian | Level 7 in SAS Programming
‎08-10-2017 09:39 AM
‎08-10-2017 09:39 AM
ok, I will try . ... View more

Re: Expected numeric precision behaviour or unexpected issue?

by Obsidian | Level 7 in SAS Programming
‎08-10-2017 09:38 AM
‎08-10-2017 09:38 AM
before it works, not sure what went wrong , dose not working any more....   I need %macro for this....       ... View more

Expected numeric precision behaviour or unexpected issue?

by Obsidian | Level 7 in SAS Programming
‎08-10-2017 09:08 AM
‎08-10-2017 09:08 AM
I have the SAS code: %Macro liblobname(lib,lob); PROC SQL; CREATE TABLE WORK.CLAIMS_&lob AS SELECT distinct t1.LOB, t1.CLAIM_ID, t1.MEMBER_ID, t1.MEMBER_AGE, t1.SERVICE_FROM_DATE, t1.SERVICE_CATEGORY, t1.Diag1, t1.Diag2, t1.Diag3, t1.Diag4, t1.Diag5, t1.SERVICE_FROM_DATE, T1.MEDICARE_INDICATOR FROM &lib..FACETS_CLAIMS t1 WHERE t1.SERVICE_FROM_DATE >= '1Jun2016:0:0:0'dt AND t1.SERVICE_FROM_DATE <= '31Jul2017:0:0:0'dt AND T1.MEDICARE_INDICATOR='N'; QUIT; %MEND liblobname; %liblobname (KMHP0100,0100);   coudl not find what is wrong, no error message, but no result .... could not resolve, please advise. thank you.   log: _ 49 1 ! ;*";*/;quit;run; NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended.     ... View more

Re: INSERT Errors

by Obsidian | Level 7 in SAS Programming
‎07-13-2017 06:40 PM
‎07-13-2017 06:40 PM
Ok, I havev cheeckd coulmns, found out wrong column.   Thank you, now is working.     ... View more

INSERT Errors

by Obsidian | Level 7 in SAS Programming
‎07-13-2017 05:25 PM
‎07-13-2017 05:25 PM
My SAS CODE:   PROC SQL; INSERT INTO Member_ICD10_LOB SELECT LOB, Member_ID, Last_Name, First_Name, Disease_Name, DIAG1, DIAG2, DIAG3, DIAG4, DIAG5, SERVICE_FROM_DATE FROM Member_Claims_0100; QUIT;   Get error:   ERROR: INSERT statement does not permit correlation with the table being inserted into. ERROR: The reference to Disease_Name appears to refer to a variable in the table being inserted into.   ... View more

Re: Calculate Days different

by Obsidian | Level 7 in SAS Programming
‎06-22-2017 10:53 AM
‎06-22-2017 10:53 AM
Yes, will consider the performance.   I have a another wired issue, related.   Mnth=19JUN2017:00:00:00.000   data Work.test1; set test1; format Mnth mmyys10.; Mnth=datepart(Mnth);   PROC SQL:    Create Table TestA  as     Select Mnth    from test1; QUIT;    Print data= TestA;     06/2017   But as soon as I Join table test1 with any other tables,    Print data=TestA  result would be as this : 01/1753   WHy this happend, how stranged ?         ... View more

Re: Calculate Days different

by Obsidian | Level 7 in SAS Programming
‎06-22-2017 09:42 AM
‎06-22-2017 09:42 AM
Thank you , it works. ... View more

Re: Calculate Days different

by Obsidian | Level 7 in SAS Programming
‎06-22-2017 09:41 AM
‎06-22-2017 09:41 AM
Thank you it works. ... View more

Calculate Days different

by Obsidian | Level 7 in SAS Programming
‎06-22-2017 09:31 AM
‎06-22-2017 09:31 AM
I ahve two dates:    Date1=  06JUN2017:00:00:00.000,     Date=   12JUN2017:00:00:00.000   Need calculate days between:   intck('DAY', Date1, Date2) format=comma10. AS TAT,   No result, it is .   Please advise.   Thank you   ... View more

Re: PROC Report

by Obsidian | Level 7 in ODS and Base Reporting
‎06-16-2017 02:34 PM
‎06-16-2017 02:34 PM
This code woks. /***************************************************************************/ ods excel options( sheet_name = 'Termed_Providers_Detail' embedded_titles='yes' EMBEDDED_FOOTNOTES= 'Yes' sheet_interval="table" frozen_headers='1' orientation='landscape' ); *RUN*; %let footnote2=; *data* Detail3 ; if _n_=*1* and eof then do; call symputx('footnote2','No data to report'); output; end; ELSE call symputx('footnote2',''); set detail3 end=eof; *run*; *PROC* *REPORT* DATA=Detail3; COLUMN Member_ID Member_Effective_Date Provider_ID Provider_Name COUNTY Provider_Term_Date Par_Non_Par; title " LOB 1300 Termed Provider Report Detail " ; compute after _page_ / left; line "&footnote2" ; endcomp; title " LOB 1300 Termed Provider Report Detail " ; footnote" Run at &sDay &stime"; *RUN*; ods _all_ close; ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Re: PROC Report

by Obsidian | Level 7 in ODS and Base Reporting
‎06-16-2017 02:16 PM
‎06-16-2017 02:16 PM
No excel sheet been created. I guess might should not using Proc Report, if using Proc Print might work. Attach log file for your refrence.   My code: %LET sDAY =%sysfunc(today(),DATE9.); %LET stime=%sysfunc(datetime(),TOD.); ods excel file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/LOB_1300_PP/Enrollment/Termed_Providers/2017/Termed_Providers_&Rpt_Dt1.-&Rpt_Dt2..xlsx" style=Print; ods excel options( sheet_name = '1300_Termed_Providers' embedded_titles='yes' EMBEDDED_FOOTNOTES= 'Yes' sheet_interval="table" frozen_headers='1' orientation='landscape' ); RUN; PROC REPORT DATA=Final3; COLUMN Member_ID Member_Effective_Date Provider_ID Provider_Name COUNTY Provider_Term_Date Par_Non_Par; title " LOB 1300 Termed Provider Report" ; footnote" Run at &sDay &stime"; RUN; /***************************************************************************/ ods excel options( sheet_name = 'Termed_Providers_Detail' embedded_titles='yes' EMBEDDED_FOOTNOTES= 'Yes' sheet_interval="table" frozen_headers='1' orientation='landscape' ); RUN; %let footnote2=; data to_report ; if _n_=1 and eof then do; call symputx('footnote2','No data to report'); output; end; set detail3 end=eof; run; PROC REPORT DATA=Detail3; COLUMN Member_ID Member_Effective_Date Provider_ID Provider_Name COUNTY Provider_Term_Date Par_Non_Par; title " LOB 1300 Termed Provider Report Detail " ; compute after _page_ / left; line "&footnote2" ; endcomp; title " LOB 1300 Termed Provider Report Detail " ; footnote" Run at &sDay &stime"; RUN; ods _all_ close; 　 　 　   ... View more

Re: PROC Report

by Obsidian | Level 7 in ODS and Base Reporting
‎06-16-2017 01:35 PM
‎06-16-2017 01:35 PM
Thank you, I am going to try . ... View more

Re: PROC Report

by Obsidian | Level 7 in ODS and Base Reporting
‎06-16-2017 12:34 PM
‎06-16-2017 12:34 PM
when it has the data, not having lots of rows, most is 100 records... ... View more

Re: PROC Report

by Obsidian | Level 7 in ODS and Base Reporting
‎06-16-2017 12:33 PM
‎06-16-2017 12:33 PM
Dynamically meet the criteria , some time has the result, some time dose not have the result, I want have the reprot, even dose nto have the result, just blank sheet with tile and footnote. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-18-2024 01:58 AM
Likes given to
Likes from
View All
Quick links