Yes, I have seen this approach a fair bit over time.  Personally I don't like the temporary files lying around (which also show up in version control), and there is a minor overhead of read/write to the file.  If you don't trust your code or want to run parts of it then just add a debug in (and maybe keep the dataset in work: data stored_code;      set loop;      attrib cmdline format=$2000.;      /* Create your commands and output */      cmdline=cats'ods tagsets.excelxp file="',,,,, ; output;      cmdline='proc print...;      /* Run only commands up to a certain point */      if 1 <= _n_ <= /* Enter a value here of command lines to process */           call execute(cmdlien);      end; run; ... View more

1) True, each user needs a licence, be that per core on a server, or local install.  It is not possible to run SAS.exe from CMD on a machine which does not have the software installed.   2)  Well, there is SCL/AF however its old and not used much anymore.  There are several options outside SAS to create these types of interfaces however. 3)  Well, in my experience the programmer is responsible for generating the output.  I know there are systems out there where you can put information in a web page, and that then sends a generate request to a server which returns the output.  SAS web studio for instance: SAS Web Report Studio I would suspect that these would need server licenses etc. though. ... View more

Hi, Yes, you just need to modify the code presented: proc sql;     /* Get a list of countries, we will loop over the code once for each of them */      create table LOOP as      select distinct COUNTRY from HAVE;      create table DATA2      /* Create an empty table to print to data2 */      (COL1 char(200)); quit; /* This loops over each country and prints the dataset with the corresponding country name to the tagset */ data _null_;      set LOOP;      call execute('ods tagsets.excelxp file="...\'||strip(country)||'.xlsx";     /* Create a file as per country */                           ods tagsets.excelxp options=(sheet_name="'||strip(country)||'");    /* Set the sheetname as country */                           proc print data=xxx where=(country="'||strip(country)||'"));  /* Print the xxx data only where country=current country */                            run;');      call execute('ods tagsets.excelxp options=(sheet_name="data2");                           proc print data=data2;   /* Print the empty dataset data2 to the spreadsheet to get second tab */                           run;                           ods tagsets.excelxp close;'); run; ... View more