Adding Text to Macro Variable

BCNAV — Wed, 15 Aug 2018 13:21:42 GMT

I have the following:

%macro byfyear;
	proc sql noprint;
	select distinct fy 
   		into :ifyear1 - :ifyear99
      		from IBS.OVR;
	%let fyearcnt = &sqlobs;
	quit;

	%do i = 1 %to &fyearcnt;
		%if &&ifyear&i = 2017 %then %do;
			data EGTASK.OVRFY&&ifyear&i(where=(fy=&&ifyear&i));
				set IBS.OVR;
			run;
		%end;
		%else %do;
			data EGTASK.OVRFY&&ifyear&i(where=(fy=&&ifyear&i));
				set IBS.OVR;
			run;
		%end;
	%end;
%mend byfyear;
%byfyear

It works fine. So if the year is 2017 the dataset name will be OVRFY2017. What I would like at

%if &&ifyear&i = 2017 %then %do

is to change it so the dataset name appends an A to the file name, so it would be OVRFY2017A. This means I need to add the A to the command:

data EGTASK.OVRFY&&ifyear&i(where=(fy=&&ifyear&i));

specifically the part: EGTASK.OVRFY&&ifyear&i

How can I do this? I have tried EGTASK.OVRFY&&ifyear&iA and EGTASK.OVRFY&&ifyear&i.A

Thanks

-Bill

Re: Adding Text to Macro Variable

PaigeMiller — Wed, 15 Aug 2018 13:48:48 GMT

I have tried EGTASK.OVRFY&&ifyear&iA and EGTASK.OVRFY&&ifyear&i.A

You need two dots before the A, because your macro variable begins with two ampersands


EGTASK.OVRFY&&ifyear&i..A

Re: Adding Text to Macro Variable

BCNAV — Wed, 15 Aug 2018 13:49:35 GMT

thanks!

topic Re: Adding Text to Macro Variable in SAS Programming

Adding Text to Macro Variable

Re: Adding Text to Macro Variable

Re: Adding Text to Macro Variable