topic Re: concatenate two macro variables with "/" between them in SAS Programming

concatenate two macro variables with "/" between them

Ronein — Tue, 30 Apr 2024 11:23:25 GMT

Hello

I want to concatenate two macro variables with "/" between them.

I get error 49


%let customer_ID=9872622;
%let branch_Id=987;
%let customer_branch=%sysfunc(cat(&customer_ID.,"/",&branch_Id.));/***9872622/987*****/
%put &customer_branch;

Re: concatenate two macro variables with "/" between them

Astounding — Tue, 30 Apr 2024 12:04:21 GMT

You are overcomplicating things. This would be the usual way to concatenate strings in macro language:

%let customer_branch=&customer_ID./&branch_Id.;

Simple. Macro language does not perform math in a %let statement However, if you use the variable later, macro language may try to perform math. For example, this statement would have the potential to cause trouble:

%if 9872622/987 = &customer_branch %then %do;

%IF/%THEN statements do try to perform math. While there are a few ways to suppress this, an easy way would be to add double quotes:

%if "9872622/987" = "&customer_branch" %then %do;

The quotes become part of the comparison.

Re: concatenate two macro variables with "/" between them

PaigeMiller — Tue, 30 Apr 2024 13:26:04 GMT

No quotes used inside %SYSFUNC

%let customer_branch=%sysfunc(cat(&customer_ID.,/,&branch_Id.));

But really @Astounding has the better advice.

Is it mandatory to use a slash here (which sometimes will be interpreted as division)? Couldn't some other character, which isn't also a mathematical operator, such as underscore, work here? Do you even need a character like slash or underscore, could you just append customer_id and branch_id without any character between the two? All of this would make your programming simpler.

Re: concatenate two macro variables with "/" between them

Tom — Tue, 30 Apr 2024 18:16:04 GMT

I have never found any use for the CAT() series of functions in MACRO code.

First thing is they are just not needed. To place values next to each other all you have to do is place the values next to each other.

%let customer_branch=&customer_ID./&branch_Id.;

Second thing is that the CAT...() functions are some the most problematic for the %SYSFUNC() macro function. They can take either character or numeric values for all of their arguments. So poor %SYSFUNC() has to try and GUESS whether it should tell CAT... that the values it is send are numbers or strings.

The only one of them that might be useful to have in macro code is CATX() since replicating the inclusion of the delimiter only when there are non-empty values would be difficult without macro logic. So here is a SAS macro that can do for macro code what CATX() does for SAS code.

https://github.com/sasutils/macros/blob/master/catx.sas