cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pdsaiteja
‎01-19-2023
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

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

by Calcite | Level 5 in Fraud, AML and Security Intelligence
‎01-12-2023 03:34 PM
‎01-12-2023 03:34 PM
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 ... View more

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

by Calcite | Level 5 in Fraud, AML and Security Intelligence
‎12-29-2022 12:37 PM
‎12-29-2022 12:37 PM
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.   if column_name <= 350 then do;   I would like to change it to.  if &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       ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-19-2023 07:06 PM
Quick links