The SAS custom format would be: Proc format library=work; picture ddmon low - high ='%d-%3B' (datatype=date); ; run; data example; x = '29Mar2020'd; y = '01Jan2020'd; put x= ddmon. +1 y= ddmon.; run; Custom date formats like this may not work as intended when used with graphs though. The quotes in the Picture statement must be single quotes and the case of the letters is important. I have no idea if Excel will honor this either.   ... View more

Look into the idlabel statement in proc transpose: proc transpose data=want out=have (drop=_name_) ; by name; id gender; idlabel gender_label; run; (Untested, no SAS at the moment) ... View more

@angeliquec wrote: Hi, X Commands are disabled in our SAS server, and won't be enabled. With that, I'd like to know how can I execute a vb script I made for the consolidation of these multiple excel sheets. I know it's possible to fix the sequence using ODS tagsets, but since there is a lot of ongoing program development and revision, I prefer to perform the consolidation at the end of my SAS program.    VB Script sample as below:   Function Cpypaste (xlfile) Dim xlfile_nm xlfile_nm = xlfile 'MsgBox xlfile_nm Set CopyFromWbk = objExcel.Workbooks.Open(FolderPath & xlfile_nm & ".xlsx") 'Worksheet.Name = xlfile_nm Set ShToCopy = CopyFromWbk.Sheets(1) ShToCopy.Copy CopyToWbk.Sheets(CopyToWbk.Sheets.Count) CopyFromWbk.Close End Function If you are generating that output to multiple sheets from SAS then likely you could just change how the output is generated from SAS. If using ODS  tagsets.excelxp or ods excel then the SHEET_INTERVAL option controls how sheets are generated and likely use of NONE would send all of the output to a single sheet so the post processing is not needed. ... View more

@angeliquec wrote: Hi, I'd like to stack two of my tables in one sheet. Let's say I made a Proc report output for each table, but I'm unable to combine these two tables into 1 sheet, same as attached. Thank you!   data table1;  input text :$20. column1 column2;  cards; table_1_counts 6 4  ; run; data table2;  input text :$20. column1 column2;  cards; table_2_counts 6 4  ; run;   proc report data=table1 out=t1 nowd; column text column1 column2; run; proc report data=table2 out=t2 nowd; column text column1 column2; run;   One sheet of what?   You don't specify an output destination so we have to assume that the output is HTML which really does not have a concept of "sheet" or "page".   Almost certainly your ODS destination would have one or more options that would attempt to place the output on a single "sheet" if specified properly.   If using ODS Excel or tagsets.excelxp the likely specifying options(sheet_interval='NONE') would have all of the output on a single sheet.   ODS RTF option STARTPAGE=NO would attempt to place all following output on the same page put may not if the tables plus spaces between are too many rows. ... View more