topic Re: How to insert a macro variable in the middle of a name of a dataset in SAS Programming

How to insert a macro variable in the middle of a name of a dataset

mandan414 — Tue, 27 Aug 2019 19:42:38 GMT

Hello,

I have a series of dataset like ab2000c, ab2001c, ab2002c, ........

To do some analyses I made a macro variable like this:

%macro maxyear;

%do i = 2000 %to 2002;

proc freq data = ab&ic

......

but the above dataset doesn't work. I don't know how to insert the macro variable in the middle of the dataset name.

Thank you so much in advance for your help,

Mandana

PaigeMiller — Tue, 27 Aug 2019 19:45:31 GMT

You need a dot after the end of the macro variable name

ab&i.c

Reeza — Tue, 27 Aug 2019 19:49:23 GMT

Any reason why you can't combine the data sets and work with them together?

mandan414 — Tue, 27 Aug 2019 19:55:03 GMT

Hi, I cannot combine the dataset because the records are slightly different between the datasets. .