Whether you need to delete every row in a table or remove a handful of specific rows, the new Delete Rows step in SAS Data and AI Studio makes the process easy for you! In this post, I'll demonstrate how to remove rows in a database table with the three options available in the Delete Rows step. Keep reading to learn more about removing unneeded rows from your tables! ... View more

Meet The Roominators from the University of North Carolina Wilmington! Our SAS Hackathon 2026 project, the Space Allocation Simulator, explores how data analytics and scenario modeling can transform university classroom utilization, optimize space allocation, and help institutions make smarter, more cost-effective facilities decisions. Every Room Has Potential. Every Decision Deserves Data. ... View more

In SAS VI 2025.09, we noticed that searches saved in the Search tab did not automatically appear in the Saved Searches section on the Home Page. We would like to request an enhancement that enables automatic synchronization of Saved Searches between these two locations in a future release of SAS Visual Investigator. Requested Functionality: Searches saved in the Search tab should automatically appear in the Saved Searches section on the Home Page. Changes to saved searches, including renaming and deletion, should be reflected in both locations. Both locations should display a consistent list of saved searches for the same user. Business Value: This enhancement would provide a more consistent and intuitive user experience, allowing users to easily access their saved searches directly from the Home Page without navigating to the Search tab. Expected Behavior: Saved Searches should be managed as a unified collection and remain automatically synchronized between the Home Page and Search tab. ... View more

Bei sas Viya Visual Analytics gibt es bei Listentabellen ein "Zeilenlimit", wird das überschritten wir die Info "Es werden nicht alle Daten angezeigt, da das Zeilenlimit für Abfrage auf dem Client dem auf dem Server definierten Schwellwert überschreitet." ausgegeben. Kann ich das innerhalb SAS Viya als "Trigger" verwenden um z.B. eine Anzeigeregel darauf auszulegen? In SAS Viya Visual Analytics, list tables have a row limit. When it is exceeded, the following message is displayed: "Not all data is displayed because the row limit for the query on the client exceeds the threshold defined on the server." Can I use this condition as a trigger within SAS Viya, for example to base a display rule on it? Worum geht es mir, die Info rechts unten bei der Listentabelle ist sehr "unscheinbar", ich brauche eine  Bessere Lösung für die Berichtsnutzer, damit ihnen die Info mehr ins "Auge springt". Hat hier vielleicht jemand schon was in der Richtung umgesetzt? LG Harald ... View more

Is there a way to remove the lines I put in red parentheses? Here is my code:   ods listing close; ods escapechar='^'; ods rtf file="&path.\Table 2.1.1 IOP Cohort 1 &sysdate..rtf"  style=styles.rtfstyle ;*bodytitle;  proc report data=t1 nowd headline split='|' missing; column pgbrkvar rowborder rowborder2 v stat_cat  ("Eyes in CycloPen + Cataract Surgery Cohort (N=%left(&c99.)" var1 var2 var3 var99) ; define pgbrkvar  / order  noprint; define rowborder  / order  noprint; define rowborder2  / order  noprint; define v /display left  "Visit" style(column)=[cellwidth=0.9in borderrightcolor=black borderrightwidth=1]; define stat_cat /display left  "Summary" style(column)=[cellwidth=2.3in borderrightcolor=black borderrightwidth=1]; define var1 /display center  "One Spacer|(N=%left(&c1.))"  style(column)=[cellwidth=0.9in borderrightcolor=black borderrightwidth=1]; define var2 /display center  "Two Spacer|(N=%left(&c2.))"  style(column)=[cellwidth=0.9in borderrightcolor=black borderrightwidth=1]; define var3 /display center  "Three or More Spacer|(N=%left(&c3.))"  style(column)=[cellwidth=0.9in borderrightcolor=black borderrightwidth=1]; define var99 /display center  "Overall|(N=%left(&c99.))"  style(column)=[cellwidth=0.9in borderrightcolor=black borderrightwidth=1]; break after pgbrkvar / page; compute before _page_ / left style=[just=l protectspecialchars=off];     line '\brdrb\brdrs\brdrw10'; line "Table 2.1.1, Table 2.1.1, Analysis of IOP by Visit and Number of Spacers for CycloPen and Cataract Surgery Cohort, Treated-Eye Population";   endcomp;    compute before rowborder;       count+1;    endcomp;    compute rowborder;       if rowborder ^= . and count ^=1 then call define(_row_,'style','style=[bordertopcolor=black bordertopwidth=3]');    endcomp; run; ods rtf close; ods listing;   ... View more