topic Re: Macros query in SAS Programming

Macros query

pawandh — Tue, 22 Dec 2015 05:03:40 GMT

I'm passing a date and it will b a character only,can't i store it in any variable or macro variable like %let or as i'm doingin code.And how can i change this date into numeric and store in a variable so that i can find no of weekdays between these two dates.

%macro ab(strt,end);

a=&strt;
b=&end;

%put a= b=;

%mend;

%ab(01jan2015,31jan2015);

Re: Macros query

Ksharp — Tue, 22 Dec 2015 05:10:03 GMT

%macro ab(strt,end);
a="&strt"d ;
b="&end"d ;
%put a= b=;
%mend;

Re: Macros query

pawandh — Tue, 22 Dec 2015 05:14:42 GMT

it is giving error

Re: Macros query

pawandh — Tue, 22 Dec 2015 05:16:09 GMT

but if i'm creating a dataset then it is working fine .

%macro ab(strt,end);
data _null_;
a="&strt"d;
b="&end"d;

put a= b=;
run;
%mend;

%ab(01jan2015,31jan2015);

Re: Macros query

JoshB — Tue, 22 Dec 2015 05:31:29 GMT

There's some mixing of data step and macro functionality going on in previous posts.

This would be an alternative to save those strings as dates.

%macro ab(strt,end);
  %let a="&strt"d;
  %let b="&end"d;
  %put a=&a. b=&b.;
%mend;
 
%ab(01jan2015,31jan2015);

At that point, you should be able to use the dates in a function such as intck

e.g.

%macro ab(strt,end);
  %let diff = %sysfunc(intck(day,"&strt."d,"&end."d));
  %put Days between = &diff.;
%mend;
 
%ab(01jan2015,31jan2015);

I'm assuming this is part of a larger macro, so you'll be able to use the resulting value in a variable.

Re: Macros query

Ksharp — Tue, 22 Dec 2015 06:49:39 GMT

You want express them as macro variable ?

%macro ab(strt,end);
%let a=%sysfunc(inputn(&strt,date9.));
%let b=%sysfunc(inputn(&end,date9.));
%let dif=%eval(&b-&a);

%put a=&a b=&b dif=&dif;
%mend;
%ab(01jan2015,31jan2015)