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.
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
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.
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
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+...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.