cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Phil_Low
‎10-10-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to get a SAS variable into a Macro?

by Calcite | Level 5 in SAS Programming
‎10-10-2019 10:59 AM
‎10-10-2019 10:59 AM
Everyone,  I apologize, my code works just fine.  I realize the problem.  At the bottom of my original post there is a . after the Macro invocation %holiday_mcr   the . was causing my issues ... View more

Re: How to get a SAS variable into a Macro?

by Calcite | Level 5 in SAS Programming
‎10-10-2019 10:49 AM
‎10-10-2019 10:49 AM
it's set to 0 at the start of every observation.  the holiday counter do loop then counts all the holidays between the start dat and then end date.  the final count of all holidays is then subtracted from the final tally of weekdays in the intck function to get actual working days for that observation.   When the next observation begins, the holiday count is set back to 0. ... View more

Re: How to get a SAS variable into a Macro?

by Calcite | Level 5 in SAS Programming
‎10-10-2019 10:33 AM
‎10-10-2019 10:33 AM
Here is the working code that has not been turned into a macro.   /*Second holiday counter to deal with CME completed date below*/ holiday_count=0; if cme_completed_date>. then do i=year(datepart(CME_COMPLETED_DATE)) to year(today()-1); if datepart(CME_COMPLETED_DATE)<=holiday('NEWYEAR',i)<=today()-1  then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('USINDEPENDENCE',i)<=today()-1  then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('MLK',i)<=today()-1 then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('USPRESIDENTS',i)<=today()-1  then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('COLUMBUS',i)<=today()-1 then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('VETERANS',i)<=today()-1 then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('THANKSGIVING',i)<=today()-1 then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('CHRISTMAS',i)<=today()-1 then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('MEMORIAL',i)<=today()-1 then holiday_count+1; if datepart(CME_COMPLETED_DATE)<=holiday('LABOR',i)<=today()-1 then holiday_count+1; end; if intck('WEEKDAY', datepart(cme_completed_date), today()-1)-holiday_count>89 then delete;  ... View more

Re: How to get a SAS variable into a Macro?

by Calcite | Level 5 in SAS Programming
‎10-10-2019 10:31 AM
‎10-10-2019 10:31 AM
I have 10 years of SAS experience under my belt, please everyone assume I know what I am talking about when I say I need a macro solution.  I have to apply this solution across many datasets and I don't want to copy and paste all over. If you don't want to assist that is fine, I understand.    I need to somehow get datastep date variables into the macro and then get the calculated macro variable produced back into the days_diff calculation. ... View more

Re: How to get a SAS variable into a Macro?

by Calcite | Level 5 in SAS Programming
‎10-10-2019 10:24 AM
‎10-10-2019 10:24 AM
As I mentioned I have to apply then to many different variables in many different datasets.  It would literally require 20 copy and pastes or more to do it purely in a datastep, so I'm trying to get a macro together than I can just call when needed. ... View more

How to get a SAS variable into a Macro?

by Calcite | Level 5 in SAS Programming
‎10-10-2019 10:14 AM
‎10-10-2019 10:14 AM
Well this didn't work. /*Macro for determining holidays*/ %macro Holiday_MCR;  /*holiday counter*/   %let holiday_count=0; %do i=%sysfunc(year(&start_date.)) %to %sysfunc(year(&end_date.));   %if &start_date.<=%sysfunc(holiday(NEWYEAR,&i.)) and %sysfunc(holiday(NEWYEAR,&i.))<= &end_date.  %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(USINDEPENDENCE,&i.))and %sysfunc(holiday(USINDEPENDENCE,&i.))<= &end_date.  %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(MLK,&i.)) and %sysfunc(holiday(MLK,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(USPRESIDENTS,&i.)) and %sysfunc(holiday(USPRESIDENTS,&i.))<= &end_date.  %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(COLUMBUS,&i.)) and %sysfunc(holiday(COLUMBUS,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(VETERANS,&i.)) and %sysfunc(holiday(VETERANS,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(THANKSGIVING,&i.)) and %sysfunc(holiday(THANKSGIVING,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(CHRISTMAS,&i.)) and %sysfunc(holiday(CHRISTMAS,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(MEMORIAL,&i.)) and %sysfunc(holiday(MEMORIAL,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1);   %if &start_date.<=%sysfunc(holiday(LABOR,&i.)) and %sysfunc(holiday(LABOR,&i.))<= &end_date. %then %let Holiday_count=%eval(&Holiday_count.+1); %end; %put Holiday count is &holiday_count.; &holiday_count. %mend; data test; begin_date=today()-365; finish_date=today(); call symputx('start_date',begin_date); call symputx('end_date',finish_date); days_diff = intck('WEEKDAY', begin_date, finish_date)-%holiday_mcr.;  run;   I'm trying to calculate the number of holidays between two date ranges and subtract that from the calculation to get actual working days.  However the twist is this must be done with a macro as I am going to be applying it to a lot of different variables. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-10-2019 03:12 PM
Quick links