topic Re: Pass Macro variable in dataset name (DATA STEP) in SAS Programming

Pass Macro variable in dataset name (DATA STEP)

SAS_ACE — Wed, 10 Feb 2021 00:38:56 GMT

I am trying the following:

%let year ='2019';
%put &year;

data cars_&year.;
set sashelp.cars;
run;

I have tried &&year. and &year.

I would like my new dataset to be cars_2019

Re: Pass Macro variable in dataset name (DATA STEP)

SAS_ACE — Wed, 10 Feb 2021 00:56:23 GMT

Removed the ' ' around 2019.

That fixed it.

Re: Pass Macro variable in dataset name (DATA STEP)

PaigeMiller — Wed, 10 Feb 2021 11:50:35 GMT

As a general rule, you should not put quotes or double quotes around the value of a macro variable. There are some rare exceptions, but as you see, this is not one of them.