topic Re: macro variable not resolving in SAS Programming

macro variable not resolving

RAVI2000 — Wed, 04 Aug 2021 23:58:59 GMT

Please suggest what I am missing here.

%let directory_start =/data/;
%let directory_end= /Formats/formats.sas;
%let lib_end= /Programs/temp;
*%let study = %nrstr(Study03-0072);

%macro email(old =, new=, study=);
%include "&directory_start.&study.&directory_end.";

libname temp "&directory_start.&study.&lib_end.";

%mend;

%email;

%email(study = Study03-0072, old =data, new=datanew);

Log:

MLOGIC(EMAIL):  Beginning execution.
MLOGIC(EMAIL):  Parameter OLD has value 
MLOGIC(EMAIL):  Parameter NEW has value 
MLOGIC(EMAIL):  Parameter STUDY has value 
SYMBOLGEN:  Macro variable DIRECTORY_START resolves to /data/
SYMBOLGEN:  Macro variable STUDY resolves to 
SYMBOLGEN:  Macro variable DIRECTORY_END resolves to /Formats/formats.sas
WARNING: Physical file does not exist, /data//Formats/formats.sas.
ERROR: Cannot open %INCLUDE file /data//Formats/formats.sas.

SYMBOLGEN:  Macro variable DIRECTORY_START resolves to /data/
SYMBOLGEN:  Macro variable STUDY resolves to 
SYMBOLGEN:  Macro variable LIB_END resolves to /Programs/temp
MPRINT(EMAIL):   libname temp "/data//Programs/temp";
NOTE: Library TEMP does not exist.

Re: macro variable not resolving

Reeza — Wed, 21 Jul 2021 23:43:27 GMT

Does the code work without macro variables at all? It doesn't seem like a macro variable issue....you do have duplicate // which I'm fairly sure SAS ignores but you could also fix that to confirm. Note that Unix systems have case sensitive paths, so if this is in Academics on Demand, it's a Unix box.

What is the log message for these:

libname temp '/data//Programs/temp';

libname temp '/data/Programs/temp';

Re: macro variable not resolving

Astounding — Thu, 22 Jul 2021 00:03:47 GMT

Take a look at the file you are bringing in with %INCLUDE. It is likely that you will find the answer there.

Re: macro variable not resolving

ballardw — Thu, 22 Jul 2021 00:30:07 GMT

Your %let statement where you "assign" a value to Study is commented out so does not execute.

%let lib_end= /Programs/temp;
*%let study = %nrstr(Study03-0072);

Remove the * and try it again.

When you get any message like this where there is no "resolved" value appearing the first thought should always be: check where the variable is created/assigned.

SYMBOLGEN:  Macro variable STUDY resolves to

Re: macro variable not resolving

paulchinky50 — Tue, 17 Aug 2021 07:42:08 GMT

Damm even I am having a similar kind of issue, I have searched all over the internet and even have posted on number of threads on different forum, no solution seems to work. I am really frustrated, can anyone of you here help me resolve this issue, I am very much tired now. mobdro

Re: macro variable not resolving

PaigeMiller — Thu, 22 Jul 2021 11:35:04 GMT

@paulchinky50 wrote:

Damm even I am having a similar kind of issue, I have searched all over the internet and even have posted on number of threads on different forum, no solution seems to work. I am really frustrated, can anyone of you here help me resolve this issue, I am very much tired now.

Please start a new thread, and be sure to describe the problem completely, include both the code and the LOG. (We need to see the entire log, not selected parts of it)