topic programming help in SAS Programming

programming help

user40 — Thu, 15 Sep 2022 08:15:24 GMT

Is it wrong to write like this in SAS code that you want t to be a string in macro?

%macro hentami(t,data,aar); 

data kuhr&aar.; 
set kuhr.kuhr_&aar.; 
rename pasientlopenummer =lopenummer; 
run; 

data "&t"kuhr&aar.; 
merge &data (in=a) kuhr&aar.; 
if a by lopenummer; 

uke =round((differansedager -inn_refdager0)7,1); 
tjeneste=sum(fastlege,legevakt,spesialist,psykolog); 
if uke ge 0 and uke le 52 then output; 
run; 
%mend; 

%hentami_kuhr(ami,ami_index,2008);

I got an error message when I write "&t"kuhr&aar. in macro %hentami_kuhr(t,data,aar) there t is a text, data is a dataset and aar is year (like 2008). How can I rewrite this macro code?

Re: programming help

japelin — Thu, 15 Sep 2022 08:25:16 GMT

Try modifying it as follows

data &t.kuhr&aar.;

Re: programming help

user40 — Thu, 15 Sep 2022 08:52:32 GMT

Thanks. It works. Then we cannot have special character in some macro like this &t._kuhr&aar.; ?

Re: programming help

japelin — Thu, 15 Sep 2022 08:58:11 GMT

use %str or %nrstr for special charactor.

for example

%Macro Mtest(val);
  data sample;
    a="&val";
  run;
  proc print;run;
%Mend;

%Mtest(xxx,yyy)/* error */

%Mtest(%str(xxx,yyy))