Desktop productivity for business analysts and programmers

Return Column Name?

Reply
Contributor
Posts: 23

Return Column Name?

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?

Respected Advisor
Posts: 3,156

Re: Return Column Name?

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

Contributor
Posts: 23

Re: Return Column Name?

Thanks, I'll check into it.

Ask a Question
Discussion stats
  • 2 replies
  • 178 views
  • 3 likes
  • 2 in conversation