topic Re: Proc Import Not Working for CSV in SAS Programming

Proc Import Not Working for CSV

jjb123 — Thu, 07 Feb 2019 20:13:43 GMT

Hi all. The following code is not working for me.

It gives me the following error: Import unsuccessful. See SAS Log for details.

Obviously, the SAS Log provided zero guidance, so please let me know if you can help.

Note: I've already checked the files in the folder and verified they are there. The data starts on line two, with column names on line 1.

filename file1 "C:\Users\person\Desktop\SAS\List_****_**.csv";
PROC IMPORT OUT= perm.list DATAFILE= file1
            DBMS=csv REPLACE;
     GETNAMES=YES;
RUN;

Re: Proc Import Not Working for CSV

Kurt_Bremser — Thu, 07 Feb 2019 20:30:45 GMT

As SAS already told you, the answer is in the log.

Please post it (use the {i} button), and we will help you understand it.

Re: Proc Import Not Working for CSV

jjb123 — Thu, 07 Feb 2019 20:32:36 GMT

13434
13435  PROC IMPORT OUT= list DATAFILE= "C:\Users\person\Desktop\SAS\list****_**.csv"
13436              DBMS=csv REPLACE;
13437       GETNAMES=YES;
13438  RUN;

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.02 seconds
      cpu time            0.04 seconds

This is literally all it says

Re: Proc Import Not Working for CSV

ballardw — Thu, 07 Feb 2019 20:34:15 GMT

You only need one * if you are doing wild cards: List_*.csv would get all of the List_ files in that location.

Are any of the files in use by another program such as Excel?

Did you try reading just one?

If you are working in a server environment the program would likely be executing in terms of the server when paths are considered and is very likely that your desktop folder is not accessible by the server and could possibly be blocked from accessing C:\users on the server.

If you are using SAS University edition the file is 1) in the wrong location as it has to be somewhere the virtual machine running SAS can see it and 2) the path syntax is incorrect as the path would start with /folders/myfolders/ and uses UNIX syntax.

Re: Proc Import Not Working for CSV

jjb123 — Thu, 07 Feb 2019 20:36:48 GMT

1) the one * still gave the same result

2) none of the files are in use

3) yes, reading just one also does not work

4) the path is correct, as evidenced by SAS correctly reading my xlsx file with a similar path

Re: Proc Import Not Working for CSV

jjb123 — Thu, 07 Feb 2019 20:48:56 GMT

I just restarted my SAS application and it worked fine.... Any reason why this happened? Or ways to prevent it in the future?

Re: Proc Import Not Working for CSV

Reeza — Fri, 08 Feb 2019 04:01:44 GMT

The multiple asterisks may have messed things up if you missed a quote or comma somewhere.