About cmcquain

cmcquain · ‎03-15-2021

Enterprise Edition is using the sample size calculation for standard deviation. How do I force it to use the population standard deviation formula?

cmcquain · ‎01-24-2018

It's there. I just didn't copy and paste it.

cmcquain · ‎01-17-2018

You are correct I am using a pass through. I will start searching oracle joins then. Thank you

cmcquain · ‎01-17-2018

I am trying to use a subquery within a left join and I am getting this error. ERROR: ORACLE prepare error: ORA-00905: missing keyword. SQL statement: select WDM_HSBSB_SUBSC.SBSB_ID as CARD_HLDR_ID_NUM, WDM_HMEME_MEMBER.MEME_FIRST_NAME || ' ' || WDM_HMEME_MEMBER.MEME_LAST_NAME as PATIENT_NAME, WDM_HMEME_MEMBER.MEME_BIRTH_DT Here is a sample of my code left join ( select max (HIDCD_SK) as max_HIDCD_SK, IDCD_DESC from WDM_HIDCD_DIAG_CD where max_HIDCD_SK = HIDCD_SK) as DIAG_DESC on (WDM_DDIST_DIAG_SET.DDIST_IDCD_AD = DIAG_DESC.max_HIDCD_SK) where WDM_HSBSB_SUBSC.SBSB_ID in ('XXXXX') and WDM_DFNIN_FUNDING_INFO.DFNIN_CLAIM_TYPE <> 'R' /* R = pharmacy */ and WFT_FCDML_CL_LINE.FCDML_RPT_PAID_DT <> WFT_FCDML_CL_LINE.FCDML_PROCESS_DT and WDM_HCLCL_CLAIM.HCLCL_AS_OF_TO_DT = '31-Dec-9999' and WDM_DCDBC_CL_LINE_BCN_CODES.DCDCD_DENIAL_IND = 'N' What am I doing wrong?

cmcquain · ‎01-12-2018

I got it! I had to change substring count on minutes and seconds. DHMS(input(substr(t3.'Admit Date'n,1,8),yymmdd8.),input(substr(t3.'Admit Date'n,9,2),hh2.),input(substr(t3.'Admit Date'n,11,2),mm2.),input(substr(t3.'Admit Date'n,13,2),ss2.))

cmcquain · ‎01-12-2018

I had to modify your code some as shown DHMS(input(substr(t3.'Admit Date'n,1,8),yymmdd8.),input(substr(t3.'Admit Date'n,9,2),hh2.),input(substr(t3.'Admit Date'n,10,2),mm2.),input(substr(t3.'Admit Date'n,12,2),ss2.)) Format = DATETIME19. I am still getting the wrong output. From the original 20180110164700 I am getting this 10JAN2018:17:05:10 when the field should look like 10JAN2018:16:47:00

cmcquain · ‎01-12-2018

I am using SAS Enterprise Guide and I am trying to format a text field by the name of 'Admit Date' with data such as: 20180110164700 to a datetime format. Hopefully formatted to YYYY-MM-DD HH:MM:SS. Any help would be appreciated. Thank you

cmcquain · ‎08-09-2017

Thank you for your reply. This looks like something that I would be able to use. Unfortunately I am using version 7.3. Do you know if there is any way to do that on version 7.3? Thank you

cmcquain · ‎08-08-2017

I am looking for a way if it is possible using SAS Visual Analytics GeoMap to list a bunch of customers using their zip codes. Then place a non-related zip code on the map and get the distances between the customers and the non-related zip code. Thank you

Online Status	Offline
Date Last Visited	‎03-15-2021 01:37 PM

Standard Deviation Enterprise Edition

Re: Proc SQL subquery in a left join

Re: Proc SQL subquery in a left join

Proc SQL subquery in a left join

Re: Change text to datetime

Re: Change text to datetime

Change text to datetime

Re: How do I place a central point in GeoMap

How do I place a central point in GeoMap

Re: How do I place a central point in GeoMap

Re: How do I place a central point in GeoMap

Standard Deviation Enterprise Edition

Re: Proc SQL subquery in a left join

Re: Proc SQL subquery in a left join

Proc SQL subquery in a left join

Re: Change text to datetime

Re: Change text to datetime

Change text to datetime

Re: How do I place a central point in GeoMap

How do I place a central point in GeoMap