topic Re: Dummy Variable Creation Macro in SAS Data Science

Dummy Variable Creation Macro

dsp1 — Fri, 02 Feb 2018 05:33:43 GMT

Hi, I am looking for a macro which needs to do some tasks as mentioned below.

It should create dummy variables like we have "Dummies" package in R which will create dummy variables for all categorical variables based on some conditions like in some variables we have categories like more than 20 or 30 etc. and for those type of variables it should skip and drop original variables after creating dummy variables....

If anyone have this macro, please share with us...

Thanks in advance.

Re: Dummy Variable Creation Macro

andreas_lds — Fri, 02 Feb 2018 06:04:05 GMT

I don't know R ... maybe posting what you have and what you want as datasets will make it easier to help you. And also post the code you have already written to solve your problem.

Re: Dummy Variable Creation Macro

user24feb — Fri, 02 Feb 2018 09:22:44 GMT

In SAS you probably want to use a CLASS-statement. It handles categorical data for proc reg, logistic, glm ..

And note that R and SAS are 2 different programming languages. In SAS you can add those statements either to a proc, or you need a data-step to create them yourself.

Re: Dummy Variable Creation Macro

Kurt_Bremser — Fri, 02 Feb 2018 07:35:58 GMT

This such a simple task that a macro would be overkill, both in terms of writing and in terms of using it.

Re: Dummy Variable Creation Macro

RW9 — Fri, 02 Feb 2018 09:12:18 GMT

And what have you done? As in your previous posts, this is not a contract work request forum, it is a Q&A forum. If you have specific questions, then pose the question using descriptive text, with example test data in the form of a datastep, and what you want to see out. Post code that you have tried, and logs of any errors/warnings.

Re: Dummy Variable Creation Macro

Ksharp — Fri, 02 Feb 2018 12:53:40 GMT

https://blogs.sas.com/content/iml/2016/02/24/create-a-design-matrix-in-sas.html

Re: Dummy Variable Creation Macro

PaigeMiller — Fri, 02 Feb 2018 13:05:12 GMT

@dsp1 wrote:

Hi, I am looking for a macro which needs to do some tasks as mentioned below.

It should create dummy variables like we have "Dummies" package in R which will create dummy variables for all categorical variables based on some conditions like in some variables we have categories like more than 20 or 30 etc. and for those type of variables it should skip and drop original variables after creating dummy variables....

If anyone have this macro, please share with us...

Thanks in advance.

Hey @dsp1 you could save yourself a lot of time by just doing searches here in this forum or in Google.

Here is a long thread that covers lots of good information about creating dummy variables.

https://communities.sas.com/t5/SAS-Procedures/How-can-i-create-dummy-variables-How-can-i-change-my-code/m-p/404308#M66929

Re: Dummy Variable Creation Macro

Reeza — Fri, 02 Feb 2018 16:04:55 GMT

Note that SAS will do this automatically in some PROCS via the CLASS statement, otherwise, I find this covers most ways to create dummy variables:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-dummy-variables-Categorical-Variables/ta-p/308484

There are a multitude of ways to do this.