topic Re: SAS syntax to import CSV file into SAS EG 9.4 using server name and port number in SAS Programming

SAS syntax to import CSV file into SAS EG 9.4 using server name and port number

buddha_d — Tue, 24 Dec 2024 19:55:56 GMT

Dear SAS colleagues,

I have to import "CSV" file and I have working code for "ACCESS" file. Here is the sample code for access database (just

proc import out = work.want
datatable= "GIVEN"
dbms = ACCESSCS replace;
database= "\\WELSFGO\KDRIVE$\Test_File.mdb"; 
server= 'WELSFGO.NETIZENS.BANK-DSb.COM';
port = 7845;
run;

I tried different ways to import similar kind of code like the one shown below.

proc import out=want
DATAFILE="\\WELSFGO\KDRIVE$\Test_File.csv"
dbms=csv replace; 

server= 'WELSFGO.NETIZENS.BANK-DSb.COM';
port = 7845;

run;

I get the following error.

ERROR: Import unsuccessful. See SAS Log for details.

I don't have any other details to know further. Could someone help me fix the syntax so that I could import the csv file?

Thanks in Advance!!!

Re: SAS syntax to import CSV file into SAS EG 9.4 using server name and port number

ChrisHemedinger — Tue, 24 Dec 2024 20:24:05 GMT

You should not need the server and port options for CSV. That's for using PC Files Server, which helps you to import Microsoft file types like Excel or Access. SAS can read CSV files directly. As long as your SAS session can get to the path where the CSV sits, it should work.

Re: SAS syntax to import CSV file into SAS EG 9.4 using server name and port number

buddha_d — Tue, 24 Dec 2024 21:06:38 GMT

ChrisHemedinger, I am unable to run the code as it is throwing the same error. Do you have any other suggestions.

Thanks

Re: SAS syntax to import CSV file into SAS EG 9.4 using server name and port number

Tom — Tue, 24 Dec 2024 23:35:21 GMT

Your first PROC IMPORT step is accessing the server named WELSFGO.NETIZENS.BANK-DSb.COM via the SAS/ACCESS to PC-FILES process that is running on that machine. The machine where SAS is running (not the machine you are using to run Enterprise Guide) is where the data is being imported into.

Is that machine with the CSV file on it also running some other server process, like an SFTP service or HTTP service? If so you could use one of those methods to copy the file over to the machine where SAS is running. You could then read the CSV with SAS code. You could even let PROC IMPORT guess how to read the file if for some reason you do not know what is in it.

If not then ask if the actual drive where the file you want lives is also mounted on the server where SAS is running. Then you could just point to it directly.

Or have the drive that has the data made visible on the machine where you are running Enterprise Guide. Then you could either use the EG tool for importing a CSV file to move it to the SAS server. Or use the file upload task of Enterprise Guide to copy it to the SAS server.

Re: SAS syntax to import CSV file into SAS EG 9.4 using server name and port number

Kurt_Bremser — Wed, 25 Dec 2024 01:43:37 GMT

Post the complete (all code and messages) log of the failing step by copy/pasting the text into a code box opened with this button:

Re: SAS syntax to import CSV file into SAS EG 9.4 using server name and port number

SASKiwi — Wed, 25 Dec 2024 21:43:52 GMT

Pulling data from a Windows server (WELSFGO.NETIZENS.BANK-DSb.COM) to your SAS Application server using EG is likely to be a permissions problem, not a syntax one. Your ACCESSCS program syntax looks OK. I suggest you engage with your SAS administrator as they have likely been involved in setting up this approach. Confirming your server name, port and folder share details is a good start. If this is a first time test then you could be blocked by server firewall rules. Only your IT folks can help with that as they need to make a rule change. By default servers usually block all communication ports, then add a rule for each port where traffic is allowed. Ask about a firewall rule for port 7845 on both servers.