topic Re: How do you enter a query to find errors within a dataset in New SAS User

How do you enter a query to find errors within a dataset

ajackson — Fri, 21 Oct 2022 21:13:05 GMT

Hello,

I am requesting assistance on how to enter a query to find data that are flagged with errors within a dataset.

Thank you!

Re: How do you enter a query to find errors within a dataset

SASKiwi — Fri, 21 Oct 2022 21:19:44 GMT

You need to explain what you mean by "data that are flagged with errors within a dataset". What would be an example?

Re: How do you enter a query to find errors within a dataset

Reeza — Fri, 21 Oct 2022 21:28:05 GMT

What is an error?
If you're looking for data quality measures, that's a much bigger bag of worms.

https://www.lexjansen.com/mwsug/2010/stats/MWSUG-2010-182.pdf

Re: How do you enter a query to find errors within a dataset

ajackson — Mon, 24 Oct 2022 21:10:31 GMT

Hello,

I'm trying to figure out the total count of errors by error flag and quarter in my dataset. Would this be an if/then statement that I use?

Re: How do you enter a query to find errors within a dataset

Tom — Mon, 24 Oct 2022 21:18:06 GMT

@ajackson wrote:

Hello,

I'm trying to figure out the total count of errors by error flag and quarter in my dataset. Would this be an if/then statement that I use?

Sound like you just want to run PROC FREQ.

So assuming you have a error flag variable name ERROR_FLAG and a variable named DATE that has date values you could probably just use the YYQ format to group by quarter. So just do something like:

proc freq data=mydata ;
  tables date * error_flag;
  format date yyq6.;
run;

If there are a lot more distinct values of ERROR_FLAG than there are quarters you might want to reverse the two variables in the TABLES statement. Or perhaps add the /LIST option to the TABLES statement.

Re: How do you enter a query to find errors within a dataset

Reeza — Mon, 24 Oct 2022 21:19:09 GMT

@ajackson wrote:

Hello,

I'm trying to figure out the total count of errors by error flag and quarter in my dataset. Would this be an if/then statement that I use?

Depends a bit on your data structure.

Assuming you have something like this:

Date	Error_Flag
2022-10-23	Error Type 1
2022-10-24	Error Type 3

Then you can do something like this to get the results by quarter:

proc freq data=have; *have is the input data set;
table date*error_flag / list out=want;
format date yyq6.; *controls what level the errors are aggregated at;
*for monthly summary use yymmn6.;
run;

The results will be displayed and saved in a data set named want.

Re: How do you enter a query to find errors within a dataset

ajackson — Wed, 26 Oct 2022 15:36:17 GMT

Great. Thank you!

Re: How do you enter a query to find errors within a dataset

ajackson — Wed, 26 Oct 2022 15:37:02 GMT

Thank you!