topic Re: SAS Enterprise Miner importation problem in SAS Data Science

SAS Enterprise Miner importation problem

MaVe — Wed, 01 Jun 2016 09:48:09 GMT

Hello, I'm trying to import a .csv file (click here to download) in SAS EM 14.1. There are 4 continous variables, with missing values marked by ?, and 1 nominal variable, but the program sets them as nominals and it let me change their levels to anything but continuos. Probably is ?'s fault. What can I do to fix this problem? Thank you in advance.

P.S.: I had to set the delimiter character to ; before importing

Re: SAS Enterprise Miner importation problem

WendyCzika — Wed, 01 Jun 2016 18:39:04 GMT

Yes, I think you need to change the '?'s to '.'s for the missing values. The '?' makes it think those columns are character instead of numeric, so that's why it will only allow the level to be nominal. Hope that helps (and let me know if that doesn't work).

Re: SAS Enterprise Miner importation problem

MaVe — Wed, 01 Jun 2016 20:55:52 GMT

@WendyCzika wrote:
Yes, I think you need to change the '?'s to '.'s for the missing values. The '?' makes it think those columns are character instead of numeric, so that's why it will only allow the level to be nominal. Hope that helps (and let me know if that doesn't work).

Thank you very much for the tip, it worked! I had to edit the file manually entry-by-entry, because in Excel when I tried to make the replace function (the one next to search) substitute the "?"s with "."s, the program replaced every character of every cell with ".". I was lucky the missing values were just ~20 and the dataset was small, so there was only a little manual work, but I wonder how to replace automatically in .csv files with Excel.

Re: SAS Enterprise Miner importation problem

WendyCzika — Thu, 02 Jun 2016 01:44:22 GMT

It looks like you need to escape the ? with a tilde when you do the Replace in Excel, so enter

in the Find what field.

Re: SAS Enterprise Miner importation problem

MaVe — Thu, 02 Jun 2016 10:21:21 GMT

@WendyCzika wrote:
It looks like you need to escape the ? with a tilde when you do the Replace in Excel, so enter
~?
in the Find what field.

Thank you very much again for the support!