topic Re: create macro to go back from start date in SAS Enterprise Guide

create macro to go back from start date

avatar — Thu, 03 Jul 2014 14:34:50 GMT

Hello,

I would like to bring data 10 days older from the start date.

I have created a macro for start date shown below.

%let start_dt = '01APR2014'd ;

% let old_dt = %eval(%input(&start_dt ,8.) - 10);

this gives erro

Re: create macro to go back from start date

ChrisHemedinger — Thu, 03 Jul 2014 14:46:52 GMT

Dates are just numbers, so the easy thing to do is to ensure you seed your %EVAL expression with them as numbers using SAS functions.

Examples:

/* 10 days before today */
%let cutoff = %eval(%sysfunc(today()) - 10);

/* 10 days before April 1, 2014 */
%let cutoff = %eval(%sysfunc(mdy(4,1,2014)) - 10);

Chris

Re: create macro to go back from start date

user24feb — Thu, 03 Jul 2014 14:54:34 GMT

%LET old_dt=%Sysfunc(PutN(%Sysfunc(IntNX(day,&start_dt.,-10)),Date9.));

Re: create macro to go back from start date

RW9 — Thu, 03 Jul 2014 14:54:56 GMT

Well, few things there. The start_dt macro variable will contain the text '01APR2014'd

when this resovles on the eval you will get: %let old_dt = %eval(%input('01APR2014'd ,8.) - 10);

This will fail as there is a d after the quote. Also, you have a space between the % and let.

I would question why you need to do this as:

data _null_;

call symput('OLD_DT','01APR2014'd - 10);

run;

would give the result, plus several other methods of getting there.

Re: create macro to go back from start date

avatar — Thu, 03 Jul 2014 15:04:10 GMT

Chris example seems simple to use. I will try that.

thanks all