Thank you SO much for your help! Your program does the trick very neatly! 🙂  ... View more

Thanks for the answer! It was beginning to dawn on me, that I was using the macros in a completely wrong way 🙂   Do you have some code, or a reference to get me started regarding creating the long format with a do loop?    Best regards, Jacob  ... View more

Thank you so much, both of you! I just changed the code, adding the %global statement, and know it works perfectly. The now functioning code is: %MACRO sks(START,STOP); %DO ite = &START %TO &STOP; %global diag&ite; proc sql noprint; select diagkode into :diag&ite separated by ',' from sks_a(where=(diag_23=&ite)); quit; %END; %mend sks; %sks(1,23); %put &diag2; %put &diag23; ... View more

I tried running it in Base SAS (9.4) and that solved the issue with the Error message. Then my colleague pointed out that I had not specified the sheet in the templatesheet macro variabel (doh!), and now it works like a charm. Thank you so much for your patience as well as a great macro that I plan on using a lot! Best regards, Jacob Hornnes ... View more

Dear Arthur, I had created the file beforehand, no problem, and previous to that I tried with an other location. SAS is installed on the computer itself so it cannot be a server issue. I created a template and tried again with the following code as you suggested and I got the same error message.     %exportxl(data=a, outfile=S:\1 Alle\JHH\Diverse\ny_mappe.xlsx, type=N, range=C5,template=C:\Users\cj1g\AppData\Roaming\Microsoft\Skabeloner\template.xltx, templatesheet=template); If you have any idea what could be wrong I will greatly appreciate any help, in any case thanks so much for your help already! Bedste regards, Jacob ... View more

Dear Arthur, you sir, are nothing short of a hero! When I run the program, however, I get the following error: ERROR: Undetermined I/O failure. And then the program crashes and the data is not added to the spreadsheet. I have tried to figure out what is wrong, but so far without any succes. Is it a problem that you are familiar with in regards to the macro?  I have inserted the log as well as my macro call below. Bedste regards, and a huge thank you! Jacob Hornnes      %exportxl(data=a, outfile=C:\tjek.xlsx, type=M, range=C15); NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       NOTE: There were 1 observations read from the data set WORK.A. NOTE: The data set WORK.T_E_M_P has 1 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.00 seconds       NOTE: There were 1 observations read from the data set WORK.T_E_M_P. NOTE: The data set WORK.T_E_M_P has 1 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds       NOTE: PROCEDURE SQL used (Total process time):       real time           0.00 seconds       cpu time            0.01 seconds       NOTE: The file CODE2INC is:       Filename=C:\Users\cj1g\AppData\Local\Temp\SEG3760\SAS Temporary Files\_TD2012_CNU1010ZZ6_\#LN00057,       RECFM=V,LRECL=32767,File Size (bytes)=0,       Last Modified=26. november 2014 14:26:26,       Create Time=26. november 2014 14:26:26 NOTE: 6 records were written to the file CODE2INC.       The minimum record length was 15.       The maximum record length was 56. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       3                                                          The SAS System                         10:02 Wednesday, November 26, 2014 ERROR: Undetermined I/O failure. NOTE: There were 1 observations read from the data set WORK.A. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.01 seconds ... View more