BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mMike5
Calcite | Level 5

Hi,

I was wondering whether there is an easy way to assess the no. missing/null values in a field?

I use the following for numeric and string variables. Its fine for numeric variables, but the code for string variables returns a frequency table of values, if there is a lot of records and a string ID field the output can be massive. Is there a way to output a report of only the count of the number of missing values for each character variable?

thanks,

/* Asess numeric variables */

proc means data = Datafile n nmiss;

  var _numeric_;

run;

/* Asess categorical variables */

proc freq data = Datafile;

tables  _character_ ;

1 ACCEPTED SOLUTION

Accepted Solutions
mMike5
Calcite | Level 5

... just in case anyone was wondering!

proc format;

value $miss " "="missing"

other="nomissing";

run;

proc freq data=datafile;

  tables _character_ / missing;

  format _character_ $miss.;

run;

View solution in original post

2 REPLIES 2
mMike5
Calcite | Level 5

... just in case anyone was wondering!

proc format;

value $miss " "="missing"

other="nomissing";

run;

proc freq data=datafile;

  tables _character_ / missing;

  format _character_ $miss.;

run;

Ksharp
Super User
data have;
 set sashelp.class;
 if ranuni(-1) lt 0.5 then call missing(name);
 if ranuni(-1) lt 0.5 then call missing(age);
run;

proc sql;
 select cats('nmiss(',name,') as nmiss_',name) into : list separated by ','
  from dictionary.columns 
   where libname='WORK' and memname='HAVE';

 create table want as
  select &list from have;
quit;

Ksharp

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 770 views
  • 0 likes
  • 2 in conversation