SAS Support Communities

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

i don't know why but it doesn't work .. ... View more

My problem wasn't really obvious. Actually, i wanted to create a macro variable that contains all the week numbers since the beginning of the year. In order to import files which are sorted by the week number...   proc import out = work.ObjCollab_01 (drop=username Actifs) datafile = "\\....\ObjHebd_20181.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_02 (drop=username Actifs) datafile = "\\\\....\ObjHebd_20182.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_03 (drop=username Actifs) datafile = "\\....\ObjHebd_20183.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_04 (drop=username Actifs) datafile = "\\....\ObjHebd_20184.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_05 (drop=username Actifs) datafile = "\\....\ObjHebd_20185.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_06 (drop=username Actifs) datafile = "\\....\ObjHebd_20186.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_07 (drop=username Actifs) datafile = "\\....\ObjHebd_20187.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_08 (drop=username Actifs) datafile = "\\....\ObjHebd_20188.xlsx" dbms = excel replace; getnames = yes; run; proc import out = work.ObjCollab_09 (drop=username Actifs) datafile = "\\....\ObjHebd_20189.xlsx" dbms = excel replace; getnames = yes; run; Etc. etc. etc. So instead of having 52 lines of proc import for each file every week, i want to create a macro variable that would replace the week number in one proc import...     I ... View more