I am generating a excel summary table by using PROC Tabulate. SAS creates an empty column(highlighted in red) when a Statistics Variable is placed before a CLASS Variable. Could you please advise how to solve this issue. Thanks in advance.   ODS NORESULTS; ODS LISTING CLOSE; ODS EXCEL FILE="C:\Temp\Cars &sysdate9..XLSX" OPTIONS ( SHEET_INTERVAL="PROC" SUPPRESS_BYLINES="YES" SHEET_NAME="Summary" EMBEDDED_TITLES="YES" EMBED_TITLES_ONCE="ON" EMBEDDED_FOOTNOTES='ON' EMBED_FOOTNOTES_ONCE="ON" FROZEN_HEADERS="3" FROZEN_ROWHEADERS="0" ); TITLE1 J=L "Cars Report"; PROC TABULATE DATA = sashelp.CarS MISSING; CLASS MAKE MODEL TYPE ORIGIN ; CLASSLEV TYPE /STYLE=[FOREGROUND=BLACK BACKGROUND=LIGHT_GRAY VJUST=B FONT_WEIGHT=BOLD]; CLASSLEV ORIGIN /STYLE=[CELLWIDTH=350 FONT_WEIGHT=BOLD]; KEYWORD ALL / S=[FOREGROUND=BLACK BACKGROUND=LIGHT_GRAY VJUST=B FONT_WEIGHT=BOLD] ; KEYLABEL N=' '; VAR MSRP INVOICE; TABLE ( MSRP ='MSRP'*F=10.0*SUM='' INVOICE='INVOICE'*F=10.0*SUM='' INVOICE='PERCENTAGE OF INVOICE/MSRP'*PCTSUM<MSRP>='' ) *(TYPE = ' ' * ORIGIN = ' ' ALL='TOTAL') , ALL ='TOTAL '*[STYLE=[FOREGROUND=BLACK BACKGROUND=WHITE FONT_WEIGHT=BOLD ]] / BOX=[LABEL='TYPE / ORIGIN' STYLE=[FONT_WEIGHT=BOLD]] MISSTEXT='0'; FOOTNOTE4 J=L "Updated date:&sysdate9"; RUN; ods excel close; ods listing;     ... View more

Good evening.   I am trying to pull a rather long variable apart to create two individual variables.  I am trying to create COUNTY and MUNCIPALITY variables.  The variable in my dataset is called MUNICIPALITY NAME (length = 58) and is present in my screenshot example below.  It contains municipality name, county name, and state (all NJ).  I am wondering how to use the substring function to pull apart the many municipality names (we have 565 in NJ) to put municipality by itself while also pulling county names (we have 21 in NJ) apart given that names have different end positions.      Thank you!     ... View more

Hello, I have    data test; z='x+y'; x=1; y=2; w=input(z,comma9.); run;  I need w=3, but for some reason it is just a missing value, w=.   Thanks ... View more

This post originally came from a student question about finding out who hasn't logged into their system in a while, using the auditing information from within SAS Studio. It now uses PROC HTTP or the SAS Viya CLI to get a report of who has not logged in recently. ... View more

This post will explore a built-in security functionality in both of the flagship SAS Platforms, SAS 9 and SAS Viya, called Authentication Domains. These are designed to store credentials and securely make them available to users. ... View more