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?
... View more