Short note about macro functions.   If you are interested in quick creation of bunch of "macro functions" that use %sysfunc "wrapping" you could look at the %generateOneLiners() macro, it's component of the basePlus package. You can run it like: %GenerateOneLiners(prefix=my_ , listOfFunctions=DATETIME TODAY YEAR QTR MONTH WEEK DAY HOUR MINUTE SECOND ) and you can enjoy convenient macro functions like: %put %my_YEAR(%my_TODAY()); %put %my_MONTH(%my_TODAY()); There are some other useful functions in the basePlus too.   And if you are interested in FCMP functions mimicking data struuctures like FIFO queue, LIFO queue, etc. check out the DFA package (documentation)   All the best Bart ... View more

I would go even one step further asking both for SAS Studio and SAS EG.  ... View more

"If I used import wizard and succeed import the file then I think it means that the file is visible by sas?" No, it does NOT mean that the file is visible by SAS. It only means that (as I wrote in my first response) EG can see the local file and makes a copy of it to the server, so that SAS can import the copy. Bart ... View more

1) "What action should I do in order to be able to import it via code?"   Please forgive me self quoting: " If you want to import a file that file has to be visible to the server you running SAS on! So... copy the file on the server and you will be able to import it. "   2) "Is it possible to import csv file that is not located in sas server?"   Yes, if a) SAS server can see the file, or b) if the file is accessible by Filename URL statement of Proc Http so it can be downloaded to the server drive. filename f URL "Https://some.web.address.com/location/file.csv" lrecl=1 recfm=n; filename s "/location/on/my/server/file.csv" lrecl=1 recfm=n; data _null_; rc = fcopy("f","s"); rctxt=sysmsg(); if rc then put rctxt; run; proc import ...     Bart ... View more

First of all you are not importing Excel file, but comma separated text file, CSV!   Second thing, because you didn't provide any log/error message/etc. I can only guess... When you are doing it through  SAS EG (the wizard) you: 1) pick up the file on your local machine {Windows?}, 2) EG moves it to server (makes a copy) and then 3) SAS imports the file on the server. If you want to import a file that file has to be visible to the server you running SAS on! So... copy the file on the server and you will be able to import it.   Bart         ... View more

Thanks for this demo @ChrisHemedinger !! I'm really happy that with Workbench SAS gets back to: "if you want to have things clicked well - you have to write code for it" philosophy again! 😄 😄 😄 ... View more

Data shell; /* create shell datasets */ length sex $ 5; sex="M"; output; sex="F"; output; sex="Trans"; output; sex="Other"; output; Run; /* sort by sex */ proc sort data=shell; by sex; run; proc sort data=sashelp.class out=class_sorted; by sex; run; data combined; merge shell class_sorted; by sex; run; proc print data=combined; run; ... View more

So what is the issue ? Because the code clearly reads all the files, even the empty ones. ... View more

1) do not use X for the job. 2) if you have multiple files you want to copy to a single .sas file and all of then are in one directory you can do it like this: /* create some text files */ filename f "R:\test\"; data _null_; file f(a.sas); put "data _null_; run;"; file f(b.sas); put "proc print data=sashelp.class; run;"; file f(c.sas); put '%macro test(n); %do i = 1 to &n.; %put &=i.; %end; %mend;'; file f(d.sas); put '%test(42)'; put "data _null_; run;"; run; /* get them all into one file */ filename in_list "R:\test\*.sas"; filename out "R:\out\allInOne.sas"; data _null_; infile in_list; file out; input; put _infile_; run; Bart ... View more

Do you mean something like this: Code: data all4together; set ob1 ob2 ob3 ob4; run; Log: 1 data all4together; 2 set ob1 ob2 ob3 ob4; 3 run; NOTE: There were 10 observations read from the data set WORK.OB1. NOTE: There were 9 observations read from the data set WORK.OB2. NOTE: There were 0 observations read from the data set WORK.OB3. NOTE: There were 0 observations read from the data set WORK.OB4. NOTE: The data set WORK.ALL4TOGETHER has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds ?   Bart ... View more

How about start using the macroArray package:   Documentation is here.   Article describing the package is here from PharmaSUG (and here) and WUSS conferences.   Example: %loadPackage(macroArray) /* %helpPackage(macroArray,'%array()') */ resetline; /* create */ %array(mon[12] $ 4, function=put(intnx('month','1dec2021'd,_I_-1,"S"),yymmdd4.), macarray=Y) /* use */ %put %do_over(mon); %put %mon(1), %mon(2) ... %mon(12); /* delete */ %deleteMacArray(mon, macarray=Y) Log: 1 2 /* create */ 3 %array(mon[12] $ 4, function=put(intnx('month','1dec2021'd,_I_-1,"S"),yymmdd4.), macarray=Y) NOTE:[ARRAY] 12 macrovariables created 4 5 6 /* use */ 7 %put %do_over(mon); 2112 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 8 9 %put %mon(1), %mon(2) ... %mon(12); 2112, 2201 ... 2211 10 11 12 /* delete */ 13 %deleteMacArray(mon, macarray=Y)   Bart ... View more

@kdett  - " a slightly different error" - could you share?   "You shall pass"  and "You shall not pass" are also only slightly different 😉    Bart ... View more

Looks like it's exactly the one I proposed in August.  🙂     ... View more