Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Create datasource from .data file

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Create datasource from .data file

Hello,

I'm still new to SAS Enterprise Miner.

I have a question: is there any possibility to create data source from .data file in SAS Enterprise Miner 6.2? Data sets come from UCI repository.

I would be grateful for any help.


Accepted Solutions
Solution
‎08-15-2017 10:45 AM
SAS Employee
Posts: 179

Re: Create datasource from .data file

Posted in reply to PiratDrogowy

I do not recognize that extension specifically but it is not uncommon for repositories to store text files with names such as the one you describe.  If it is a special file structure, the application which created can all but certainly export to a text format (e.g. .TXT, .CSV, etc...). 

 

I would suggest the following steps:

  1 - try and open the document with an application that reads text 

  2 - determine which delimeter(s) being used to separate the fields (e.g. tab, pipe, space, comma, etc...)

  3 - if you Microsoft Excel, try and import the .DATA file specifying the appropriate delimiter(s) and verify the data imports correctly

  4 - use the File Import node in SAS Enterprise Miner to save the Microsoft Excel file you created in step 3

 

Note: Although step 3 is not necessary technically, it provides you an opportunity to get your data into a more structured format that a text document so no additional work is required prior to importing it into SAS Enteprise Miner.  

 

I hope this helps!

Doug

View solution in original post


All Replies
Solution
‎08-15-2017 10:45 AM
SAS Employee
Posts: 179

Re: Create datasource from .data file

Posted in reply to PiratDrogowy

I do not recognize that extension specifically but it is not uncommon for repositories to store text files with names such as the one you describe.  If it is a special file structure, the application which created can all but certainly export to a text format (e.g. .TXT, .CSV, etc...). 

 

I would suggest the following steps:

  1 - try and open the document with an application that reads text 

  2 - determine which delimeter(s) being used to separate the fields (e.g. tab, pipe, space, comma, etc...)

  3 - if you Microsoft Excel, try and import the .DATA file specifying the appropriate delimiter(s) and verify the data imports correctly

  4 - use the File Import node in SAS Enterprise Miner to save the Microsoft Excel file you created in step 3

 

Note: Although step 3 is not necessary technically, it provides you an opportunity to get your data into a more structured format that a text document so no additional work is required prior to importing it into SAS Enteprise Miner.  

 

I hope this helps!

Doug

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 240 views
  • 0 likes
  • 2 in conversation