Hi Guys,
After I run risk scores for claims, I go through my equation to figure out which variable had the highest effect on the risk score. Currently, I have to export to excel, copy the column names under the data set and HLOOKUP to the column name with the largest value in the row. I am looking to automate this process soon. Does anyone know of a way I could return a column name as a field value in EG. I'd want a solution based off a case statement to return the column name of a given condition, not brute force case statements for all 125 variables in the equation 🙂 Any thoughts?
You will need to write some SAS code in EG. Check docs on "VNAME" and "ARRAY()", for now it seems to me that data step (one step solution) is more appropriate, but that can be changed if more information is provided.
Haikuo
Thanks, I'll check into it.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.