topic SAS Programming: categorical and numerical variable SAS Table in SAS Programming

SAS Programming: categorical and numerical variable SAS Table

etsfor — Fri, 02 Oct 2020 02:04:59 GMT

I am using a SAS Studio On Demand for Academics and upload a Excel file to File and Folder. The Excel file has some numerical and categorical variable (using numbers).

When I am create a SAS Table by using:

Options validvarname=v7;

Libname Cedrela xlsx "path....";

My SAS Table consider all variables as numeric variable. Moreover, when I am try to build a Categorical plot (e.g. box plot) by Task and Utilities its not possible because all variable is a numeric.

My I use a Proc step to format the variable or at Excel is possible do classify the variable?

Re: SAS Programming: categorical and numerical variable SAS Table

SASKiwi — Fri, 02 Oct 2020 02:29:57 GMT

From experience I've found that if you do a "Data / Text to Columns" on the Excel columns you want treated as text / categorical, then reread the sheet into SAS that should fix your problem.

Re: SAS Programming: categorical and numerical variable SAS Table

Reeza — Fri, 02 Oct 2020 15:31:49 GMT

Is it possible you have that backwards?

Variables to be summarized mathematically must be numeric variables. Variables to be used as categories can be either numeric or character and it wouldn't matter to the procedure.

Please provide more details about the issues you're encountering.

A box plot would require at least one continuous variable which should be numeric. You could have multiple plots then split by category which could be either a character or numeric variable AFAIK.

@etsfor wrote:

I am using a SAS Studio On Demand for Academics and upload a Excel file to File and Folder. The Excel file has some numerical and categorical variable (using numbers).

When I am create a SAS Table by using:

Options validvarname=v7;

Libname Cedrela xlsx "path....";

My SAS Table consider all variables as numeric variable. Moreover, when I am try to build a Categorical plot (e.g. box plot) by Task and Utilities its not possible because all variable is a numeric.

My I use a Proc step to format the variable or at Excel is possible do classify the variable?