Starting with the release for October 08, 2025, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) and Common Data Model (CDM) for schema 19. Schema 19 contains enhancements to support these features: UDM tables now indicate which columns are the primary key or part of...| communities.sas.com
@RobPratt How to code-up a penalty function on the difference between _tmin_orig and _tmin_x?! If _tmin_orig<=_tmin_x, score=-10 else if _tmin_orig>_tmin_x+60, score=2 else if _tmin_orig>_tmin_x+36, score=4 else if _tmin_orig>_tmin_x+24, score=8 else if _tmin_orig>_tmin_x+12, score=6 else if _tmin_orig>_tmin_x+6, score=2 else if _tmin_orig>_tmin_x+0, score=1 Thanks, con CardinalityMethod: sum {m in METHODS} SelectMethod[m] = 1; /* primary objective */ solve; /* con MinScore: Total...| New board topics in SAS Support Communities
Dear SAS Community, I would greatly appreciate it if you could let me know how to include percent of frequency inside all levels of the Variable Peel Color in this graph. For some levels the % is included in the bars, but not for all levels. This is the code I am using: ods powerpoint file='Storage PeelColor BL516 Harvest.pptx'image_dpi=300; title "Storage PeelColor: BL516 vs Hass by Harvest month"; proc sgpanel data=one pctlevel=group; where Harvest in(1,2,3,4,5,6,8) and Variety in('BL...| New board topics in SAS Support Communities
Apologies if this is a duplicate -- there are several closely related posts on this forum, but I did not see one with exactly my issue... I'm using ODS RTF with the BODYTITLE option, and I want some pages to be portrait and others landscape. Oddly, I can start the output file in portrait and then change to landscape, but if I start in landscape then I cannot change to portrait. Here's a minimal reproducible example, creating a macro that prints a two-page RTF file. You can specify the o...| New board topics in SAS Support Communities
We're gathering information on how people use Visual Analytics, and we'd love to hear from you! This brief survey (takes less than 5 minutes to complete) focuses on feature usage patterns. There are no complicated questions, just quick insights into how you work with VA day-to-day. Take the Survey Here (It will be open through October 24th.) Thanks for being part of our community and for taking the time to share your experience. Every response helps us build a better produ...| New board topics in SAS Support Communities
(view in My Videos) In our latest Learning Lab, @zephstemle showcased how to turn live SAS Event Stream Processing (ESP) pipelines into dynamic, actionable dashboards using the ESP Grafana Plugin—right inside Grafana. This integration empowers operators and stakeholders with real-time visibility, eliminating the need to switch tools or refresh pages. The Big Idea Modern operations rely on continuous data streams—IoT sensors, business events, telemetry. The ESP Grafana Plugin brid...| New board topics in SAS Support Communities
Hi Community folks! One of our most popular pages on the community site is the Latest Message Activity list, which provides an all-inclusive view of all topics and articles that have been posted or replied to recently. As our community site has seen an increase in "non-discussion" content (Hackathon use cases, How to articles, SAS Innovate session recaps, etc.), some frequent users asked for a way to filter that activity list to "only forums" -- so they can focus on the active discussions ...| New board topics in SAS Support Communities
I want to correct the encoding for all members of a data library. proc datasets lib=orig; modify ae / correctencoding=wlatin1; /* or windows-1252 */ quit; I know I can use codegen to do this task. Is there a way this can be done using COPY perhaps? Modify _ALL_ does not work. 🙂| New board topics in SAS Support Communities
I need help understanding how to generate a usage report for products licensed with the metric as "Client" or "Per Site". Ideally, I’d like to retrieve these details directly via the SAS console. Below are some of the products we’re interested in. SAS Institue SAS Credit Risk Management for Banking - Client SAS Institute SAS Credit Scoring - Client SAS Institue SAS/ACCESS to DB2 - Client SAS/STAT - Per Site SAS/IML - Per Site| New board topics in SAS Support Communities
Hey SAS communities, I'm sharing for your awareness before you decide to migrate to SAS 9.4 M9! My SAS kicked me in the face today: 1 data _null_; 2 x=42; 3 a = ADDRLONG(x); 4 z = PEEKLONG(a, 8); 5 put x= a= z=; 6 run; ERROR: The ADDRLONG function is not available beginning with SAS 9.4M9. ERRO...| communities.sas.com
Hi All, As we know, updating SAS on Microsoft Azure currently requires a full redeployment. I remember that previous SAS documentation mentioned they were working on new methods to streamline this process. Has there been any progress or official guidance on easier update mechanisms for SAS deployments in Azure? Would appreciate any insights or experiences from the community! Fernando.| New board topics in SAS Support Communities
proc sql; create table cf_HYFI&minyear.&minmonth._&maxyear.&maxmonth._N_Harmony as select a.years as year, a.cie, a.province_cd, a.distribution, a.group as LineOfBusiness, a.SAS_WP_corr format=NLNUM15.0, a.SAS_WU_corr format=NLNUM15.0, b.writtenPremium format=NLNUM15.0, b.writtenUnit format=NLNUM15.0, (a.SAS_WP_corr - b.writtenPremium)*100/a.SAS_WP_corr as wp_diff format= 8.2, (a.SAS_WU_corr - b.writtenUnit)*100/a.SAS_WU_corr as wu_diff format= 8.2 from SAS_Summary as a inner join harmony_trx...| New board topics in SAS Support Communities
Join us in-person or virtually on December 2nd, 2025, for the Toronto Area SAS User Group meeting (TASUG)! Detailed Agenda and Registration: Toronto Area SAS User Group - December 2nd, 2025 Featuring presentations on “AI: Tools, Challenges & Real-World Adoption” from Yulia Diamond, AI Enablement Lead – Tangerine Bank as well as SAS Tips and Techniques on “Getting Started with SAS and MS Copilot” and “Best Practices in Data Management in the Cloud with SAS”. Register Here| New board topics in SAS Support Communities
As a disclaimer, I am new to SAS Web Applications, Stored Processes, the ODS function, and APIs as a whole, with only introductory knowledge on the subjects as I've only just finished putting together my first web application stored process. I am aware SAS Viya has functionality for building APIs, but I do not have access to SAS Viya at my company, and it is not going to be an option before this project is needed. With that said, I am looking to get the output of a web application stored proc...| New board topics in SAS Support Communities
SAS Content Assessment for 2025.09 Has Shipped!. The 2025.09 release includes the following: SAS Code Dependencies handles more scenarios. Profiling SAS Data Integration Studio objects includes more checks to determine the fitness of SAS Data Integration transformations for migration to SAS Viya. Profiling SAS Enterprise Guide projects detects circular dependencies in SAS Enterprise Guide projects. These projects are tagged as migration concerns. System evaluation informs you whether SAS Se...| New board topics in SAS Support Communities
LibName trx SPDE "/.../transaction/" ; %Let varToKeep = system lineOfBusiness distribution company companyDivision region province accountingYear accountingYearMonth writtenPremium writtenUnit driverType ; Data harmony_trx ; Set trx.prm_trx_: (Keep=&varToKeep. ); Where accountingYear ge 2024 And accountingYearMonth LE 202509; If distribution = 'Prestige' Then distribution = 'Broker'; If driverType = 'Occasional' Then writtenUnit = 0; Run; proc freq data=harmony_trx; table driverType; run; the...| New board topics in SAS Support Communities
Perhaps off-topic but.... I've accessed SAS ODA via Google Chrome successfully and extensively for several years. But recently, beginning this past summer, I've been having difficulties. When a run a code with extensive output (tables, graphs, maps) Chrome will "lock up" when producing output an...| communities.sas.com
I have an AE dataset and need to create 3 variables, lasteventfl, aegroup and firstdt, per the following specs: Step 1: Sort Data BY subject aesoccalc aeptcalc temporary_suppae_qval_ctcae temporary_ae_aeterm aestdat visno recordid Step 2: Fill Missing End Dates Within each subject/AESOCCALC/AEPTCALC/temporary_suppae_qval_ctcae/temporary_ae_aeterm combination: Rule: If a record has the same AESTDAT as another record in that group, it should have the same AEENDAT. Implementation: For reco...| New board topics in SAS Support Communities
Hello, I am trying to set up a program calling rest API in order to trigger a databricks job. The issue I am facing is that I cannot encrypt the token and it only works if the oauth_bearer value is provided in plaintext. This gives me error 401: filename pwfile 'testpw.txt'; proc pwencode in="foo" out=pwfile method=sas005; run; data _null_; infile pwfile truncover; input line :$200.; call symputx('dbxtoken',line); run; filename jpl 'testin.json'; proc json out=jpl; write values "job_id" "1...| New board topics in SAS Support Communities
I have a time-series dataset[time=i; Y=tsvar], attached. I need have multiple reference at column=refind, AND if refcolor=max, color=lime, if refcolor=min, color=blue. Thanks,| communities.sas.com
I am getting regional maxs/mins where to set reference lines (axis=x). I need show the reference lines with two diff. colors (Max-> Blue; Min -> Cyan). Sample code is below. Used additional dataset is fine, such as _test_mm_ind. Thanks, data _test; do i=1 to 300; tsvar=sin(i/10); output; end...| communities.sas.com
a. Region&State&Month&Expenses&Revenue Southern&GA&JAN2001&2000&8000 Southern&GA&FEB2001&1200&6000 Southern&FL&FEB2001&8500&11000 Northern&NY&FEB2001&3000&4000 Northern&NY&MAR2001&6000&5000 Southern&FL&MAR2001&9800&13500 Northern&MA&MAR2001&1500&1000 b. "Africa","Boot","Addis Ababa","12","$29,761","$191,821","$769" "Asia","Boot","Bangkok","1","$1,996","$9,576","$80" "Canada","Boot","Calgary","8","$17,720","$63,280","$472" "Eastern Europe","Boot","Budapest","22","$74,102","$317,515","$3,341...| New board topics in SAS Support Communities
Perhaps off-topic but.... I've accessed SAS ODA via Google Chrome successfully and extensively for several years. But recently, beginning this past summer, I've been having difficulties. When a run a code with extensive output (tables, graphs, maps) Chrome will "lock up" when producing output an...| communities.sas.com
I recognize that this is kind of a dumb question but I can't seem to find a concrete answer. I am running a regression using proc reg. My outcome variable is any smoking and is coded as 0 (no smoking) and 1 (any smoking). How do I know which level is the reference value? I have been assuming that it...| communities.sas.com
Get SAS tips, share your knowledge, and find out about upcoming SAS-related events.| communities.sas.com
Shionogi & Co., Ltd Contact: Satoshi Sakai Country: Japan Award Category: Community Uplift Tell how you've used SAS to have a positive impact on your community. Two events will be presented to revitalize the SAS and data science communities. 1. Naniwa Data Science Research Meeting In ord...| communities.sas.com
Where Your Curiosity Leads to Innovation| communities.sas.com
