topic Re: Error in Proc Import File in Client Machine in SAS Programming

Error in Proc Import File in Client Machine

habitusantos — Tue, 29 Oct 2013 13:18:04 GMT

I am intended to import a file that is not in the server's SAS but is in my client machine and the following code is giving error.

14 PROC IMPORT OUT=WORK.ORDERS

15 DATAFILE='L:\03_CRM\5.Projectos\5.Laboratorio Jumbo\1. TROCA (Ficheiros)\3. MERCADORIA (Auchan)\1. DEPARTAMENTO

15 ! (Detalhe)\cartoes_nao_integral.csv'

16 dbms=csv;

NOTE: The previous statement has been deleted.

17 SERVER='xxx.xx.x.xxx';

______

180

18 SERVICE=SASPCFILE;

_______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

19 RUN;

ERROR: Physical file does not exist, /home/pt00007/L:\03_CRM\5.Projectos\5.Laboratorio Jumbo\1. TROCA (Ficheiros)\3. MERCADORIA

(Auchan)\1. DEPARTAMENTO (Detalhe)\cartoes_nao_integral.csv.

What is the problem with is code

Thanks for the help

Re: Error in Proc Import File in Client Machine

Doc_Duke — Tue, 29 Oct 2013 15:18:37 GMT

A couple of things. In the documentation,

Base SAS(R) 9.4 Procedures Guide

SERVER and SERVICE do not appear to be valid statement for the PROC.

Also, the L: drive does not appear to be known on the server. If the data are on your client, you've first got to get it to the server before the processing can proceed.

Re: Error in Proc Import File in Client Machine

Jagadishkatam — Tue, 29 Oct 2013 16:22:47 GMT

Yes i agree with Duke,

An additional thing to be noted is to include the replace in the proc import to over write the data in the existing dataset.

Thanks,

Jagadish

Re: Error in Proc Import File in Client Machine

art297 — Tue, 29 Oct 2013 17:57:13 GMT

While 'server' isn't a valid option with proc import, it IS a valid option with using the excel engine in a libname statement. Take a look at: http://books.google.ca/books?id=QOI_xTgWwgsC&pg=PA35&lpg=PA35&dq=import+excel+libname+engine+format+sas&source=bl&ots=9pPB5QpKBB&sig=G35nn4hp99h9J8B7ittYhruMv3I&hl=en&sa=X&ei=4_VvUrnKNIeh8gG1jYC4Cg&ved=0CFIQ6AEwBTgU#v=onepage&q=import%20excel%20libname%20engine%20format%20sas&f=false