This is the generated DEFINE for the alias XMSRP.   Don't know if this helps or not.   DEFINE xmsrp / SUM FORMAT= DOLLAR8. WIDTH=8 SPACING=2 RIGHT "MSRP" ;     data cars; set sashelp.cars; run; proc report data = cars; col ('Report submitted by telecom pvt ltd' make type origin msrp=xmsrp newsale msrp,(min max mean)); define make/ group; define type/ group; define origin/ group; define newsale/ computed format=dollar7.; compute newsale; newsale = xmsrp + 100; endcomp; run;   PROC REPORT DATA=WORK.CARS LS=132 PS=60 SPLIT="/" CENTER ; COLUMN ( ("Report submitted by telecom pvt ltd" Make Type Origin MSRP=xmsrp newsale MSRP,( min max mean ) ) ); DEFINE Make / GROUP FORMAT= $13. WIDTH=13 SPACING=2 LEFT "Make" ; DEFINE Type / GROUP FORMAT= $8. WIDTH=8 SPACING=2 LEFT "Type" ; DEFINE Origin / GROUP FORMAT= $6. WIDTH=6 SPACING=2 LEFT "Origin" ; DEFINE xmsrp / SUM FORMAT= DOLLAR8. WIDTH=8 SPACING=2 RIGHT "MSRP" ; DEFINE newsale / COMPUTED FORMAT= DOLLAR7. WIDTH=7 SPACING=2 RIGHT "newsale" ; DEFINE MSRP / SUM FORMAT= DOLLAR8. WIDTH=8 SPACING=2 RIGHT "MSRP" ; DEFINE min / FORMAT= DOLLAR8. WIDTH=9 SPACING=2 RIGHT "min" ; DEFINE max / FORMAT= DOLLAR8. WIDTH=9 SPACING=2 RIGHT "max" ; DEFINE mean / FORMAT= DOLLAR8. WIDTH=9 SPACING=2 RIGHT "mean" ; COMPUTE newsale; newsale = xmsrp +100; ENDCOMP; ... View more

Thanks @DanH_sas I will try this.  I found another way using X=AGE2 BLOCK=AGE2 block x=age2 block=age2 / FILLATTRS=(color='GRAY') novalues transparency=.8;   ... View more

Perhaps you are confusing the WEIGHT statement with the FREQ statement.   The FREQ statement identifies a variable that contains the frequency of occurrence of each observation. ... View more

The update trick saves you having to know the variables.  Typical LOCF.   data have; retain dummy 1; input GHIN $ Name $ Date:mmddyy. Tees :$16. F9 B9 Tot CR CS; format date mmddyy10.; cards; 001362 Smith 06/10/2024 Green 36 38 74 68.1 119 . . 06/14/2024 Green 38 41 79 . . . . 06/22/2024 Green 41 40 81 . . 001362 Smith 06/11/2024 Green_White 41 38 79 70.2 116 . . 06/20/2024 Green_White 38 38 65 . . ;;;; run; proc print; run; data want; update have(keep=dummy obs=0) have; by dummy; output; *:-); run; proc print; run; ... View more

If you want to convert date strings to SAS Date you need to read the data with the proper INFORMAT.   49 data _null_; 50 file_dt = '20240627'; 51 x = input(file_dt,yymmdd8.); 52 put x= x=date9.; 53 run; x=23554 x=27JUN2024 ... View more

@djbateman wrote:   Please let me know how I can escalate this to be fixed.  We are running into issues where xls files are too large to email, and we don't want to have to manually save them as xlsx files. https://communities.sas.com/t5/SAS-Programming/Tagsets-ExcelXP-to-XLSX/m-p/91177#M19279    If you can't find the solution you are looking for with ODS EXCEL you could use EXCELXP and use the VBSCRIPT in the link to convert the XLS to XLXS.  Assuming you are using SAS on windows.     ... View more

Many ways but transposing TWO has the advantage of creating as many VALUE variables as needed, you don't have to count them.   data one; infile cards expandtabs; input id name $; cards; 1 peter 2 john 3 muse 4 peena 5 tina ;;;; run; data two; infile cards expandtabs; input id value $ ; cards; 1 cbz1 2 cbz2 2 cbz3 2 cbz4 3 cbz5 3 cbz6 3 cbz7 4 cbz8 4 cbz9 4 cbz10 4 cbz11 5 cbz12 ;;;; run; proc transpose data=two out=wide(drop=_:) prefix=Value; by id; var value; run; data want; merge one wide; by id; run; proc print; run; ... View more

I change my titles macro to put the title and footnote statements in a temporary file that I can %include as needed.  Now I can use TITLE; FOOTNOTE; *do the EXCEL bits.; %inc TITLES; No warnings.   @Tom Thanks for your comments and interest in this topic. ... View more

Several variables suggest an array might be useful.   data Have; input id Y23Jan Y23Feb Y23Mar Y24Jan Y24Feb Y24Mar; Array _23 Y23:; array _24 Y24:; array _df Dif1-Dif3; do over _23; _df = _24-_23; end; datalines; 1 0.54 0.54 0.52 0.62 0.61 0.60 2 0.48 0.45 0.48 0.71 0.68 0.67 3 0.59 0.61 0.59 0.57 0.54 0.58 4 0.61 0.62 0.59 0.62 0.61 0.54 ;;;; run; proc print; run; ... View more

Can you show example what you want?  Maybe make it by hand and show a picture.  Most folks don't like to open XLSX from external source. ... View more

Maybe something like this with signature at the bottom of the page.   proc report data=sashelp.class; columns age name sex height weight; define age / order; break after age / page; compute after age / style(lines)=[just=r]; line ' '; line 'Signature: ________________'; endcomp; run;     ... View more

Sorry  @Tom I should have included example.  This shows the problem and message from ODS EXCEL.  I am not embedding titles or footnotes.  And I don't need the worksheet headers or footers.     49 title1 'First header line is very long and too long to be a varible name' 50 'First header line is very long and too long to be a varible name' 51 'First header line is very long and too long to be a varible name' 52 'First header line is very long and too long to be a varible name' 53 'First header line is very long and too long to be a varible name'; 54 filename xlsx temp; 55 ods excel file="%sysfunc(pathname(xlsx))" options (embedded_titles='NO'); 56 proc print data=sashelp.class noobs; 57 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds WARNING: Worksheet header is too long. Truncation will occur. 58 ods excel close; ... View more