topic Return Column Name? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130229#M10657 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>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.&nbsp; 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.&nbsp; I am looking to automate this process soon.&nbsp; Does anyone know of a way I could return a column name as a field value in EG.&nbsp; 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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp; Any thoughts?</P></BODY></HTML> Mon, 06 May 2013 13:22:41 GMT sasspan 2013-05-06T13:22:41Z Return Column Name? https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130229#M10657 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>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.&nbsp; 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.&nbsp; I am looking to automate this process soon.&nbsp; Does anyone know of a way I could return a column name as a field value in EG.&nbsp; 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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp; Any thoughts?</P></BODY></HTML> Mon, 06 May 2013 13:22:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130229#M10657 sasspan 2013-05-06T13:22:41Z Re: Return Column Name? https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130230#M10658 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Haikuo</P></BODY></HTML> Mon, 06 May 2013 13:46:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130230#M10658 Haikuo 2013-05-06T13:46:03Z Re: Return Column Name? https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130231#M10659 <HTML><HEAD></HEAD><BODY><P>Thanks, I'll check into it. </P></BODY></HTML> Mon, 06 May 2013 13:48:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-Column-Name/m-p/130231#M10659 sasspan 2013-05-06T13:48:50Z