• Community
    • Home
    • Welcome
      • Getting Started
      • Community Memo
      • All Things Community
      • SAS Customer Recognition Awards (2024)
      • SAS Customer Recognition Awards (2023)
    • SAS Community Library
    • SAS Product Suggestions
    • Upcoming Events
    • SAS Customer Recognition Awards
    • All Recent Topics
  • Learn
    • New SAS User
    • SAS Software for Learning Community
    • Ask the Expert
    • SAS Certification
    • SAS Tips from the Community
    • SAS Training
      • Programming 1 and 2
      • Advanced Programming
      • Course Case Studies and Challenges
      • Trustworthy AI
    • SAS Global Forum Proceedings 2021
    • Tech Report Archive
    • SAS Insights Archive
  • Programming
    • SAS Programming
    • SAS Procedures
    • SAS Enterprise Guide
    • SAS Studio
    • Graphics Programming
    • ODS and Base Reporting
    • SAS Code Examples
    • SAS Web Report Studio
    • Developers
  • Analytics
    • Statistical Procedures
    • SAS Data Science
    • Mathematical Optimization, Discrete-Event Simulation, and OR
    • SAS/IML Software and Matrix Computations
    • SAS Forecasting and Econometrics
    • Streaming Analytics
    • Research and Science from SAS
  • SAS Viya
    • SAS Viya
    • SAS Viya on Microsoft Azure
    • SAS Viya Release Updates
    • Moving to SAS Viya
    • SAS Visual Analytics
    • SAS Visual Analytics Gallery
    • Your Journey to Success
    • SAS Viya Workbench
      • SAS Viya Workbench: Getting Started
      • SAS Viya Workbench Discussion
      • SAS Viya Workbench: Release Updates
  • Administration
    • Administration and Deployment
    • Architecture
    • SAS Hot Fix Announcements
    • SUGA
  • Solutions
    • Microsoft Integration with SAS
    • Decisioning
    • SAS Decision Builder
    • Data Management
    • SAS Data Maker
      • SAS Data Maker: Getting Started
      • SAS Data Maker Discussion
    • Customer Intelligence
      • SAS Customer Intelligence
      • SAS Customer Intelligence 360 Release Notes
      • SAS 360 Match
    • Risk and Fraud
      • SAS Risk Management
      • Fraud, AML and Security Intelligence
      • SAS Risk Release Updates
      • Risk & Finance Analytics
      • Insurance Fraud
      • MRM AI Governance Working Group
      • SAS Quant Community
    • SAS Health
      • SAS Health and Life Sciences
      • SAS Life Science Analytics Framework
  • Hubs
    • Regional Hubs
      • SAS User Groups
      • SAS Community Nordic
      • AML Nordic User Group
      • SAS Japan
      • SAS Korea
      • CoDe SAS German
      • SAS Plattform Netzwerk
      • SAS Brazil Community
      • SAS Spanish Community
      • SAS Users Group in Israel
      • 欢迎来到SAS中文社区!
      • Ottawa Area SAS Users' Society
      • Toronto Area SAS Users Group
      • SAS Türkiye Community
    • Special Interest Hubs
      • SAS Hacker's Hub
      • SAS Innovate 2026
      • SAS Analytics Explorers
      • The Curiosity Cup
      • SAS Inner Circle Panel
      • SAS Hackathon Team Profiles (Past)
      • SAS Explore
      • Reporting and Optimization
      • Intern Alumni Network Community
Sign In

Search the Community

Showing results for 
Search instead for 
Did you mean: 
Search Options
  • Subscribe to RSS Feed for this Search
Advanced Hide Advanced
  • Posts
  • Users
  • Places
  • Products
Advanced Search Options
Search Modifiers:
You can apply modifiers to the terms you enter in the search field.
Use quotes to search for an "exact phrase".
Use the plus sign to search for +one +or +more +words.
Use the minus sign to -exclude -certain -words from your search.
Limits search results to topics that have no replies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
1,224 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

Data Library Comparison Macro %COMPARE_ALL

by Barite | Level 11 JeffMeyers in SAS Communities Library
‎03-24-2020 12:20 AM
11 Likes
‎03-24-2020 12:20 AM
11 Likes
...f two data libraries instead of just two data sets.   The report indicates any new or lost data sets, variables or observations and checks for changed data values within all variables.&n...
AD-142.pdf (‏332 KB) AD-142-slides.pdf (‏1,289 KB)
Labels:
  • Data Management
  • Healthcare and Pharma
  • SAS Conference Papers
  • SAS User Groups

Library Datasets Summary Macro %DATA_SPECS

