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

Not able to import "Csv" data set from my desktop into SAS University

Reply
New User
Posts: 1

Not able to import "Csv" data set from my desktop into SAS University

Hi,

I'm trying to import a csv file into SAS U, however every time I try and run the code, I get following error. Pl note: I have already set "myfolder" as my shared folder in the virtual machine. Can someone help?

Code:

libname MYDATA '/folders/myfolder/Ndata';

run;

proc import datafile="/folders/myfolder/Ndata/APR2014.csv"

     out=MYDATA.APR2014

     dbms=csv

     replace;

run;

Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 libname MYDATA '/folders/myfolder/Ndata';

NOTE: Libref MYDATA refers to the same physical library as OK.

WARNING: Library MYDATA does not exist.

NOTE: Libref MYDATA was successfully assigned as follows:

  Engine: V9

  Physical Name: /folders/myfolder/Ndata

44 run;

45 

46 proc import datafile="/folders/myfolder/Ndata/APR2014.csv"

47 out=MYDATA.APR2014

48 dbms=csv

49 replace;

50 run;

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, /folders/myfolder/Ndata/APR2014.csv.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

  real time 0.18 seconds

  cpu time 0.19 seconds

  

51 ;

52 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

62 ;

Regardsimport

Super User
Posts: 19,861

Re: Not able to import "Csv" data set from my desktop into SAS University

It's supposed to be myfolderS - note the S - not myfolder.

You'll need to make sure it's correct both in your code and in when you set up your shared folder.

Super User
Posts: 7,854

Re: Not able to import "Csv" data set from my desktop into SAS University

This:

WARNING: Library MYDATA does not exist.

is the first sign that you spelled something wrong.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 591 views
  • 0 likes
  • 3 in conversation