topic Re: CSV IMPORT - ERROR: Import unsuccessful. See SAS Log for details. in SAS Enterprise Guide

CSV IMPORT - ERROR: Import unsuccessful. See SAS Log for details.

bn820 — Mon, 22 Jan 2024 15:03:50 GMT

I am running the below code. keep getting the following error:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
WARNING: Physical file does not exist, \\NASLOCSHARE220\AGENCYSHARE\Maternal Child Health
Unit\Penelope\DataEvaluation\UU-HDS-ACS-LOH data\DHS Test.csv.
ERROR: Import unsuccessful. See SAS Log for details.

FILENAME DHS "\\NASLOCSHARE220\AGENCYSHARE\Maternal Child Health Unit\Penelope\DataEvaluation\UU-HDS-ACS-LOH data\DHS Test.csv";
FILENAME ACS "\\NASLOCSHARE220\AGENCYSHARE\Maternal Child Health Unit\Penelope\DataEvaluation\UU-HDS-ACS-LOH data\LOH_ACS Test.csv";
FILENAME UU "\\NASLOCSHARE220\AGENCYSHARE\Maternal Child Health Unit\Penelope\DataEvaluation\UU-HDS-ACS-LOH data\UU Test.csv";

/*Loading csv_sheets*/
PROC IMPORT DATAFILE=DHS
out=DHS_Data
dbms=csv
replace;

PROC IMPORT DATAFILE=UU
out=UU_Data
dbms=csv
replace;

PROC IMPORT DATAFILE=ACS
out=ACS_Data
dbms=csv
replace;
RUN;

Re: CSV IMPORT - ERROR: Import unsuccessful. See SAS Log for details.

ballardw — Mon, 22 Jan 2024 15:47:59 GMT

Spaces and special characters such as - can be problems in paths. It is not impossible that the character you think you see as a dash is some other character so you have a problem getting the proper one into code. Depending on your operating system mixed case of files may also be a problem. Sometimes you may type one space where the file name or path actually has 2 or even worse a different non-printable character.

You may want to copy the entire path from a file manager your operating system uses to make sure you have the characters it sees.

If the Penelope in the path relates to PAT then you really do not want to rely on Proc Import to read their data files. Write a data step to read the CSV and be prepared to change it often as, at least my experience with PAT, is that they won't define variable content and will change it randomly, including column order.

Re: CSV IMPORT - ERROR: Import unsuccessful. See SAS Log for details.

bn820 — Mon, 22 Jan 2024 16:07:54 GMT

Thanks. it was the path. I corrected it