About Hdababs

Hdababs · ‎08-21-2024

Team Name The Provengers Track Healthcare Use Case The Provengers will focus on using SAS Viya to answer questions about health care providers. Using the wealth of information in the NPPES data, the Provengers will analyze and visualize provider demographics, areas of specialization, and provider affiliations. By comparing providers across different groups to the overall population, the Provengers want to show how gathering this publicly available information into SAS Viya can help answer critical questions about our health system. Technology SAS Viya, visualizations Region United States Team lead @Hdababs Team members Hesham Dabbas, Kevin Schott, Chaitali Shah, Kay Kellerhouse Social media handles Is your team interested in participating in an interview? Y Optional: Expand on your technology expertise

Hdababs · ‎08-30-2023

Thank you. If I understand correct, I need to declare infile and outfile variables for the directory path for the source and destination.

Hdababs · ‎08-30-2023

Greetings, I just trued this solution: data msg; rc=fcopy("C:\My Documents\schedule.txt", "C:\My Documents\Reports\schedule.txt"); length msg $ 1024; msg=sysmsg(); putlog _all_; run; And received this SAS EG output: rc msg 20004 ERROR: No logical assign for filename C:\MY.

Hdababs · ‎03-23-2023

Thank you. I initially posted this as a reply to a resolved post. I was able to use teradata syntax: ('2022' - extract(year from teradata birth date column name)) as Age

Hdababs · ‎03-23-2023

Thank you. I used teradata syntax. Here is what I used: ('2022' - extract(year from teradata birth date column name)) as Age

Hdababs · ‎03-22-2023

Greetings, How do I calculate age while using a connection to teradata date of birth field. This is what I tried so far, It is embded PROC SQL; CONNECT TO teradata (AUTHDOMAIN=TeradataAuth TDPID=XYZ2 MODE=TERADATA CONNECTION=GLOBAL); . .. ... select DMA.MCID ,frfm.HCC_CD ,DMA.GNDR_NM ,floor ((intck('month',DMA.MBR_BRTH_DT,today()) - (day(today()) < day(DMA.MBR_BRTH_DT))) / 12) as age ,INCRD_YEAR_MNTH_NBR ,case when max(PRORTD_MBR_MNTH_CNT) >0 then 1 else 0 END AS PRORTD_MBR_MNTH_CNT ERROR: Teradata prepare: Syntax error: expected something between '(' and the string 'month'.

Hdababs · ‎03-22-2023

Greetings, How do I calculate age while using a connection to teradata date of birth field. This is what I tried so far: PROC SQL; . . .. ... select DMA.MCID ,frfm.HCC_CD ,DMA.GNDR_NM ,floor ((intck('month',DMA.MBR_BRTH_DT,today()) - (day(today()) < day(DMA.MBR_BRTH_DT))) / 12) as age ,INCRD_YEAR_MNTH_NBR ,case when max(PRORTD_MBR_MNTH_CNT) >0 then 1 else 0 END AS PRORTD_MBR_MNTH_CNT ERROR: Teradata prepare: Syntax error: expected something between '(' and the string 'month'.

Hdababs · ‎03-08-2023

Greetings, I was able to figure out the issue. There was a macro variable retrieving previous year value. The reporting period is 2022 and the previous year is 2021. Since I am running the code in 2023, I have to indicate that the previous reporting year is 2021.

Hdababs · ‎03-04-2023

Thank you. I will report back how it goes.

Hdababs · ‎03-04-2023

Thank you. Identical column names: see_date1 see_date2 see_date3.... The prefix are the numbers following the column name. I am calling them prefix. My intention that if any ONE of these 310 variables is not in the year 2022, then the record is deleted. This is a sample of the output. Rows with red font must be deleted. see_date1 see_date2 see_date3 see_date4 see_date5 see_date6 see_date7 see_date8 see_date9 see_date10 22-Feb-22 23-May-22 21-Aug-22 19-Nov-22 . . . . . . 15-Jan-22 15-Feb-22 17-Mar-22 16-Apr-22 1-Sep-22 30-Nov-22 28-Feb-23 . . . 18-Jan-22 18-Apr-22 . . . . . . . . 18-Jan-22 18-Apr-22 . . . . . . . . 18-Feb-22 19-May-22 . . . . . . . . 3-Feb-22 4-May-22 . . . . . . . . 27-Feb-22 29-Mar-22 28-Apr-22 28-May-22 27-Jun-22 . . . . . 29-Mar-22 17-May-22 15-Aug-22 15-Nov-22 13-Feb-23 . . . . . 9-Feb-22 14-Mar-22 14-Apr-22 14-Jul-22 16-Oct-22 14-Jan-23 . . . . 18-Mar-22 21-Jun-22 19-Sep-22 19-Dec-22 19-Mar-23 . . . . . 5-Apr-22 4-Jul-22 2-Oct-22 31-Dec-22 31-Mar-23 . . . . . 31-Mar-22 1-Jul-22 29-Sep-22 28-Dec-22 28-Mar-23 . . . . .

Hdababs · ‎03-04-2023

Greetings, I need to exclude observations that include out of range dates. The column names I am trying to evaluate are identical but with a different prefix. In the code below, I am attempting to include the desired date range which supposed ignore date values greater and less than 2022. Regards data reform; set adj_both; Where "01JAN2022"d <= see_date1,see_date2,see_date3,see_date4,see_date5,......see_date310, <= "31DEC2022"d; array fills(*) see_date1 - see_date&pdm_count.; array filldayz(*) Dayz_Supply1 - Dayz_Supply&pdm_count.; do i = 1 to (&pdm_count - 1) while (fills(i) ^= .); if fills(i+1) < (fills(i) + filldayz(i)) then do; fills(i+1) = (fills(i) + filldayz(i)); end; end; drop i; run;

Online Status	Offline
Date Last Visited	‎06-24-2025 05:05 PM

The Provengers - National Plan and Provider Enumeration System

Re: fcopy with directory paths

Re: fcopy with directory paths

Re: Calculate age based on Teradata Birth Date

Re: Converting age from days to years

Calculate age based on Teradata Birth Date

Re: Converting age from days to years

Re: Exclude observations with out of range values

Re: Exclude observations with out of range values

Re: Exclude observations with out of range values

Re: Calculate age based on Teradata Birth Date

The Provengers - National Plan and Provider Enumeration System

MCC Inspectors - Investigating Multiple Chronic Conditions

The Provengers - National Plan and Provider Enumeration System

Re: fcopy with directory paths

Re: fcopy with directory paths

Re: Calculate age based on Teradata Birth Date

Re: Converting age from days to years

Calculate age based on Teradata Birth Date

Re: Converting age from days to years

Re: Exclude observations with out of range values

Re: Exclude observations with out of range values

Re: Exclude observations with out of range values

Exclude observations with out of range values

SAS Hacker's Hub

SAS Analytics Explorers