03-03-2016 01:20 PM
03-03-2016 03:48 PM
The NOTE: you included in the body of your post is not related to the ERROR: message in the title of your post. The sasuser libref in University Edition is read only and can't be used for tempoary storage. The work libref will work fine.
If you could include additional information from your SAS log we coud be more precises in helping.
I have gotten the 'ERROR: Import unsuccessful...' error when importing a csv file. I have previously exported a csv file from University Edition and stored it in a subdirectory under the myfiles. I then right clicked on the file in the left panel and selected the import option to generate a program. I ran the program and got this log:
If something like this is what you got, the problem is the TERMSTR=CR option on the filename. Go to the 'settings' tab and change the 'End of line delimiter' to 'Line feed' and re-run the program. My csv file was generated in University Edition so it has the Linux end of lines or LF's. Windows uses CR or LFCR. Since there are no CR's in the Linux csv file SAS is importing it as a single record and there aren't 5 records to process in the import.