trying to import a csv file into pc sas.
Same code works with other people here but does not for me:
proc import datafile="\\xxx\yyy\zzz\aaa\bbb\x\y\z\temp.csv" dbms=dlm out=temp replace;
delimiter=","; getnames=yes; guessingrows=3500;
NOTE: The infile '\\xxx\yyy\zzz\aaa\bbb\x\y\z\temp.csv is:
RECFM=V,LRECL=32767,File Size (bytes)=38270,
NOTE: 0 records were read from the infile '\\xxx\yyy\zzz\aaa\bbb\x\y\z\temp.csv'
NOTE: The data set WORK.TEMP has 0 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
also tried :
proc import datafile="\\xxx\yyy\zzz\aaa\bbb\x\y\z\temp.csv" dbms=csv out=temp replace;
exactly same error. I can import excel files .No problems....
Any hints please?
I can import the same file from EG SAS(UNIX) but not from PC SAS. We all use Windows SAS and a few of my co-workers i spoke with can easily open and import this file from pc sas. I can view it, i have access to the folder where this file is placed and yet cannot import it (0 records) . I even created temp csv files on my desktop and same problem,all seem good but 0 records imported.
atttached are a few records of that file
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.