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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.