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

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. ... View more

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

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'.   ... View more

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. ... View more

Thank you. I will report back how it goes. ... View more

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 . . . . . ... View more