05-06-2013 09:22 AM
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?
05-06-2013 09:46 AM
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.