topic Re: Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE in SAS Procedures

Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE

anon_pvok — Thu, 04 Jul 2019 11:43:41 GMT

While running the below code

PROC TABULATE DATA=WORK.REPORT_IM;
	TITLE1 'DETECTION BY INVESTIGATOR : MAKER';
	TITLE2 'ZONE :QATAR';	
	CLASS MAKER_NAME X_RT_CHANNEL X_CURRENCY X_PS_MAKER_ACTION;
	TABLE (MAKER_NAME*X_RT_CHANNEL*X_CURRENCY), (X_PS_MAKER_ACTION )
	/box=[label='Maker by Channel and Currency'];
RUN;

I am getting UDF_VALUE instead of Class names

How do I get rid of these and instead show the actual Class Names?

Below is the sample data

Re: Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE

Kurt_Bremser — Thu, 04 Jul 2019 11:51:03 GMT

Please supply example data in usable form (a data step with datalines). Typing data off pictures(!) is tedious and prone to mistakes.

Re: Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE

anon_pvok — Thu, 04 Jul 2019 11:57:30 GMT

I apologize, please find attached the data in sas and .csv format.

Re: Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE

Reeza — Thu, 04 Jul 2019 15:04:26 GMT

That's your SAS code? Can you provide the log? Your code has no UDF_VALUE so where is that coming from? Also, post a proc contents for your data set. The data below won't help if you have an issue between labels and variable names.

Re: Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE

anon_pvok — Fri, 05 Jul 2019 17:23:57 GMT

Thank you for bring up Labels, had totally forgotten about them.

I had transformed a vertical table into a horizontal table. The vertical tables column name was UDF_VALUE. So thats where it came from.

Thank You again.

Please find below the proc contents output(snippet) of my data set.

Re: Getting UDF_VALUE instead of Class Values(ROW and Column Names) in Output of PROC TABULATE

Reeza — Fri, 05 Jul 2019 17:27:21 GMT

Right, so changing the labels is a quick fix that should solve your problem. In the transpose step, there's an option for IDLABEL to create a label variable if necessary.