BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mcrum1
Calcite | Level 5

Hello!

Our company has pay period endings that fall every two weeks on a Saturday. I’m trying to automate the last pay period date (Jan 18, Feb 15, Mar 29, etc.)  of the month into a macro for our monthly reports.  I am thinking I am supposed to do a loop, but I don’t know how to develop the logic because some months have two pay periods while others months have three pay periods. 

Here are some bi-weekly Pay Period Ending dates for January through April. I’m only needing that last Pay Period Ending Date.

Jan=  4 , 18

Feb=  1, 15

Mar= 1, 15, 29

Apr= 12,  26

If the current month is April I need to be able to pull the date “March 29”. If we are in the month of May, I need to pull the date April 26. I hope that I am explaining this okay. I’m new to this job and new to SAS.

If someone could please help me that would be greatly appreciated.  Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

The problem is your initial value. But it seems all your want week is odd week . therefore

%let monyy=may2014;
data _null_;

do i=intnx('month',"01&monyy"d,-1,'b') to intnx('month',"01&monyy"d,-1,'e');
 if week lt week(i,'v') and mod(week(i,'v'),2)=1 and weekday(i)=7 then do;
  week=week(i,'v');day=i;
 end;
end;
call symputx('want',put(day,date9.));
run;
%put &want;

Xia Keshan

View solution in original post

3 REPLIES 3
Ksharp
Super User

The problem is your initial value. But it seems all your want week is odd week . therefore

%let monyy=may2014;
data _null_;

do i=intnx('month',"01&monyy"d,-1,'b') to intnx('month',"01&monyy"d,-1,'e');
 if week lt week(i,'v') and mod(week(i,'v'),2)=1 and weekday(i)=7 then do;
  week=week(i,'v');day=i;
 end;
end;
call symputx('want',put(day,date9.));
run;
%put &want;

Xia Keshan

mcrum1
Calcite | Level 5

Thanks this was really helpful!

Haikuo
Onyx | Level 15

This will give you all of the wanted Sat in one year (2014), tweaked as needed.

data have;

  do Date="04jan2014"d by 14 while(year(date)=2014);

    output;

end;

run;

proc sql;

  create table want as

    select date format=date9.  from have

   group by put(date, yymon7.)

     having date=max(date)

  order by date

;

quit;

Haikuo

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2211 views
  • 3 likes
  • 3 in conversation