Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA 7.2 hotfix 03: measure wrongly assigned as category while uploading from Excel

Reply
Contributor
Posts: 28

SAS VA 7.2 hotfix 03: measure wrongly assigned as category while uploading from Excel

I tried to upload a excel file with 3 category variables and 13 measures. after importing only 3 of the 13 retained measure. 10 numeric variables were automatically converted to category and there is no option to change (check the image). Do I need to make some change while I import? or something in Excel I need to change? 

Attachment
SAS Super FREQ
Posts: 407

Re: SAS VA 7.2 hotfix 03: measure wrongly assigned as category while uploading from Excel

The most likely reason why this would occur is that those fields contained something other than just numbers. Also check that you have selected the option to use the first row as column names.

Contributor
Posts: 28

Re: SAS VA 7.2 hotfix 03: measure wrongly assigned as category while uploading from Excel

I have selected the first row is column and my input looks like the (pic). 

Attachment
Ask a Question
Discussion stats
  • 2 replies
  • 256 views
  • 0 likes
  • 2 in conversation