About bijayadhikar

bijayadhikar · ‎05-10-2023

Hi all, I am looking for your help on how to compute 5 year's monthly moving average to compare with the current month. Mean number of cases is based on the past two months of the current year and the current month ± 2 months for 5 previous years (27 months). See illustration in the picture below, which how the yellow colored cells (27 months) are used in moving average to compare with current month, green cell. Data sets is below. data have; input Disease $ YEAR Month count; datalines; A 2018 1 19 A 2019 1 25 A 2020 1 15 A 2021 1 6 A 2022 1 18 A 2023 1 6 A 2018 2 22 A 2019 2 9 A 2020 2 21 A 2021 2 3 A 2022 2 8 A 2023 2 19 A 2018 3 20 A 2019 3 15 A 2020 3 5 A 2021 3 9 A 2022 3 9 A 2023 3 18 A 2018 4 11 A 2019 4 10 A 2021 4 1 A 2022 4 8 A 2023 4 15 A 2018 5 14 A 2019 5 16 A 2020 5 9 A 2021 5 4 A 2022 5 10 A 2018 6 19 A 2019 6 15 A 2020 6 8 A 2021 6 6 A 2022 6 26 A 2018 7 21 A 2019 7 12 A 2020 7 42 A 2021 7 16 A 2022 7 12 A 2018 8 15 A 2019 8 15 A 2020 8 13 A 2021 8 13 A 2022 8 8 A 2018 9 9 A 2019 9 8 A 2020 9 4 A 2021 9 11 A 2022 9 4 A 2018 10 12 A 2019 10 10 A 2020 10 5 A 2021 10 11 A 2022 10 12 A 2018 11 7 A 2019 11 15 A 2020 11 5 A 2021 11 6 A 2022 11 7 A 2018 12 22 A 2019 12 13 A 2020 12 7 A 2021 12 20 A 2022 12 14 B 2018 1 7 B 2019 1 7 B 2020 1 9 B 2021 1 8 B 2022 1 8 B 2023 1 13 B 2018 2 9 B 2019 2 11 B 2020 2 16 B 2021 2 5 B 2022 2 4 B 2023 2 11 B 2018 3 13 B 2019 3 8 B 2020 3 6 B 2021 3 9 B 2022 3 11 B 2023 3 19 B 2018 4 13 B 2019 4 17 B 2020 4 5 B 2021 4 11 B 2022 4 14 B 2023 4 10 B 2018 5 17 B 2019 5 12 B 2020 5 13 B 2021 5 13 B 2022 5 20 B 2023 5 1 B 2018 6 26 B 2019 6 32 B 2020 6 23 B 2021 6 21 B 2022 6 24 B 2018 7 24 B 2019 7 30 B 2020 7 31 B 2021 7 34 B 2022 7 22 B 2018 8 16 B 2019 8 18 B 2020 8 24 B 2021 8 15 B 2022 8 13 B 2018 9 8 B 2019 9 23 B 2020 9 19 B 2021 9 8 B 2022 9 16 B 2018 10 8 B 2019 10 13 B 2020 10 14 B 2021 10 8 B 2022 10 11 B 2018 11 16 B 2019 11 13 B 2020 11 6 B 2021 11 8 B 2022 11 12 B 2018 12 12 B 2019 12 10 B 2020 12 3 B 2021 12 10 B 2022 12 9 ; run;

bijayadhikar · ‎12-23-2022

Thank you Tom. I tested your scripts, and it did work as well. Much appreciated.

bijayadhikar · ‎12-23-2022

Thank you Quentin. This is exactly what I wanted.

bijayadhikar · ‎12-23-2022

Sorry there was typo. the SET statement should read file have, not precom.

bijayadhikar · ‎12-23-2022

That is correct. I created max_date based on the date variable not shown here (which has a different date for each record). So max is max for all records. My aim was to produce file name based on each quarterly data, so that once the report is automated the file name tells which quarter and year the data belongs to.

bijayadhikar · ‎12-23-2022

Happy holidays! I am trying to put custom year and quarter in the output file name using variables in the dataset (i.e. year and quart), and NOT using macro date function. Output file will be saved in the libname qc Desired output file name should be report_2022_3 I tried the following script but it uses sysdate year and quarter, and gives report_2022_4 data have; input caseid $ max_Date date9. year quart; format max_Date date9.; datalines; 34 27jul2022 2022 3 35 27jul2022 2022 3 37 27jul2022 2022 3 ; run; data repstamps; max_Date = "&sysdate9."d; rep_qtr = qtr(max_Date ); rep_year = year(max_Date ); call symput('rep_qtr',put(rep_qtr,1.)); call symput('rep_year',put(rep_year,4.)); run; %put &rep_qtr; %put &rep_year; %let out = report&rep_qtr; data qc.report_&rep_qtr._&rep_year; set precom; run; Thanks for your help

