topic Re: Changing Data-Type: (Numeric to Categorical) SAS Studio in New SAS User

Changing Data-Type: (Numeric to Categorical) SAS Studio

brush01 — Tue, 19 Oct 2021 02:17:27 GMT

I'm working with the MTCars data set in SAS Studio, and noticed the cylinder column is of numeric type. I feel that because the number of cylinders in a car is either 4, 6, or 8, a data-type of categorical would be more appropriate. (I have included a screenshot of my issue.)

https://prnt.sc/1woaj4u

How do I change a data-type when working with a data set?

Re: Changing Data-Type: (Numeric to Categorical) SAS Studio

Reeza — Tue, 19 Oct 2021 02:26:00 GMT

You don't need to change the type of the variable.

Depending on which procedure you're using, you can include your variable in the CLASS statement and SAS will treat it as categorical variable. You can recode it to a character but it's unnecessary, categorical, nominal, or ordinal variables can be numeric or character in SAS.

Ordinal logistic model example:

proc logistic data=sashelp.cars;
class cylinders / param=ref;
model origin = cylinders;
run;

@brush01 wrote:

I'm working with the MTCars data set in SAS Studio, and noticed the cylinder column is of numeric type. I feel that because the number of cylinders in a car is either 4, 6, or 8, a data-type of categorical would be more appropriate. (I have included a screenshot of my issue.)

https://prnt.sc/1woaj4u

How do I change a data-type when working with a data set?

Re: Changing Data-Type: (Numeric to Categorical) SAS Studio

Reeza — Tue, 19 Oct 2021 02:28:15 GMT

If you do want to convert it, SAS requires it to be a new variable so something like below:

data cars;
set sashelp.cars;
Cylinder_character = put(cylinders, 8. -l);
run;

Re: Changing Data-Type: (Numeric to Categorical) SAS Studio

tarheel13 — Tue, 19 Oct 2021 17:33:22 GMT

you can use if-else statements if you really want a categorical variable.