Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
1,846 results
Sorted by:
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:
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...
-
...hould check all missing values in the dataset and then drop the variables with high missing values and a...
-
...bsp; 1. It should check all missing values in the dataset and then drop the variables with high missing...
-
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.
-
proc format; value fmt ._-.z='missing' other='nonmiss'; value $fmt ' '='missing' other='n...
-
I have a large dataset. So, if possible plz write some sql code to fulfill my requirement. Thanks i...
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...
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...
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:
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:
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)
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...
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...
05-04-2012
12:38 PM
...ate). My problem is that at the final stage some of the dates, which have become the variables, are missing. What should I do to keep all the dates instead of only keeping the ones that there exist h...