topic Re: create the dummy variables for the character variables in the dataset in SAS Enterprise Guide

create the dummy variables for the character variables in the dataset

relish — Tue, 01 May 2018 21:14:28 GMT

I want to join the two datasets to do the analyzing work, while for one data file, all the variables are characters, so how to transform them?

Re: create the dummy variables for the character variables in the dataset

art297 — Tue, 01 May 2018 21:16:07 GMT

Provide an example of what you have and what you want.

Art, CEO, AnalystFinder.com

Re: create the dummy variables for the character variables in the dataset

relish — Tue, 01 May 2018 21:20:06 GMT

sorry for misunderstanding, I am analyzing the customer lifetime value related content, while one variable is called lifstage, which is divided to on-contract, off-contract, expiry,pre-expiry,early tenured, so I want to create dummy virables to modify them, but I do not know how to use sas EG to complete it, or is there any other good methods to finish the relationship analyzing?

Re: create the dummy variables for the character variables in the dataset

Reeza — Tue, 01 May 2018 21:29:41 GMT

Depending on the model you're running, if you include it in the Categorical or CLASS list SAS will automatically do this for you.

Otherwise, here are several ways to create dummy variables:

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

Re: create the dummy variables for the character variables in the dataset

relish — Wed, 02 May 2018 08:09:06 GMT

thanks so much for your relay, I have tried the glmmod method, while the final resultes include too many vairables so SAS was filed to open the result¬¬

Re: create the dummy variables for the character variables in the dataset

Reeza — Wed, 02 May 2018 14:49:44 GMT

@relish wrote:

thanks so much for your relay, I have tried the glmmod method, while the final resultes include too many vairables so SAS was filed to open the result¬¬

Is that failed to open? How many variables did you have? I can only see that happening if you tried to include a continuous variable in the CLASS list.