SAS Viya Copilot for Code Assistance in SAS Data and AI Studio
Recent Library Articles
In this post, we’ll take a look at how SAS Viya Copilot for Code Assistance can help with some of those everyday tasks: understanding code, improving it, and making changes more confidently—all without leaving the SAS Data and AI Studio environment.
SAS Forward: Real Stories, Live Demos and AI Innovation
Ask the Expert
Join us November 4-5 for SAS Forward, a virtual event exploring modern analytics, AI and intelligent decisioning. Discover real-world success stories, explore emerging trends, and see the latest SAS innovations in action through expert-led sessions and live demonstrations.
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
Hello SAS Community, My name is Yosia Hadisusanto. I live in Hannover, Germany, and work as a freelance statistical programmer for the pharmaceutical industry. For my daily work I wanted a SAS editor where I can debug DATA steps and macros, customize it to the way I work, and search and filter a data set easily. So I built one: DataStep Studio, a VS Code extension for SAS programming. It works with SAS OnDemand for Academics and is built for SAS 9.4 servers as well (IOM, the connection SAS Enterprise Guide uses). I only have access to SAS OnDemand for Academics, so I need others to try and test it: above all with a SAS 9.4 server at their company, and on Windows or Linux. Please tell me what works and what doesn't. More features will come. Install: in VS Code open Extensions (Ctrl+Shift+X), search DataStep Studio, Install. Marketplace page: https://marketplace.visualstudio.com/items?itemName=datastep-labs.datastep-studio What it does Run with one key. F4 runs the program or the selection. Also Run To Line, Run From Line, Run Step, Run As Macro and Resolve Code (the code a macro call generates). A log that points back to your code. ERRORs and WARNINGs appear in Problems at their line. The Suspicious Log lists only what needs a look: ERRORs, WARNINGs, and NOTEs such as uninitialized variables, merges with repeats of BY values, or missing values generated. Data at a glance. A data viewer with WHERE, filters, sorting and frequencies. Tick the values to keep, and the SAS condition is written for you. The session in view. Libraries with variables and labels, macro variables, and every system option. Autocomplete that knows SAS. Procedures, options, functions, your librefs, data sets and columns, with the SAS documentation one hover away. proc so + Enter writes the whole PROC SORT with DATA= and BY filled in. Your files where SAS is. Open your SAS OnDemand home as a folder and edit the programs there, or keep them on your computer: the project is synced to the server, so %INCLUDE "macros/setup.sas" and relative paths work. DATA step debugger. Step through a DATA step statement by statement with the PDV in the Variables view, conditional breakpoints ( age > 14 ) and Jump to Cursor. The macro debugger Debugging a macro usually means MPRINT, MLOGIC and %PUT. In DataStep Studio you step through a macro like through any other program: Call pane. Debug Macro opens the call above the definition with every parameter by name: fill in the values and start. Step Into, Over and Out through %LET, %IF, %DO and nested macro calls; the call stack shows which macro called which. Macro variables of each macro in the Variables view (global and automatic on request). Hover &name. for its value, or change a value to try another path through the macro. Conditional breakpoints in macro language: &i. = 3 stops a %DO loop only in its third pass. Debug Console. Evaluate macro expressions such as %EVAL(&n. * 2) , or run SAS code inside the paused macro. Code coverage after the run: every macro line shows how often it ran (×4), and lines never reached are marked. The picture and the video use a small example: %sum_of_squares(4) adds 1² + 2² + 3² + 4² and calls %square for each number. Getting started (about 5 minutes) You need Java 8 or newer and Python 3.8 or newer. SASPy is installed for you. DataStep Studio: Check Setup (Command Palette, Ctrl+Shift+P) finds Java and Python and installs SASPy with one click. DataStep Studio: Add New Connection Profile: SAS OnDemand (your region and user ID) or a SAS 9.4 server (host, port, user). The password is asked once and kept in your system's keychain. Open a .sas file and press F4. The full manual is inside VS Code: DataStep Studio: Open Manual, short recipes in Open How-To Guide, and the videos in Watch the 2-Minute Tour and Watch the Macro Debugger Video. What I would like to know Did the installation and the first connection work? How long did it take, and where did you get stuck? Which features do you use, and what is missing for your daily SAS work? Anything that behaves differently from SAS Enterprise Guide or SAS Studio in a way that surprised you. So far I could test it only with SAS OnDemand for Academics, and mainly on macOS. Reports from SAS 9.4 servers, Windows and Linux are especially welcome. Please reply here, or use Q & A on the Marketplace page. DataStep Studio: Report a Problem copies an error message with the versions of VS Code, Java, Python and SASPy (home folders hidden) for you to paste. Your data stays yours DataStep Studio collects nothing: no telemetry, no usage data. Your code, data and logs go only to your own SAS session. The password stays in your system's keychain. Editions Community is always free: all run modes, the log views, the data viewer, the session views, autocomplete, the SAS Server window and project sync. Professional adds the DATA step and macro debuggers, smart code, Enlarge/Optimize macro calls and Git on the SAS server. During Community Early Access, all Professional features are available free of charge. Early Access is temporary. Professional functionality may require a paid license following the Early Access period. Free Community functionality will remain available. I am still thinking about how this will look after Early Access. For now, let's build this together and make an awesome SAS editor to work with. Thank you for trying it! DataStep Studio is an independent project and is not affiliated with or endorsed by SAS Institute Inc. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc.
... View more
A new update is available for SAS Hadoop Configuration Libraries , version 3.0 : Hot Fix: R6A002 - Published 30OCT2026 , Download link for R6A002 Component name: SAS Hadoop Configuration Libraries Related SAS release: SAS 9.4 Issues addressed in R6A002 This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for R6A002 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
... View more
Team Name
Team CLMers
Track
Public Sector
Use Case
*Our team, CLMers, proposes an AI-powered wildfire prevention platform that helps public authorities anticipate and mitigate wildfires before they occur. The solution combines weather forecasts, satellite imagery, vegetation indicators, historical wildfire records, and open data to generate dynamic wildfire risk assessments. Using predictive analytics and geospatial intelligence, the platform estimates ignition risk, fire spread potential, and expected impact. It also provides decision support recommendations to help optimize prevention measures and resource allocation. By shifting wildfire management from reaction to prevention, the project helps protect ecosystems, rural communities, and critical infrastructure while improving climate resilience and public-sector efficiency. Built on scalable cloud technologies and open data, the solution can be replicated in any wildfire-prone region worldwide. Vision: From firefighting to fire prevention.
Technology
SAS Viya
Region
Spain
Team lead
Cobas López, Christian
Team members
18 Team members
Social media handles
*all team members' social media links here*
Is your team interested in participating in an interview?
Y
Optional: Expand on your technology expertise
The Team
Pitch
Jury
... View more