Breaking News: Grepper is joining You.com. Read the official announcement!

Loop thru datasets based on date (ex. day or month)

Lonely Lion answered on February 23, 2023 Popularity 1/10 Helpfulness 1/10

answer Loop thru datasets based on date (ex. day or month)

Loop thru datasets based on date (ex. day or month)

Comment

data work.MonthDates2;
FORMAT StartDate MMDDYYS8. EndDate MMDDYYS8. StartTime datetime22. EndTime datetime22.;
do i=1 to 12;
monthsago=1-i;
StartDate=intnx('Month',today(),monthsago, 'B');
EndDate=intnx('Month',today(),monthsago, 'E');
Monthdate=Put(StartDate,yymm7.);
StartTime=dhms(StartDate, 0, 0, 0) ;
EndTime=dhms(EndDate, 0, 0, 0) ;
output work.MonthDates2;
end;
run;
%macro process(StartDate=, EndDate=, i=, starttime=, endtime=, monthdate=);
 
%mend process;
data _null_ ;
set work.MonthDates2;
by i;
call execute('%process(StartDate='||StartDate||' , StartTime='|| StartTime||', Monthdate='|| Monthdate||', Endtime='||Endtime||', EndDate='||EndDate||', i='||i||');');
run;

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: wiki.idexx.com

Tags: date whatever

Link to this answer
Share Copy Link

Contributed on Feb 23 2023

Lonely Lion

0 Answers Avg Quality 2/10

Loop thru datasets based on date (ex. day or month)

Contents

More Related Answers

Loop thru datasets based on date (ex. day or month)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.