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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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