How to label values in a variable in Enterprise Miner?

Lychee — Thu, 30 Oct 2014 15:04:52 GMT

I have several 9-point liker scale variables in my input data node in the diagram. Is there any way that I can label them? Thus the 1 will show "Extremely likely" and 9 will show "Extremely unlikely" Thanks.

Re: How to label values in a variable in Enterprise Miner?

WendyCzika — Mon, 03 Nov 2014 16:07:31 GMT

You can use formats to have character values displayed for numeric values. If you already have the data set created, you can run code similar to the following in a Program Editor:

libname myfmtlib " /* path to folder to save format definition */ ";

proc format library=myfmtlib;

value myscale 1='Extremely likely'

5='Kind of likely'

9='Extremely unlikely'

other='n/a'

;

run;

options fmtsearch=(myfmtlib);

data libref.newdata;

format /* name of numeric columns you want format applied to */ myscale.;

set libref.olddata;

run;

After creating this data set libref.newdata that has the format applied, you will need to run and save this code in your Project Start Code in Enterprise MIner:

libname myfmtlib " /* path to folder to save format definition */ ";

options fmtsearch=(myfmtlib);

Then you should be able to create a data source in Enterprise Miner for this new data set, and run flows as usual.

Hope that works for you!

topic How to label values in a variable in Enterprise Miner? in SAS Data Science

How to label values in a variable in Enterprise Miner?

Re: How to label values in a variable in Enterprise Miner?