topic Re: create dummy variables - Categorical Variables in SAS Programming

create dummy variables - Categorical Variables

s_manoj — Tue, 06 Mar 2018 09:29:31 GMT

Hi all,

I have dataset "SAMPLE", contains a player variable with records playerA, playerB,......... PlayerH, and country variable with records countryA, countryB,.....countryF. I want to create dummy variables for each category in player and country variables. If I go by writing general IF-THEN statement it takes very long code to write. Please suggest me very simple code to create dummy variables for player, country variable and also i want to create interaction variable between player and country variable.

Here sample dataset:

Expected output:

Thanks in advance

Regards

S Manoj

Re: create dummy variables - Categorical Variables

Kurt_Bremser — Tue, 06 Mar 2018 08:14:02 GMT

Please supply example data in a data step with datalines, so we have data to work with.

And show the expected result for that example dataset, so we can get a picture for the logical rule behind it.

Re: create dummy variables - Categorical Variables

Astounding — Tue, 06 Mar 2018 09:00:40 GMT

It's quite difficult to picture with the final result should look like. Here's one possibility. Perhaps you could comment about what you want, vs. what this does:

proc sql;

create table want as select * from sample, country;

quit;

Re: create dummy variables - Categorical Variables

Kurt_Bremser — Tue, 06 Mar 2018 09:33:32 GMT

Code is pure text. Please DO NOT POST PICTURES OF CODE!!! Forcing people to type text from pictures is kind of rude.

Use the proper buttons ("little running man" and {i}) to post code and logs or other fixed-space text.

Re: create dummy variables - Categorical Variables

Astounding — Tue, 06 Mar 2018 09:35:30 GMT

Before you go too far down this path, you should realize that SAS procedures often create both dummy variables and interaction terms as needed. See if the procedure you intend to use supports the CLASS statement.

You run the risk of many complications here, including country names that contain multiple words, and player names that are too long to turn into a variable name.

Re: create dummy variables - Categorical Variables

Ksharp — Tue, 06 Mar 2018 13:04:03 GMT

As other said ,post SAS CODE ,not picture, nobody would like to type it for you.

It is very easy for IML code. But here is BASE code.

data new;
input score player $ country $;
dummy=1;
cards;
10 A A
28 B B
87 C B
;
run;
proc logistic data=new outdesignonly outdesign=design;
class player country/param=glm;
model dummy=player country;
run;
data want;
 merge new(drop=dummy) design(drop=dummy intercept);
run;
proc print noobs;run;

Re: create dummy variables - Categorical Variables

PaigeMiller — Tue, 06 Mar 2018 13:34:13 GMT

Very long thread discussing many ways to create 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

Furthermore, if you are one the many modeling procedures in SAS, you don't need to create your own dummy variables anyway, this is all done internally in the procedure.

Re: create dummy variables - Categorical Variables

s_manoj — Wed, 07 Mar 2018 08:34:43 GMT

Thank you for code,
and I just want to know, within in this code is there any way to get the output with customized dummy variable name

Re: create dummy variables - Categorical Variables

Ksharp — Wed, 07 Mar 2018 10:13:05 GMT

No. you can't. But you change variable name after getting DESIGN dataset.

If you are using IML code, IML can do that.