topic Re: How to use a string variable as a column in sas rule in Fraud, AML and Security Intelligence

How to use a string variable as a column in sas rule

pdsaiteja — Thu, 29 Dec 2022 17:37:42 GMT

Hi All,

I am working on SAS FM rules. I would like store a column name in a variable like below.

&rule.name = 'column_name';

This is because the column name gets updated every year. Instead of replacing the column name in the sas code, I would like to pass it a string. Eventually I will get this string (column name) from lookuplist.

Generally the code works like this.

column_name <= 350

then do;

I would like to change it to.

&rule.name <= 350

then do;

But I got an error that i am comparing the string to numeric, which is obvious. Please help me out with this automation.

Thank you

Re: How to use a string variable as a column in sas rule

PaigeMiller — Thu, 29 Dec 2022 21:58:47 GMT

When you execute code with macro variables in it, the value of the macro variable is used in place of the macro variable, and this must create valid legal working SAS code.

So, when you run this line of code

if &rule.name <= 350 then do;

SAS really executes this:

if 'column_name' <= 350 then do;

Can you see why this is not a valid SAS statement that causes errors?

It will work if you remove the quotes, assuming COLUMN_NAME is really a numeric variable name that exists in the data set. Whether or not that is what you want is another issue.

Re: How to use a string variable as a column in sas rule

Kurt_Bremser — Thu, 29 Dec 2022 23:47:47 GMT

First and foremost, keep in mind that the macro language is a text replacement tool for generating dynamic code. It has no "data types" except text, and does not need quotes, unless you want the quotes to be part of the text.

Re: How to use a string variable as a column in sas rule

pdsaiteja — Thu, 12 Jan 2023 20:34:31 GMT

Hi Kurt,

Thanks for your reply and Happy New Year!

I am using lookup list to retrieve the string. As it is coming in the string format, it throwing an error. Please refer the below code and help me out.

&rule.name = '';

&rule.column_type = 'abc'; (This is the key field supplied to list contains)

if
%listcontains(lookuplist_name,&rule.column_type)
then do;

&rule.name = &listvalue.column_name;

end;

I am doing all of this in SASFM rules. Please help me out.

Thanks,

Sai Teja