topic Re: How to create dummy variable in SAS Enterprise Miner? in SAS Data Science

How to create dummy variable in SAS Enterprise Miner?

sdhilip — Sat, 27 Apr 2019 05:45:38 GMT

I am using SAS Enterprise Miner. I have a column "Gender" which has Male and Female. I just wanted to create dummy variable in Miner.

Want to assign Male =1 and Female = 0

I can create in SAS guide using Proc class function. But I do not know how to create in SAS Enterprise Miner. Please advise

Regards,

Dhiip

Re: How to create dummy variable in SAS Enterprise Miner?

VDD — Sat, 27 Apr 2019 15:09:00 GMT

data have;
input id gender $8.;
cards;
1 Female
2 female
3 male
4 f
5 Male
6 mAle
7 eddy
;
data want;
	set have;
	if upcase(substr(gender,1,1))="F" then my_val = 0;
	else if upcase(substr(gender,1,1))="M" then my_val = 1;
	else my_val = .; /* catch the errors */
run;

Re: How to create dummy variable in SAS Enterprise Miner?

sdhilip — Sat, 27 Apr 2019 20:13:12 GMT

Hi @VDD

Thanks. But how to create this code in SAS Enterprise miner?

Re: How to create dummy variable in SAS Enterprise Miner?

PaigeMiller — Sat, 27 Apr 2019 21:46:58 GMT

In Enterprise Miner, use the Transform Variable node.

https://documentation.sas.com/?docsetId=emref&docsetTarget=n0f3ix7imzm4xrn1773i0xuq47mj.htm&docsetVersion=14.3&locale=en

Re: How to create dummy variable in SAS Enterprise Miner?

sdhilip — Sun, 28 Apr 2019 01:31:47 GMT

@PaigeMiller Thanks I will try with transform variables. I have one more issue with handling missing values in miner

I have a column Age which has 19% missing value. Also, it has a column name called travelled class. I need to assign mean in place of missing value according to the class. For example, If people travelled in the first class I then I need to assign 37. If it is the second class then it is 29 and 24 if people travelled in third class.

I tried to do in impute but it doesn't have an option to fill three values in the 'Age' column. Any suggestion about how to do this?

Re: How to create dummy variable in SAS Enterprise Miner?

PaigeMiller — Sun, 28 Apr 2019 12:13:23 GMT

You can do this using a Code Node

https://support.sas.com/documentation/cdl/en/emxndg/64759/HTML/default/viewer.htm#n1t582v60um7p9n1h9d169o0dd8e.htm

I'm not sure if there is an easier way.