topic Re: Import CVS in SAS Software for Learning Community

Import CVS

Maurizio10 — Fri, 10 Jan 2025 14:04:13 GMT

Hi all

When I run these commands, proc import datafile="C:\Users\mauri\OneDrive\Desktop\Private\SAS\Data.csv" dbms=csv
out=Data_import;
run;

I got this message

0 proc import datafile="C:\Users\mauri\OneDrive\Desktop\Private\SAS\Data.csv" dbms=csv
81 out=Data_import;
82 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.
ERROR: Physical file does not exist,
/opt/sas/viya/config/var/tmp/compsrv/default/b2b20a24-3b1e-4681-b28f-c4088b156447/SAS_workB880000001F2_sas-compute-server-c50f1a06-6
b6e-4536-bfa0-371f474d9ce3-4384/C:\Users\mauri\OneDrive\Desktop\Private\SAS\Data.csv.
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.01 seconds
cpu time 0.00 seconds

Re: Import CVS

Tom — Fri, 10 Jan 2025 14:09:18 GMT

That error message is very clear. The filename you used is wrong.

There is no file named C:\Users\mauri\OneDrive\Desktop\Private\SAS\Data.csv in the current working directory of the Unix machine where SAS is running. Fully qualified filenames on Unix machines must start with the root node, the leading slash in the path mentioned in the error message.

First upload the file to the machine where SAS is running and then use the name as seen on that machine. Probably something like: /home/mauri/Data.csv

Re: Import CVS

hollandnumerics — Fri, 10 Jan 2025 14:13:10 GMT

Remote processing, like SAS On-Demand for Academics, requires input files on the same remote platform. Think of the security implications if they could access files on your own PC!!