Hello SAS Experts, I have applied  format=f12.1; to my proc report column but if there are no decimal places then no formatting happens. How can I enforce that even if there is no decimal place I can read 100,0 or 90,0 and not just 100 and 90?   @RW9,  I know it might be a strange thing to do to make up information on decimals which isnt there but this is an aesthetic requirement by the end user, I cant help it 🙂 ... View more

Hi SAS Experts,   I am creating a macro variable %LET RepQuarter = '4th (October-December)'; and insert it later on in my custom ods xml tagset.           define event EmitMetaMainMessage;             xdent;             put "</Metas>" CR;             put "<main>" CR;             put "<year>&RepYear" ;             put "</year>" CR;             put "<quarter>&RepQuarter" ;             put "</quarter>" CR;         end;   But I need it without the quotes'. How can I remove those?   Bye ... View more

Hi, I have the data set trialdata that is used to create a report like this: ods tagsets.excelxp_mod file='C:\temp\MYID_TRIALS.xml' style=styles.mycssstylescreen options(         embedded_titles='yes'         Embedded_Footnotes = 'yes'         Orientation = 'landscape'         FitToPage = 'yes'         Frozen_Headers = '7'         Autofit_Height ='yes'         Sheet_Name ='RESULTS TRIAL'         ); proc report data=trialdata split='*'; TITLE  JUSTIFY=L Test ; COLUMN TRIALID TRIALID_VAR CATEG CATEG_VAR SPECIES SPECIES_VAR MATRIX NEGATIVE          ('Masterheader'(                      ('' MN_POS N_POS M_POS OTH_POS TOTALC))                      ); DEFINE TRIALID / GROUP ORDER=DATA NOPRINT; DEFINE TRIALID_VAR / COMPUTED'TRIALID'; DEFINE SPECIES / GROUP ORDER=DATA NOPRINT; DEFINE SPECIES_VAR / COMPUTED'SPECIES'; DEFINE CATEG / GROUP ORDER=DATA NOPRINT; DEFINE CATEG_VAR / COMPUTED'CATEG'; DEFINE MATRIX / 'Mat'; DEFINE NEGATIVE / 'Neg'; DEFINE MN_POS / 'N_M'; DEFINE N_POS / 'N'; DEFINE M_POS / 'M'; DEFINE OTH_POS / 'Others'; DEFINE TOTALC / 'TOTALC'; BREAK AFTER TRIALID / summarize style=[backgroundcolor=#C8CCA8 fontsize=1 fontfamily=arial]; BREAK AFTER SPECIES  /  summarize style=[backgroundcolor=#F4F6E9 fontsize=1 fontfamily=arial]; BREAK AFTER CATEG / summarize style=[backgroundcolor=#E5EAC1 fontsize=1 fontfamily=arial]; COMPUTE TRIALID_VAR / CHARACTER LENGTH=55;     TRIALID_VAR = TRIALID; IF upcase(_break_) = 'TRIALID' THEN     TRIALID_VAR=catx(' ','TOTALC', TRIALID); ENDCOMP; COMPUTE CATEG_VAR / CHARACTER LENGTH=55;     CATEG_VAR = CATEG; IF upcase(_break_) = 'CATEG' THEN     CATEG_VAR=catx(' ','TOTALC', CATEG); ELSE IF upcase(_break_) = 'SPECIES' THEN DO TRIALID_VAR=''; CATEG_VAR=''; END; ENDCOMP; COMPUTE SPECIES_VAR / CHARACTER LENGTH=55;     SPECIES_VAR = SPECIES; IF upcase(_break_) = 'SPECIES' THEN     SPECIES_VAR=catx(' ','TOTALC', SPECIES); ELSE IF upcase(_break_) = 'CATEG' THEN TRIALID_VAR=''; ENDCOMP; run; ods tagsets.excelxp_mod; ods _all_ close; but I need this report 10 times for 10 different location. There is a location ID that I have not included in the report. Is there a neat way to maybe wrap a loop around the ods tagset definition or proc report to look through 10 static location ID's and produce one xml (excel) file for each? ... View more

Hi SAS Experts, I wrapped my style and template code in a macro and thought I can call the macro instead of having this styling code in my programs. First I have the proc sql to create a data set. proc sql; ... quit; I then call the macro %sas_report_style; I add some program/report specifics to for the tagset: ods tagsets.excelxp_mod file='C:\temp\NRKP_Soll_Haben.xml' style=styles.mycssstylescreen options(         embedded_titles='yes'         Embedded_Footnotes = 'yes'         Orientation = 'landscape'         FitToPage = 'yes'         Frozen_Headers = '7'         Autofit_Height ='yes'         Absolute_Column_Width='10,10,10,12,14,6,7,7,7,6,6,6,6,6'         ); proc report data=xxx_xxxx; run; ods _all_ close; The macro %sas_report_style looks like that: %macro sas_report_style; proc template; /*HTML Style*/ define style styles.bvl_css_stylescreen;     import "R:\style_v01.css" screen; end; run; /***********************************************************/ /* Compile tagset Tagsets.ExcelXP_mod, which makes changes */ /* to the ExcelXP tagset to preserve the grid lines.       */ /***********************************************************/ proc template;    define tagset tagsets.excelxp_mod;       parent=tagsets.excelxp;       define event sub_body;          break /if $sub_body;             set $sub_body "True";             set $body_class "_body";             put '<Style ss:ID="_body">' nl;             put ' <Font ss:FontName="Arial, Helvetica, sans-serif" ss:Size="10" ss:Color="#003399" />' NL;             put "<Interior />" Nl;             put '</Style>' nl;             set $contents_class "_contents";             put '<Style ss:ID="_contents">' nl;             put ' <Interior ss:Pattern="Solid" />' nl;             put ' <Protection ss:Protected="1" />' nl;             put '</Style>' nl;             set $pages_class "_pages";             put '<Style ss:ID="_pages">' nl;             put ' <Interior ss:Pattern="Solid" />' nl;             put ' <Protection ss:Protected="1" />' nl;             put '</Style>' nl;       end;    end; run; /* Remove table borders */ proc template;    define style styles.test;       parent=styles.minimal;       style table from table /             cellspacing=0             borderwidth=0;    end; run; %mend sas_report_style; I get the error ERROR 180-322: Statement is not valid or it is used out of proper order. and I wonder why...is what I am doing feasible? ... View more

Hi SAS Experts, As soon as I paste in the line makred with   /*---1---*/ I get the error below:                        _                        22 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',',               _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.  336                     ('MastBeef' ('EB' CATTLE_EB_N CATTLE_EB_P) ('SB'  CATTLE_SB_N 336      ! CATTLE_SB_P) ))                        _                        200 ERROR 200-322: The symbol is not recognized and will be ignored. If I take the line out, all works fine. Why is that? Is there a limit on nesting? proc report data=zus split='*'; COLUMNS MAIN_GR SUB_GR PARAMETER              ('Beef' (              ('Cattle' ('EB' CATTLE_EB_N CATTLE_EB_P) ('SB'  CATTLE_SB_N CATTLE_SB_P) ))              ('Cow' ('EB' CATTLE_EB_N CATTLE_EB_P) ('SB'  CATTLE_SB_N CATTLE_SB_P) ))             ('Cow' ('EB' CATTLE_EB_N CATTLE_EB_P) ('SB'  CATTLE_SB_N CATTLE_SB_P) ))    /*---1---*/ ; DEFINE MAIN_GR / ORDER'Main-*group'; DEFINE SUB_GR / ORDER'Sub-*group'; DEFINE CATTLE_EB_N / 'N'; DEFINE CATTLE_EB_P / 'P'; DEFINE CATTLE_SB_N / 'N'; DEFINE CATTLE_SB_P / 'P'; run; ... View more