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

anyone can tell why summ on rett0_difs is off from rett0_dif6?! rett0_difs seems just three * rett0_dif6   data temp; do tick=1 to 1000; do i=1 to 1000; rett0=ranuni(i); output; end; end; run; quit; data temp; set temp; by tick; if dif6(rett0)>0 then rett0_dif6=1 ; else if dif6(rett0)=0 then rett0_dif6=0; else rett0_dif6=-1; if dif12(rett0)>0 then rett0_dif12=1 ; else if dif12(rett0)=0 then rett0_dif12=0; else rett0_dif12=-1; if dif24(rett0)>0 then rett0_dif24=1 ; else if dif24(rett0)=0 then rett0_dif24=0; else rett0_dif24=-1; run; quit; proc sql; create table temp_ts as select tick, avg(rett0_dif6) as rett0_dif6, std(rett0_dif6) as rett0_dif6_stv, avg(rett0_difs) as rett0_difs, std(rett0_difs) as rett0_difs_stv from temp group by 1 order by 1; quit; ... View more

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

An update is available for SAS Viya 3.5. Published 23Oct2026 Issue(s) addressed: KB0060459: SAS® Viya® 3.5 location paths are not displayed for objects in nested SAS Content Folders during an export For a complete list of SAS Viya updates available, visit the SAS Viya Updates Page. ... View more