Another possibility is that EG (which runs on your local PC) is trying to "look" at the csv file to figure out how to import it. As you're running SAS on a server, your best bet might be to not let EG "help" you at all.
Here's a program that will pull in the first six records of your csv file, and dump them to the log:
data _null_;
infile "C:\ddd\cars.csv" lrecl=32767;
input;
putlog _infile_;
if _n_ = 6 then
stop;
run;
Substitute your directory and file, and see if it works. (Also, if you need troubleshooting later on, it gives you something to post to this site). Here's what my log looks like (I dumped sashelp.cars to a csv file):
NOTE: The infile "C:\ddd\cars.csv" is:
Filename=C:\ddd\cars.csv,
RECFM=V,LRECL=32767,File Size (bytes)=38595,
Last Modified=August 14, 2020 17:20:13,
Create Time=August 14, 2020 17:20:13
Make,Model,Type,Origin,DriveTrain,MSRP,Invoice,Engine Size (L),Cylinders,Horsepower,MPG (City),MPG (Highway),Weight (LBS),Wheelbase
(IN),Length (IN)
Acura, MDX,SUV,Asia,All,"$36,945","$33,337",3.5,6,265,17,23,4451,106,189
Acura, RSX Type S 2dr,Sedan,Asia,Front,"$23,820","$21,761",2,4,200,24,31,2778,101,172
Acura, TSX 4dr,Sedan,Asia,Front,"$26,990","$24,647",2.4,4,200,22,29,3230,105,183
Acura, TL 4dr,Sedan,Asia,Front,"$33,195","$30,299",3.2,6,270,20,28,3575,108,186
Acura, 3.5 RL 4dr,Sedan,Asia,Front,"$43,755","$39,014",3.5,6,225,18,24,3880,115,197
NOTE: 6 records were read from the infile "C:\ddd\cars.csv".
The minimum record length was 72.
The maximum record length was 148.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Assuming that works, here's another code snippet, that will simply run through your file and save the text of each record to a work dataset:
data work.check(compress=char);
length InRec $32767;
infile "C:\ddd\cars.csv" lrecl=32767;
input;
InRec = _infile_;
run;
I don't see anything weird in the description of your file or your system, but if there is this will hopefully bring it front and centre.
Neither of these programs use EG at all, so there shouldn't be any heavy communications.
Let us know what happens!
Tom
... View more