topic Re: How do I Use Macro in libname and data statements? in SAS Programming

How do I Use Macro in libname and data statements?

dgrolling — Wed, 13 Mar 2019 15:52:48 GMT

%LET study=EDUC2017;

filename  &study "C:\DP\ELE\DDI\&study..xml";
filename  SXLEMAP  "C:\DP\ELE\DDI Tables\ELEExplorer.map";
libname   &study xmlv2 xmlmap=SXLEMAP access=READONLY;
libname   OUT      "C:\DP\ELE\DDI\Data";

DATA OUT.titlStmt2;   SET &study.titlStmt2; run;
DATA OUT.producer;    SET &study.producer;  run;
DATA OUT.fundAg;      SET &study.fundAg;    run;
DATA OUT.stdyInfo;    SET &study.stdyInfo;  run;
DATA OUT.sumDscr;     SET &study.sumDscr;   run;
DATA OUT.dataColl;    SET &study.dataColl;  run;
DATA OUT.qstn; 	      SET &study.qstn;      run;
DATA OUT.var; 	      SET &study.var;       run;
DATA OUT.catgry;      SET &study.catgry;    run;
DATA OUT.catStat;     SET &study.catStat;   run;

The error I'm getting is " File WORK.EDUC2017CATSTAT.DATA does not exist."

Re: How do I Use Macro in libname and data statements?

DanielLangley — Wed, 13 Mar 2019 16:03:14 GMT

change SET &study.X

to SET &study..X

Re: How do I Use Macro in libname and data statements?

RW9 — Wed, 13 Mar 2019 16:04:57 GMT

This is where putting the point at the end of macro variables is very important:

This:

SET &study.titlStmt2;

As there is only one . that closes the macro name, so there is no dot between lib and dataset, should be:

SET &study..titlStmt2;

Following good programming practices will help you avoid these types of errors - e.g:
Always finish a macro variable with a .

(Other tips, avoid coding in uppercase, one line per statement, avoid use of keywords like var in names

Re: How do I Use Macro in libname and data statements?

dgrolling — Wed, 13 Mar 2019 16:14:57 GMT

Thank you, that worked as expected. I will consider your other 'best practices' suggestions.

Re: How do I Use Macro in libname and data statements?

DanielLangley — Wed, 13 Mar 2019 16:18:26 GMT

It might also be worth looking into proc datasets to copy files from one library to another.

proc datasets lib = &study.;
	copy out = out;
	select dataset1 dataset2 dataset3; /*** List of datasets you want copied ***/
quit;
run;