topic Re: getting missing values while running proc sort in SAS Procedures

getting missing values while running proc sort

Ananyayadav — Sun, 23 Sep 2018 19:21:49 GMT

I am getting missing values in every column of my data set after running this below proc sort code.

can anyone help me with this?

Proc sort data=lib.grocery_couponsx out=sorted_freq;
by gender;
run;

data set is created successfully but allover missing values.

Re: getting missing values while running proc sort

PeterClemmensen — Sun, 23 Sep 2018 19:26:38 GMT

Post your log please? And run a PROC FREQ on your data before and after your sort.

My guess is that the sort is performed correctly, but the sort brings the missing values to the top.

Re: getting missing values while running proc sort

Kurt_Bremser — Sun, 23 Sep 2018 19:49:38 GMT

Proc sort does not change any values, only the order. So your problem happens before this sort step.

Re: getting missing values while running proc sort

PaigeMiller — Sun, 23 Sep 2018 20:23:03 GMT

A very useful habit to get into is to actually look, with your own eyes, at the data set that is giving the unexpected result (in this case lib.grocery_coupons) to see if there are missings present. You can use PROC PRINT or PROC FREQ or Viewtable (and probably other tools) to see what is in the data set.

In this case, I'm sure looking at the data set would solve your problem.

Re: getting missing values while running proc sort

VDD — Mon, 24 Sep 2018 02:34:24 GMT

I had errored in my prior statement where I had said proc sort, I meant proc freq as @novinosrin has noted.

correction is, one way that I check to confirm I have data is by using proc freq:

proc freq data=lib.grocery_couponsx;
tables gender / missing out=sorted_freq;
run;

by using the / missing I get a count of records with missing values in my output. If I am ok with them being there I leave them else I delete them.

I use the missing option with proc freq to see if records are slipping past me. Sorry to the community for any miss leading understanding this may have created.

corrected code statement should have been.

Re: getting missing values while running proc sort

novinosrin — Mon, 24 Sep 2018 01:55:40 GMT

Hi @VDD Your code is incorrect as there isn't ant /missing option in a proc sort. I think you prolly meant proc freq. Kindly verify the documentation online. Thanks