SAS University Edition unable to import data.

Reply
New Contributor
Posts: 2

SAS University Edition unable to import data.

Hello all,

I recently downloaded and installed SAS University Edition for Virtual Box. However, I am having issues importing any data into it. I have tried a PROC IMPORT as well as the INFILE statement and the user interface simply shows a 'running' dialog box indefinitely.

The dataset is a really small csv file stored in a folder shortcut. Here is what I type before SAS hang:

1.

PROC IMPORT DATAFILE = "/folders/myshortcuts/Datasets/Transactions-1.csv" OUT = Transactions DBMS=csv REPLACE;

RUN;

2.

DATA TRANSACTIONS                                ;

     INFILE '/folders/myshortcuts/Datasets/Transactions-1.csv' delimiter = ',' MISSOVER DSD LRECL=32767 FIRSTOBS=2 ;

      INFORMAT ORDER_NO BEST32. ;

         INFORMAT ORDER_DATE DATE9. ;

         INFORMAT CUSTOMER $19. ;

         INFORMAT EMPLOYEE $22. ;

         INFORMAT TITLE $64. ;

         INFORMAT GENRE $9. ;

         INFORMAT QTY BEST32. ;

         INFORMAT TOTAL BEST12. ;

         FORMAT ORDER_NO BEST12. ;

        FORMAT ORDER_DATE DATE9. ;

         FORMAT CUSTOMER $19. ;

         FORMAT EMPLOYEE $22. ;

         FORMAT TITLE $64. ;

         FORMAT GENRE $9. ;

         FORMAT QTY BEST12. ;

         FORMAT TOTAL BEST12. ;

      INPUT

                  ORDER_NO

                  ORDER_DATE

                  CUSTOMER $

                  EMPLOYEE $

                  TITLE $

                  GENRE $

                  QTY

                  TOTAL

      ;

  RUN;

Anybody else had such an issue? Any help would be much appreciated.

Super User
Posts: 19,870

Re: SAS University Edition unable to import data.

Posted in reply to JasonMacwan

Are there any errors or does it simply hang/freeze?

Occasional Contributor
Posts: 8

Re: SAS University Edition unable to import data.

Assuming it is the same issue, for me it doesn't freeze it just continues the "Running" screen indefinitely. No errors are logged because it doesn't stop running.

Occasional Contributor
Posts: 8

Re: SAS University Edition unable to import data.

Posted in reply to JasonMacwan

I have pretty much the exact same issue.

Trusted Advisor
Posts: 3,215

Re: SAS University Edition unable to import data.

Posted in reply to JasonMacwan

There are a lot of people having the same kind of issues. See all those other threads like: https://communities.sas.com/thread/58754

I tried this one also copying code from the thread. Same kind of behavior in the failures with the screen timing. Needed to logout and restart the sas session (login) to recover.  Remember all possible errors in the Unix box  and case-sensitivity not using the T as capital can be a failure.

My log is saying (It is run and showing results but after recovering as I had the everlasting running popup also):

NOTE: The infile '/folders/myshortcuts/ikke/Transactions-1.csv' is:

       Filename=/folders/myshortcuts/ikke/Transactions-1.csv,

       Owner Name=root,Group Name=root,

       Access Permission=-rwxrwxrwx,

       Last Modified=21 juli 2014 03:19:28 uur,

       File Size (bytes)=61

.

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 4 replies
  • 1766 views
  • 0 likes
  • 4 in conversation