bijayadhikar · ‎12-22-2022

Sorry for inconvenience. I found a solution. just ignore. Bijay

bijayadhikar · ‎12-22-2022

HI, I am looking to create a new column with max date. That mean my new column 'max_date should have 27jul2012 for all the caseid? data have; input caseid $ myDate date9.; format myDate date9.; datalines; 34 27jul2010 35 27jul2011 37 27jul2012 ; run; Thanks in advance.

bijayadhikar · ‎01-31-2022

@Kurt_Bremser I was talking about datasets (also excel files). With macro date $Date function datasets are created or read. However I am re-thinking as it is not straightforward because I realize that some days files are missing or date gap, so I can leave as is for now. Thank you all for offering support

bijayadhikar · ‎01-20-2022

@Kurt_Bremser Exactly that's what I wanted. Read the latest file from a folder. File name structure is e.g. 19JAN2022_report

bijayadhikar · ‎01-20-2022

@Kurt_Bremser good question, yes it is possible that someday a file may not be available. @ballardw Thank you for offering this logics. I will try to see if I can figure out.

bijayadhikar · ‎01-19-2022

Is there a way to read file with date stamp for previous day if today's file is missing/not available? I do read file with date with date stamp with macro code as below for current day (or day's file). It does work whether to read to day's file or any previous day (with subtraction in date). However, my question is: how to read yesterday's file IF today's file is missing/not exist. This is a Unix environment. %let Date = %sysfunc(date(),Date9.); %put &Date; libname dat '/.........../folder_name'; data new; set dat._&Date._merged_line_list; run;

bijayadhikar · ‎03-18-2021

@Rick_SAS I change vline to needle, and used X/Y series as per your suggestion. It did work perfectly as I wanted. Much appreciated!

bijayadhikar · ‎03-17-2021

Hi, Trying to see if there is a away to highlight extreme value point (in this case if value >5) to be marked with red circle or change line color to red. Data have; length zone $6; Input zone RepDate case trend; informat RepDate ANYDTDTE10.; FORMAT Repdate mmddyy10.; Datalines; A 01/16/2021 1 4.3 A 01/17/2021 1 3.9 A 01/18/2021 12 3.3 A 01/19/2021 16 4.0 A 01/20/2021 2 4.4 A 01/21/2021 5 3.9 A 01/22/2021 6 6.1 ; run; proc sgplot data=have noautolegend; vline RepDate / response=trend lineattrs=(color=grey thickness=3 PATTERN=SHORTDASH); run;

bijayadhikar · ‎02-11-2021

Thank you very much. Appreciated.

Online Status	Offline
Date Last Visited	16 hours ago

ODS text or proc odstext not outputting text in SAS Management Concole

Re: calculate YTD for moving month vs current year YTD by disease

Re: calculate YTD for moving month vs current year YTD by disease

Re: calculate YTD for moving month vs current year YTD by disease

Re: calculate YTD for moving month vs current year YTD by disease

calculate YTD for moving month vs current year YTD by disease

Re: How to insert date in odstext

Re: How to insert date in odstext

How to insert date in odstext

Re: How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

Re: calculate days from lagging dates

Re: Custom datestamp in the output filename

Re: Custom datestamp in the output filename

Re: Need help in SGPLOT title with ODS

Re: calculate YTD for moving month vs current year YTD by disease

Re: How to select both duplicate IDs if a condition met

How to compute monthly moving average using 5 years data by group

Re: Custom datestamp in the output filename

Re: Custom datestamp in the output filename

Re: Custom datestamp in the output filename

Re: Custom datestamp in the output filename

Custom datestamp in the output filename

Re: How to select max date

How to select max date

Re: How to read file with date stamp for previous day if today's file ...

Re: How to read file with date stamp for previous day if today's file ...

Re: How to read file with date stamp for previous day if today's file ...

How to read file with date stamp for previous day if today's file is m...

Re: SGPLOT Annotation for extreme value

SGPLOT Annotation for extreme value

Re: Need help in SGPLOT title with ODS