BookmarkSubscribeRSS Feed
relish
Calcite | Level 5

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?

5 REPLIES 5
art297
Opal | Level 21

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

 

Art, CEO, AnalystFinder.com

 

relish
Calcite | Level 5

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?

Reeza
Super User

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-Var...

relish
Calcite | Level 5

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¬¬

Reeza
Super User

@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. 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2107 views
  • 0 likes
  • 3 in conversation