topic Re: importing csv file in sas studio in SAS Programming

importing csv file in sas studio

marissamac — Wed, 14 Sep 2016 21:08:32 GMT

I'm trying to import a .csv file into SAS Studio and keep receiving this error.

56 /* Generated Code (IMPORT) */

57 /* Source File: LOWBWT.csv */

58 /* Source Path: /folders/myfolders/sasuser.v94 */

59 /* Code generated on: 9/14/16, 3:05 PM */

61 %web_drop_table(WEBWORK.IMPORT);

64 FILENAME REFFILE '/folders/myfolders/sasuser.v94/LOWBWT.csv';

66 PROC IMPORT DATAFILE=REFFILE

67 DBMS=CSV

68 OUT=WEBWORK.IMPORT;

69 GETNAMES=YES;

70 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.

Unable to sample external file, no data in first 5 records.

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.06 seconds

cpu time 0.05 seconds

72 PROC CONTENTS DATA=WEBWORK.IMPORT; RUN;

ERROR: File WEBWORK.IMPORT.DATA does not exist.

paulkaefer — Wed, 14 Sep 2016 21:18:26 GMT

See in the log output: Unable to sample external file, no data in first 5 records.

What does your file look like? Are there a few blank rows? If so, try the DATAROW= option.

Reeza — Wed, 14 Sep 2016 21:19:50 GMT

Usually that means somethings wrong with your file.

What type of error do you get if you directly reference the file?

Also, the path is case sensitive, so if it's lowbwt that's different than LOWBWT.

 PROC IMPORT DATAFILE='/folders/myfolders/sasuser.v94/LOWBWT.csv'
 DBMS=CSV
 OUT=WEBWORK.IMPORT;
 GETNAMES=YES;
 RUN;

marissamac — Wed, 14 Sep 2016 21:35:26 GMT

THe file is Named LOWBWT, so that's probably nto the issue in naming. Aslo, with a direct reference I'm getting the same exact error.

Reeza — Wed, 14 Sep 2016 22:29:08 GMT

This error seems to occur when the file is in a format not expected by SAS, specifically, the TERMSTR (end of line) character is not what's expected.

Take a look at the TERMSTR options that you can add to your filename/file statement to import the file correctly:

options are (CRLF/LF/CR). You can examine your file in a text editor to see which end of line character is being used.

marissamac — Wed, 14 Sep 2016 22:36:15 GMT

There aren't any blank rows.

marissamac — Thu, 15 Sep 2016 01:25:50 GMT

I'm using a mac, so I had to add termstr=cr. Thank you for your help!