Import CVS

[Maurizio10]

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

[Tom]

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

[hollandnumerics]

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!!