Hi RW9, You are right. Its HTML with a .xls file ending that is used. The ultimate goal is to offer the Stored Process Web Application user a html link that says "export as pdf" or "export as excel" or "export as html" and then prompts for a destination to save on the desktop. Why? because its a user requirement to play around with the data, keep it, or print it. I have to live with it. Handling convolution  is not the aim. the "user" is not going to use my macro´s. it will be only myself to develop STP´s but right now the SAS Sever isnt running so I do my "pre-work" without the STP Server Below is what I got so far. I feel like I am reinventing the wheel. Stuff like this must have been done a million times before In the macro part I am missing an IF/ELSE that not only gives me the opportunity to apply different styles but also options that deal with excel-export problems like cutting of leading 0. options nodate pageno=1 linesize=80 pagesize=40 orientation=landscape; %include "R:\....sas_generate_output.sas" ; %LET RepTitel = myreport; %LET RepFileName = NRKP_Positive_Einzel_v01; %LET RepFileNameExcel=&RepFileName'.xls'; %LET RepFileNameHTML=&RepFileName'.html'; %LET RepFileNamePDF=&RepFileName'.pdf'; %LET RepKopfZeile = x; %LET RepFussZeile = y; %LET RepName = &SYSDATE ; %LET RepVersion = z; %LET RepDB = w; proc sql;    connect to oracle as nrkpdb (user=xxx password=yyyy path=ccc);      create table positive as      (        select *            from connection to nrkpdb                      (                 select mydata from xxxx              )      );    disconnect from nrkpdb; quit; %let dsid=%sysfunc(open(positivliste)); %let num=%sysfunc(attrn(&dsid,nlobs)); %let rc=%sysfunc(close(&dsid)); proc report data=positive; title &RepTitel; compute after ; text = "&sysuserid: &RepFileName %sysfunc(datetime(),datetime.) &num. Results" ; line @1 text $108.0; endcomp; run; ods _all_ close; /*Generate output files*/ %sas_generate_output(dataset=positivliste, file_name=&RepFileNamePDF, type=pdf); %sas_generate_output(dataset=positivliste, file_name=&RepFileNameHTML, type=html); %sas_generate_output(dataset=positivliste, file_name=&RepFileNameExcel, type=html); %macro sas_generate_output(dataset=, file_name=, type=); proc template; /*HTML Style*/ define style styles.mycssstylescreen;     import ".....sas_style_v01.css" screen; end;    /*PDF Style*/ define style styles.mycssstyleprinter;         parent=styles.mycssstyle;         import "....sas_style_v01.css" print; end; run; /*Text Format applied to all columns HEADTEXT= “<STYLE> TD {MSO-NUMBER-FORMAT:\@}</STYLE>”;*/ ods &type file="sas_output\&file_name" cssstyle="sas_style_v01.css"; proc print data=&dataset; run; ods &type close; %mend sas_generate_output; ... View more

got it %LET typenew=catx('. ',&type); but the export does not work as MS Excel: %macro print_report(dataset=, file_name=, type=); ods &type file="C:\temp\&file_name" style=meadow; proc print data=&dataset; ru; ods &type close; %mend print_report; %print_report(dataset=sashelp.class, file_name=class_20150401, type=XLS); ERROR 180-322: Statement is not valid or it is used out of proper order. ... View more

Hi Reeza! Thanks for that! Awesome. I tried it and it works almost I noticed that the file name does not have a dot between file name and file type. I tried it with catx but somehow that did not work. Do you have a suggestion how to get the .dot between file name and type? %macro x_output(dataset=, file_name=, type=); typenew=catx('. ',&type); ERROR 180-322: Statement is not valid or it is used out of proper order. ods &type file="R:\NR\Scripts\13_SAS\&file_name &typenew" cssstyle="R:\NR\Scripts\13_SAS\sas_marko\style_v01.css"; proc print data=&dataset; run; ods &type close; %mendx_output; Bye Phil ... View more

OK. I throw the program over board and start again. ... View more

