topic Re: How to pass a global variable to urlencode in SAS Programming

How to pass a global variable to urlencode

shlomiohana — Mon, 20 Nov 2023 20:22:17 GMT

Hello,

I try to pass a global variable in the urlencode function and get an invalid link, I run the following code:

%let globalVar = 201080;

data  test;
    original_string = urlencode('<SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>');
run;

If I enter the number itself 201080 I will get a proper link.

my question is how to pass a global variable to the urlencode function?

I get a valid link:

urlencode('<SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>201080</SMF_RETURN_MESSAGE></SMF_REPLY>')

thanks.

Re: How to pass a global variable to urlencode

Patrick — Mon, 20 Nov 2023 22:02:31 GMT

You need to use double quotes for the SAS macro variable to resolve.

%let globalVar = 201080;

data  test;
    original_string = urlencode("<SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>");
run;

Re: How to pass a global variable to urlencode

shlomiohana — Tue, 21 Nov 2023 15:28:43 GMT

This is not good i get an error because the full urlencode is:

original_string = urlencode('<?xml version="1.0" encoding="UTF-8"?><SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>'

Re: How to pass a global variable to urlencode

Patrick — Tue, 21 Nov 2023 15:55:21 GMT

Below code should do as long as you don't expect an ampersand or percent sign in your source string that shouldn't get interpreted as a macro token.

%let globalVar = 201080;

data test;
  length original_string $300;
  original_string = 
    '<?xml version="1.0" encoding="UTF-8"?><SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>';
  original_string=urlencode(strip(resolve(original_string)));
  put original_string;
run;

The encoded string will be longer than the original string. Make sure that your variable has a length defined that's sufficient for the encoded string.

Or this way will also work

data test;
  length original_string $300;
  original_string = cats(
    '<?xml version="1.0" encoding="UTF-8"?><SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>'
    ,"&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>"
    );
  original_string=urlencode(strip(original_string));
  put original_string;
run;