BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
anon_pvok
Fluorite | Level 6

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

Capture.JPG.

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

 

Below is the sample data 

Capture2.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
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.

View solution in original post

5 REPLIES 5
anon_pvok
Fluorite | Level 6

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

Reeza
Super User
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.
anon_pvok
Fluorite | Level 6

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.

Capture.JPG

 

Reeza
Super User
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.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 940 views
  • 1 like
  • 3 in conversation