Learning SAS? Welcome to the exclusive online community for all SAS learners.

Importing data while using AWS Marketplace

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Importing data while using AWS Marketplace

Hi!

I am using SAS University Edition from Amazon Web Services (AWS) Marketplace.

Can you please provide me instructions how to import txt file?

I have uploaded dataset to My Folders under ''Server Files and Folders''.

When I ran below mentioned code, I receive error message:

"NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/folders/myfolders/product_color.txt."

proc import datafile="folders/myfolders/product_color.txt"

            dbms=dlm

            out=colour

            replace;

     delimiter=',';

     getnames=yes;

run;

Can you please help me out solve this issue.

Thanks!


Accepted Solutions
Solution
‎08-16-2015 04:35 PM
SAS Super FREQ
Posts: 361

Re: Importing data while using AWS Marketplace

Hi, Tlou. Please try adding a leading slash to your path, like:

  proc import datafile="/folders/myfolders/product_color.txt"

Randy

View solution in original post


All Replies
Solution
‎08-16-2015 04:35 PM
SAS Super FREQ
Posts: 361

Re: Importing data while using AWS Marketplace

Hi, Tlou. Please try adding a leading slash to your path, like:

  proc import datafile="/folders/myfolders/product_color.txt"

Randy

New Contributor
Posts: 3

Re: Importing data while using AWS Marketplace

Thanks RandyMullis!

One slash makes huge difference Smiley Happy

Now import works.

Occasional Contributor
Posts: 10

Re: Proc Import Delimited Data

Hi, I'm receiving ERROR: Import unsuccessful. See SAS Log for details.  Log Notes say invalid data for [2 of the variables]...  However, it appears to be outputting all of the records to the working data set OK.

 

I'm using the following code to import a delimited file - Anyone have suggestions?

 

Appreciate it, Andy

 

PROC IMPORT DATAFILE="/folders/myfolders/PropertyData_R.txt"
DBMS=DLM
OUT=tad_import
REPLACE;
DELIMITER='|';
GETNAMES=YES;
RUN;

Community Manager
Posts: 552

Re: Proc Import Delimited Data

Hi @agbpilot, you are more likely to get a response if you post a new message on the Analytics U discussion forum. That way, more experts will see it.

SAS Employee
Posts: 30

Re: Importing data while using AWS Marketplace

Hi Tlou,

Have you heard about the new import tool in SAS University Edition?  You might it helpful as well.

Check out this article for more information about the import tool and to learn about more of the new features in SAS University Edition.

https://communities.sas.com/docs/DOC-19735

Marie

New Contributor
Posts: 3

Re: Importing data while using AWS Marketplace

M. Dexter,

thanks for your advise.

Import tool works great for my excel files.

For some reason, Import data option is not available for my txt files.

I will continue to investigate this issue.

Thanks.

☑ This topic is SOLVED.

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

Discussion stats
  • 6 replies
  • 705 views
  • 1 like
  • 5 in conversation