topic Creating dummy variable for Address variable in SAS Data Science

Creating dummy variable for Address variable

rkarr5 — Tue, 14 Nov 2017 22:05:08 GMT

Hi,

Can anyone help me with this. I am doing data mining on the Chicago towing data which has tow data, make, towed to address, tow facility phone. I am trying to do a research on how many vehicles are towed to a particular address in the weekends and week days. For that, I choose tow to address as my target variable. Can anyone help me regarding the dummy variables for this variable.

Regards,

Ravi Teja Karri.

Re: Creating dummy variable for Address variable

Reeza — Tue, 14 Nov 2017 22:10:02 GMT

SAS typically creates the dummy variables needed, you need to make sure it's set to the correct variable type i.e. nominal and target.

Re: Creating dummy variable for Address variable

rkarr5 — Tue, 14 Nov 2017 22:18:01 GMT

Hi Reeza,

Thanks for the reply. We set the role of target variable to target and Level to nominal as it having string of characters and numbers. But there is no dummy variable created in our project. Can you help us in determining whether the dummy variables created or not?

Regards,

Ravi Teja Karri.

Re: Creating dummy variable for Address variable

Reeza — Tue, 14 Nov 2017 22:25:29 GMT

There are no dummy variables and created to the data set if that is what you're expecting.

The process will treat the variable according to whatever model you implemented. If you're not sure and really want to see if it does it correctly you can do one manually and one automatically and see if you get the same output. Make sure the correct parameterization method is selected in both if you're looking at a logistic regression for example.

Or look at the scoring code, there should be something in there, especially if you look at the data step.

Re: Creating dummy variable for Address variable

rkarr5 — Sun, 19 Nov 2017 22:26:59 GMT

Thanks for that. It helped me a lot.