topic Re: I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause in SAS Programming

I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause

current_thing — Tue, 05 Jul 2022 14:59:34 GMT

Hello!

I'm new to SAS Programming. I have the following code:

proc contents data=my_table;
where date_field>="1jan21"d;
run;

The above throws warning. The variable date_field is formatted as numeric. What am I doing wrong?

Re: I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause

Reeza — Tue, 05 Jul 2022 16:28:01 GMT

That's an interesting filter to have on a PROC CONTENTS....can you explain what you're trying to do?

PROC CONTENTS displays the variable name, label, type which doesn't change regardless of filters.

@current_thing wrote:

Hello!

I'm new to SAS Programming. I have the following code:
proc contents data=my_table;
where date_field>="1jan21"d;
run;
The above throws warning. The variable date_field is formatted as numeric. What am I doing wrong?

Re: I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause

current_thing — Tue, 05 Jul 2022 16:30:21 GMT

Hello. I wanted to get a count of observations based on the date filter. That same where clause works fine in the print procedure, so I know the syntax is correct

Re: I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause

Tom — Tue, 05 Jul 2022 17:18:33 GMT

@current_thing wrote:
Hello. I wanted to get a count of observations based on the date filter. That same where clause works fine in the print procedure, so I know the syntax is correct

PROC CONTENTS does NOT count observations. It just reports whatever count the metadata of the dataset already had stored.

To count use some other procedure, like PROC FREQ, PROC MEANS (aka PROC SUMMARY) or PROC SQL.

You could also just use a data step.

data _null_;
  set my_table;
  where date_field>="1jan21"d;
run;

And see the number of observations that met the WHERE condition in the NOTEs generated by the data step.

Re: I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause

Reeza — Tue, 05 Jul 2022 19:14:14 GMT

proc means data=my_table NOBS N;
where date_field>="1jan21"d;
run;

I'd probably use PROC MEANS.

Re: I get "WARNING: No data sets qualify for WHERE processing" for WHERE clause

Reeza — Tue, 05 Jul 2022 19:14:21 GMT

proc means data=my_table NOBS N;
where date_field>="1jan21"d;
run;

I'd probably use PROC MEANS.