My "period" variable is a character variable which has the format $32. It can take on the following values:   2004-2007 [...] 2013-2016 2015-2016,2018 2018, 2020 2018,2020,2021 2020,2021,2022   I use the compute block in PROC REPORT in order to use these periods as headlines for the values in that time period: ods excel file="[path]"; ods excel options(sheet_interval='bygroup' sheet_name="#byval(bladnamn)"); PROC REPORT data=export; by bladnamn; column period variabelnamn bladnamn variabel_cat_varde (kon,(andel CI_lower CI_upper lillan)); /* define variabelnamn / order order=internal;*/ define period / group order=internal descending format=$32. noprint; define variabelnamn / group order=data noprint; define order / order order=internal noprint; define variabel / order order=internal noprint; define bladnamn / group order=data noprint; define variabel_cat_varde / order=data group; /*define alder_grupp / order=data group;*/ define andel / mean; define CI_lower / mean; define CI_upper / mean; define lillan / mean; DEFINE kon / ACROSS ORDER=INTERNAL; compute before period /style={just=left};; period_char= put(period, $32.); line period_char $char200.; endcomp; compute before variabelnamn /style={just=left};; line variabelnamn $char200.; endcomp; run; ods excel close; The "period" values separated by commas are however converted to scientific notation in the COMPUTE block, despite my best efforts:     This is however just an issue with the comma-separated values.  More specifically, this only seems to happen with the entries with three comma-separated values.   Can I keep this from happening and in that case how? ... View more

I need to create a Table-of-contents-sheet with hyperlinks to the rest of my excel sheets. That part is doable I think, using this as a template:   https://www.lexjansen.com/sesug/2022/SESUG2022_Paper_232_Final_PDF.pdf     I can also see how we might generate the urls and the names for the links dynamically (we just perform a query with PROC SQL and select the distinct sheet names for the data set we're working with).   What I can't wrap my head around is how I'm supposed to generate a TOC-sheet when the rest of my sheets are generated automatically (I'm talking about just the actual sheet now, not the text or the hyperlinks within it):   ods excel file="[path]"); PROC REPORT data=export; by bladnamn; column Redovisningsgrupp bladnamn variabel_cat_varde alder_grupp (kon,(andel CI_lower CI_upper lillan)); /* define variabelnamn / order order=internal;*/ define Redovisningsgrupp / group order=data noprint; define order / order order=internal noprint; define variabel / order order=internal noprint; define bladnamn / group order=data noprint; define variabel_cat_varde / order=data group; define alder_grupp / order=data group; define andel / mean; define CI_lower / mean; define CI_upper / mean; define lillan / mean; DEFINE kon / ACROSS ORDER=INTERNAL;  compute before Redovisningsgrupp /style={just=left};; line Redovisningsgrupp $char200.; endcomp; run; ods excel close; How do I do that?   I know I can set options(Contents="yes") in the ods statement, but that won't really let me customize the text and in addition, adds unappealing subheadings to each line in the table of contents.    ... View more

  I use the following code: ods excel file="[path].xlsx" options(sheet_interval='bygroup' sheet_name="#byval(bladnamn)"); PROC REPORT data=export; by bladnamn; column bladnamn kon, (variabel_cat_varde alder_grupp andel CI_lower CI_upper lillan); /* define variabelnamn / order order=internal;*/ /*define order / order order=internal;*/ /*define variabel / order order=internal;*/ define bladnamn / noprint; define variabel_cat_varde / display; define alder_grupp / display; define andel / analysis; define CI_lower / analysis; define CI_upper / analysis; define lillan / analysis; DEFINE kon / ACROSS ORDER=INTERNAL; run; ods excel close; and get the following output: That is to say, values for the different values of my gender variable (kon) seem to appear on different rows. Naturally I don't want this to happen. Values belonging to the same group should appear on the same row, regardless of gender.   How do I make this happen?     ... View more