Hi, thanks for the quick response. The error comes from here: If I comment that out, it all works fine (well, not csv file of course) %bvl_sas_generate_excel(positivliste, "aaalines.csv", N, ); so the error comes from that macro. I found the macro online and just copied and past it. looking hours around for a macro to generate excel output. %MACRO bvl_sas_generate_excel(LIBDSN,DOWNLOAD, VARNLABL, MOD);    FILENAME OUTFILE &DOWNLOAD LRECL=8000 RECFM=V ;    PROC CONTENTS DATA=&LIBDSN    OUT=_TEMP_(KEEP=NAME TYPE VARNUM LABEL FORMAT FORMATD FORMATL) NOPRINT;    RUN;    PROC SORT DATA=_TEMP_ OUT=_TEMP_; BY VARNUM; RUN;    DATA _NULL_; SET _TEMP_ END=EOF;     CALL SYMPUT('ZVR'||(LEFT(PUT(_N_,5.))),NAME);     CALL SYMPUT('TYP'||(LEFT(PUT(_N_,5.))),LEFT(PUT(TYPE,8.)));     IF LABEL = ' ' THEN LABEL = NAME;     CALL SYMPUT('LBL'||(LEFT(PUT(_N_,5.))),LEFT(LABEL));     CALL SYMPUT('FMT'||(LEFT(PUT(_N_,5.))),LEFT(FORMAT));     CALL SYMPUT('FMD'||(LEFT(PUT(_N_,5.))),PUT(FORMATD,BEST.));     CALL SYMPUT('FML'||(LEFT(PUT(_N_,5.))),PUT(FORMATL,BEST.));     IF EOF THEN CALL SYMPUT('TOTAL',LEFT(PUT(_N_,8.)));    RUN;   DATA _NULL_;    %DO ZI=1 %TO &TOTAL;      LENGTH  TMP&ZI $40 ;      TMP&ZI = "&&FMT&ZI" || "&&FML&ZI" || "." || "&&FMD&ZI";      if compress("&&FML&ZI") = "0" then do;        TMP&ZI = "&&FMT&ZI" || ".";      end;      TMP&ZI = COMPRESS(TMP&ZI);      IF "&&FMT&ZI" = " " THEN TMP&ZI = 'BEST.' ;      CALL SYMPUT("FMT&ZI", TMP&ZI);    %END;   RUN;    DATA _NULL_;     FILE OUTFILE  NOPRINT NOTITLES &MOD;     SET &LIBDSN;     FORMAT _NUMERIC_ BEST12.;      IF _N_ = 1 THEN PUT 'SEP=!';     %IF &VARNLABL EQ Y %THEN %DO;        IF _N_ = 1 THEN DO;         PUT        %DO YI =1 %TO &TOTAL;          %CMPRES("'&&ZVR&YI") +(1) '!'        %END;        +(-1)' '; /* REMOVE LAST HANGING COMMA DELIMITER */       END;        IF _N_ = 1 THEN DO;         PUT        %DO XI =1 %TO &TOTAL;          %CMPRES("'&&LBL&XI") +(1) '!'        %END;        +(-1)' '; /* REMOVE LAST HANGING COMMA DELIMITER */       END;     %END;     PUT      %DO WI=1 %TO &TOTAL;        %IF &&TYP&WI=1 %THEN %DO;  /* IF NUMERIC VARIABLE */            &&ZVR&WI  &&FMT&WI +(1) '!'        %END;        %ELSE %DO;   /* IF CHARACTER VARIABLE */           " "  &&ZVR&WI  +(-1) "!"        %END;      %END;      +(-1) ' '; /* REMOVE THE EXTRA COMMA AT THE END */    RUN;    %MEND bvl_sas_generate_excel; ... View more

Hi Jaap, thanks for the answer. The data does come from proc sql but I create a SAS data set for further interaction like client side sorting, filtering, styling. proc sql;    connect to oracle as nrkpdb (user=xxx password=yyyy path=Dxxx);      create table positivlist as      (        select *                  from connection to nrkpdb                       (                 SELECT* from dual              )      );    disconnect from nrkpdb; quit; ... View more

Hi Patrick, you are right, it surely is about general design principles like modularisation and re-usability. Now I dont know much about best practice modularisation and re-usability when it comes to SAS reports and I was hoping there would be something out there that explains this "general" priniciples for SAS. Thanks! ... View more

got it proc format; value $zeitraum      'bis 7.11.2013' = ' bis 7.11.2013'      'vom 8.11.2013' = ' vom 8.11.2013'      'vom 30.6.2014' = 'vom 30.6.2014'     ; RUN ; ... View more