• 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,913 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

Missing Value Imputation

by Lapis Lazuli | Level 10 rbettinger in SAS Communities Library
‎02-04-2022 05:20 PM
6 Likes
‎02-04-2022 05:20 PM
6 Likes
I published a paper in the Southeast SAS Users' Group meeting in 2021 on the topic of missing value imputation, and I am sharing it with the SAS community.   I describe the purpose of missing...
Missing Value Imputation SESUG Paper 16-2021.pdf (‏1,888 KB)
Labels:
  • Data Mining
  • SAS IML
  • Statistical Procedures

Macro Code to Identify Missing values and drop the variables with grea...

by Calcite | Level 5 dsp1 in SAS Enterprise Guide
‎01-24-2018 01:17 AM
‎01-24-2018 01:17 AM
Hi All,   I am looking for a macro code which needs to identify missing values percentage for each variable and drop the variables with missing values greater than 80% automatically. &n...
Show results in replies (9)
  • ...ata have; set sashelp.class; call missing(sex,age); run; proc iml; use have nobs nobs; read all v...
  • ...equirement is to have one macro code which will read all the missing values and drop the variables with g...
  • ...bsp; 1. It should check all missing values in the dataset and then drop the variables with high missing...
  • ...hould check all missing values in the dataset and then drop the variables with high missing values and a...
  • OK. No problem.   data have; set sashelp.class; if _n_=1 then call missing(sex,age,n...
  • ...rogramming/Is-there-any-macro-to-check-percentage-of-missing-values-in-a/td-p/9209   From t...
  • ...o drop the given variables.  Its three steps.
  • Or using IML if you have. Check IML's function countmiss() .
  • proc format; value fmt ._-.z='missing' other='nonmiss'; value $fmt ' '='missing' other='n...

Deleting Variables with Only Missing Values from Dataset with 4000+ Va...

by Obsidian | Level 7 sabataged in New SAS User
‎09-12-2018 01:17 PM
‎09-12-2018 01:17 PM
...round 4000+ variables and 3000+ observations.  The data is from 30 different centers, but I am only interested in the data from 3 centers. Some variables are the same for all centers, but variable...
  • Tags:
  • large datasets
  • Macro Variables
  • macros
  • truncation
Show results in replies (1)
  • ...n_)); put _name_ @ ; end; end; put ';' ; run; * Make version of data without empty variable...

CATX with List Containing Missing Variables

by Obsidian | Level 7 tburus in SAS Programming
‎06-01-2020 11:51 PM
‎06-01-2020 11:51 PM
I am trying to use CATX() to concatenate lists of character variables of within a dataset, each of which contains a different number of missing variables on the right end. I am getting them c...
Show results in replies (1)
  • ...esolve this: Use OPTION MISSING=' '; before your Proc Transpose. This should populate the COL variable with...

FROM %LET TO %LOCAL; METHODS, USE, AND SCOPE OF MACRO VARIABLES IN SAS...

by Obsidian | Level 7 IyenJ in SAS Communities Library
‎03-10-2025 09:09 AM
‎03-10-2025 09:09 AM
Presented at PharmaSUG 2022 in Austin, TX
PharmaSUG-2022-AP-041.pdf (‏633 KB)
Labels:
  • SAS Conference Papers

Missing You Less and Less: Learning to Love Admissions Again With Pred...

by SAS Moderator SAS_Innovate in SAS Explore Presentations
‎09-28-2023 03:24 PM
‎09-28-2023 03:24 PM
...imension was missing from our newly developed performance-based scholarship grid, which had led to near-record enrollment. In response, we developed an improved scholarship grid using class rank as a s...
Missing You Less and Less - Learning to Love Admissions Again with Predictive Model Imputations.pdf (‏4,183 KB)
Labels:
  • SAS Explore 2023
  • User Presentations

Missing Value Imputation

by Lapis Lazuli | Level 10 rbettinger in SAS/IML Software and Matrix Computations
‎01-18-2022 07:07 PM
2 Likes
‎01-18-2022 07:07 PM
2 Likes
I have written a paper, "Missing Value Imputation", that I presented at the October Southeast SAS Users' Group 2021 meeting. It contains a historical summary of attempts to perform imputation of missing...
Missing Value Imputation SESUG Paper 16-2021.pdf (‏1,888 KB)
  • Tags:
  • fuzzy c-means clustering
  • missing value imputation
  • SAS programming
  • statistical analysis
Show results in replies (1)
  • Thanks for this post. I look forward to reading it. This seems like a good candidate for an article...

How to drop a variable as long as it contains missing value?

by Fluorite | Level 6 Ruth in SAS Procedures
‎07-11-2011 10:02 AM
‎07-11-2011 10:02 AM
Hi, I just have a data set which contains many variables (>30). For this data set, any variables with missing values are problematic. So the task is to delete all those variables as long as they c...
Show results in replies (8)
  • ...bsp;  run; proc sql noprint;   create table miss as     select distinct p...
  • ...har_var);   if missing(char_var{i}) then char_var_name{i}=vname(char_var{i}); end; do j=1 to dim(n...
  • Thanks, Art. It worked.:smileylaugh:
  • You could take a few minutes and lookup the bits of the code that you don't understand.  It se...
  • ...elete the variables if they contain missing values. Thank you a lot.
  • ...olumns (ie. delete the variable if it contains missing data). Cheers.
  • Ruth, also, check out this thread: http://communities.sas.com/thread/30192?tstart=0 Doc Mu...
  • ...levels; /*NNonMissLevels will not exist when there are no variables with missing values*/  &n...

Stochastic Search Variable Selection with PROC MCMC

by Community Manager AlexBeaver in SAS Code Examples
‎12-14-2023 04:27 PM
‎12-14-2023 04:27 PM
...nd TSTANDARD=CENTER options in the MODEL statement center the specified variables. The CLASS option expands the specified variables to a set of indicator variables, and the ZERO=LAST option sets to missing...
Labels:
  • SAS STAT

Traditional winsorize variables with missing observation

by Barite | Level 11 Phil_NZ in SAS Programming
‎02-07-2021 09:04 PM
‎02-07-2021 09:04 PM
...ut it is not always the case in reality. And we all know that the value of a missing variable is always the smallest so I have the feeling that this code above will not work properly with a variable t...
Show results in replies (1)
  • ...ork properly with a variable that has missing observations?
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros