Hi all, Long time lurker first time poster. Apologies if formatting/explanation is patchy. I've recently changed companies and have come across an issue I haven't experienced before. I'm trying to automate some basic reporting and I'm having trouble importing a CSV file. I can do it through the wizard just fine, however the csv extract changes daily (date/time stamp) so I want to complete this using a proc import macro. The problem seems to be that our SAS server is on UNIX and my PC is windows. My code below. PROC IMPORT OUT= WORK.IMPW DATAFILE= "\\myDrive\DataShare\Brio\Job\myFile_1-20171214.csv..csv" DBMS=csv REPLACE; SHEET="Data"; GETNAMES=YES; RUN; And this is what I get from the log 15 DBMS=csv REPLACE; NOTE: The previous statement has been deleted. 16 SHEET="Data"; _____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 17 GETNAMES=YES; 18 RUN; ERROR: Physical file does not exist, /saslev1comp/software/config/Lev1/SASEG/\\myDrive\DataShare\Brio\Job\myFile_1-20171214.csv. It looks like I'm limited to only using proc import for files in our sas drive (saslec1comp) If I place the csv somewhere in that folder the proc import works fine. My IT departments solution was to just use the wizard, hoping someone else has come across this hurdle before. Thanks J_T1
... View more