I'm not sure if what i wrote was right! this is my program: filename tmp pipe 'dir "C:\Users\vfselma\Desktop\DDE SIEGE\CDG\Pilotage commercial Perso\SAS\TEST/*.xlsx" /b';
data _null_;
infile tmp dlm="¬";
input;
call execute(cats('proc import file="C:\Users\vfselma\Desktop\DDE SIEGE\CDG\Pilotage commercial Perso\SAS\TEST" dbms=excel out=swork.objindiv_",put(_n_,best.),"; run;'));
run; and this what was written in the log NOTE: The infile TMP is:
Périphérique d'accès au pipe non nommé,
PROCESS=dir "C:\Users\vfselma\Desktop\DDE SIEGE\CDG\Pilotage commercial
Perso\SAS\TEST/*.xlsx" /b,
RECFM=V,LRECL=256
Sortie Stderr :
Fichier introuvable
NOTE: 0 records were read from the infile TMP.
NOTE: L'étape DATA used (Total process time):
real time 0.20 secondes
cpu time 0.03 secondes
... View more
