topic Re: How to pass a value from dataset into a macro in SAS Programming

How to pass a value from dataset into a macro

JAR — Mon, 20 May 2019 08:48:25 GMT

HI,

I have the following macro:

/********************************************************/
%Macro DeepLink(site);
filename source temp;

PROC HTTP
URL = &site
OUT = source
METHOD = "GET";
RUN;



DATA Jar.Dir1(DROP = line); 
LENGTH Rec $3000.;
INFILE source LENGTH = recLen LRECL = 32767;
INPUT line $VARYING32767. recLen;

IF FIND(line, '<td><p>') GT 0 and scan(scan(line, 3, '>'), 1, '<')>0 THEN DO; 
DIN=scan(scan(line, 3, '>'), 1, '<');
OUTPUT;
END;
RUN;



%mend;

/********************************************************/



/*The following works ok:

%DeepLink("https://www.[some confidential site].com/exceptionalfiles");
%DeepLink("https://www.[some confidential site].com/coolfiles");

The addresses passed are in a dataset (with only one variable and 1000 observations). Is there a way I can pass all the 1000 sites from the dataset into the macro?

Thank you all in advance,
JAR

Re: How to pass a value from dataset into a macro

Kurt_Bremser — Mon, 20 May 2019 08:53:04 GMT

Use call execute():

data _null_;
set your_dataset;
call execute(cats('%nrstr(%deeplink(',site,'))');
run;

Re: How to pass a value from dataset into a macro

JAR — Mon, 20 May 2019 12:40:04 GMT

Thank you very much. However, your code generated this error:

ERROR: Physical file does not exist, /saswork/SAS_workD73D0000F7EE_odaws01-prod-sg/#LN01235.

Please help!

JAR

Re: How to pass a value from dataset into a macro

Kurt_Bremser — Mon, 20 May 2019 12:59:19 GMT

@JAR wrote:

Thank you very much. However, your code generated this error:

ERROR: Physical file does not exist, /saswork/SAS_workD73D0000F7EE_odaws01-prod-sg/#LN01235.

Please help!

JAR

That's most probably not the only ERROR, as I suspect that the proc http before that failed also.

Big hint: the last ERROR or WARNING message is the least, the first one the most important.

Re: How to pass a value from dataset into a macro

JAR — Mon, 20 May 2019 13:45:02 GMT

data _null_;
set Jar.TempData;
call execute(cats('%nrstr(%deeplink(',WebID,'))'));
run;

NOTE: Line generated by the macro variable "SITE".

76 https://www.confidential.com/AAM-6732

_____

ERROR 22-322: Expecting a quoted string.

ERROR 76-322: Syntax error, statement will be ignored.

Please help!

Re: How to pass a value from dataset into a macro

Kurt_Bremser — Mon, 20 May 2019 13:49:26 GMT

Within the macro, put double quotes round the URL:

PROC HTTP
URL = "&site"
OUT = source
METHOD = "GET";
RUN;

Re: How to pass a value from dataset into a macro

Tom — Mon, 20 May 2019 13:53:56 GMT

Most likely the values in your dataset do not have quotes around them the way your manual calls to the macro did.

I would use the QUOTE() function to add the quotes. I would use single quotes in case the values had anything that might look like macro triggers to the SAS macro processor. Also normally I close the %NRSTR() function call at the end of the macro name instead of also wrapping it around the parameter list for the macro call.

data _null_;
  set Jar.TempData;
  call execute(cats('%nrstr(%deeplink)(',quote(trim(WebID),"'"),')'));
run;

Re: How to pass a value from dataset into a macro

JAR — Mon, 20 May 2019 14:09:22 GMT

Thank you so much. Your original code, modified by Tom, is easier than this. But, it is your code Tom modified. thanks!