topic Re: For each value in one variable check if in another variable in SAS Programming

For each value in one variable check if in another variable

TheRealHunterC — Thu, 30 Apr 2020 21:17:14 GMT

Hello,

I'm comparing two let variables that have multiple strings in each and I want to be able to tell if a string has been added to the second let variable. For an example if I have the following:

%let all_codes_jan = a, b, c, d, e, f;
%let all_codes_march = a, b, c, d, e, f, g;

I want to find that the code g was added and is a value in the second let variable that is not included in the first let variable. I have used in and not in before in proc sql but I dont know how to do this when there are many codes in each variable, and they are not columns in a table.

Thanks in advance for any help you can offer!

Re: For each value in one variable check if in another variable

Astounding — Thu, 30 Apr 2020 22:05:54 GMT

You're right. SQL handles this type of problem easily, as long as you keep your data in data sets. Why create macro variables when all they do is make the programming more complex? Do you have a choice?

Re: For each value in one variable check if in another variable

ballardw — Thu, 30 Apr 2020 23:00:28 GMT

What does the result of your comparison actually look like? An assigned value to a macro variable, if so what does it look like? A value in a data set? A message written to the log or results window?

And is this "added" an "added at the end" (as your example implies) or "some value inserted into a random location"?

Or what if the order of values changes? is "a,b,c" the same as "b,c,a"? If not, what is the result?

Is there any particular reasons you are placing commas in the values? If you want to do this with macro coding then the presence of the commas will likely make the code much more complicated because the comma is the delimiter in functions.

Re: For each value in one variable check if in another variable

ChrisNZ — Thu, 30 Apr 2020 23:44:29 GMT

For your example (one-character strings), the verify macro would be useful.

See here https://www.lexjansen.com/phuse/2010/po/PO05.pdf

Re: For each value in one variable check if in another variable

TheRealHunterC — Fri, 01 May 2020 17:04:20 GMT

Yes it sounds like I should just keep it simple.