by Barite | Level 11 JeffMeyers in SAS Communities Library
‎03-23-2019 11:40 PM
14 Likes
‎03-23-2019 11:40 PM
14 Likes
...uick and concise way to summarize incoming or outgoing data that allows the user to get a grasp of the number of datasets, number of variables, and number of observations included in the library as w...
data_specs_example.xlsx (‏348 KB) 2992-2019.pdf (‏622 KB) 2992-2019 final presentation.pdf (‏1,052 KB) DV-004.pdf (‏288 KB) DV-004-slides.pdf (‏1,248 KB)
Labels:
  • Data Management
  • SAS Conference Papers
  • SAS Programming
Show results in comments (1)
  • ...bsp; There are a few data sets and SQL views that have an enormous number of variables and observations...

SAS SpeedyStore Observability using SAS Enterprise Session Monitor

by SAS Employee MichaelGoddard in SAS Communities Library
‎09-11-2025 11:32 PM
‎09-11-2025 11:32 PM
SAS Enterprise Session Monitor provides a wealth of information on a SAS Viya platform. It can also provide detailed information on a SAS SpeedyStore deployment. This post is a follow-on from my p...
  • Find more articles tagged with:
  • GEL
  • SAS SpeedyStore
Labels:
  • Administration and Deployment
  • SAS Enterprise Session Monitor
  • SAS Viya

Delete all datasets observations in a specific library

by Barite | Level 11 mohamed_zaki in SAS Programming
‎10-16-2014 07:29 AM
1 Like
‎10-16-2014 07:29 AM
1 Like
How to delete every observation in each dataset in a specific lib. PROC DELETE delete all the data set, what  i need is to delete all the data set observations not the data sets it self.
Show results in replies (1)
  • ...null_; set sashelp.vmember(where=(libname='WORK' and memtype='DATA')) end=last; if _n_ eq 1 then c...

Enhancing Observability: Deploying Pre-Configured Grafana Alerts For Y...

by SAS Employee AjmalFarzam in SAS Communities Library
a week ago
a week ago
...rometheus to enhance observability and operational readiness.     New Pre-Configured Grafana Alerts     Beginning in version 1.2.38 (June 2025), the monitoring deployment s...
  • Find more articles tagged with:
  • administration
  • alerting
  • alerts
  • GEL
  • grafana
  • monitoring
  • observability
Labels:
  • Administration and Deployment
  • SAS Viya

Count obs in a library

by Lapis Lazuli | Level 10 BrahmanandaRao in SAS Programming
‎03-17-2021 12:02 PM
‎03-17-2021 12:02 PM
How to count observations for each dataset in a library using macros
Show results in replies (3)
  • ...ets in the SASHELP library and their respective observations into a macro variable called "observations...
  • ...ext code will select all datasets in a given library and their number of observations: data w...
  • ...alse&q=observations%20in%20a%20library   Try the second link for starters. The full c...

Is your SAS library a disk hog? Here's how to put it on a diet.

by Lapis Lazuli | Level 10 rbettinger in SAS Communities Library
‎03-02-2022 12:34 PM
‎03-02-2022 12:34 PM
...ongest string of nonblank characters.   Then I created another macro, %SQZ_LIBRARY, that invokes the %SQUEEZE macro on all of the SAS datasets contained in a SAS data library. It is available a...
Papers_Bettinger_R_74821.pdf (‏150 KB)
Labels:
  • Data Management
  • SAS IT Resource Management
  • SAS Programming

How to find is specific dataset available ( with observations) in the...

by Barite | Level 11 SASuserlot in SAS Programming
‎08-16-2022 11:32 AM
‎08-16-2022 11:32 AM
...vailable or not? 2. if the 'Expense' dataset available then check for is there any observations available or not.(Note: March library have the dataset but no observations in it.) Ps: We have t...
Show results in replies (2)
  • ...umber of observations.    You can filter that data set for the libraries and data s...
  • ...ave any observations  and April have one Observation. But my 'Want' dataset shows there is ' o...

List of all datasets in a library showing number of observations of ea...

by Quartz | Level 8 Angel_Saenz in New SAS User
‎12-26-2018 01:23 PM
‎12-26-2018 01:23 PM
I need a list of all datasets in a library but showing number of observations of each one Like: proc datasets library=libname; run; But showing the number of observations of all datasets. Do y...
Show results in replies (1)
  • data list; set sashelp.vtable; where libname='WORK'; keep memname nobs; run; proc print noobs;run;

How to identify empty datasets ,datasetnames ,observartions count ,var...

by Quartz | Level 8 pavank in SAS Programming
‎01-03-2025 02:50 AM
‎01-03-2025 02:50 AM
...emtype from dictionary.tables where libname = 'LIB1' /* Change to your library name if different */ and nobs = 0 /* Filters datasets with zero observations */; quit; Here I created 100 d...
Show results in replies (1)
  • ...xactly one observation and zero variables, it's because implicit OUTPUT statement being executed at t...
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros