topic Re: check the errors and report it in New SAS User

check the errors and report it

Smitha9 — Tue, 03 Nov 2020 15:47:27 GMT

I will be getting the dataset everyweek which contains specific varaibles.

I have the check the errors and report it.

Example:

Dataset has a variable names:

CustomerID CustomerAge CustomerDOB Purchase Type Model

1111 70 10/20/1990 Cartel Eco X

The errors I need to check with the above dataset:

1. Check the order of the variables of the dataset. Make sure the order is exactly like above.

2. Check the spelling of the variable names.

3. Any missing values flag it and report.

4. Check the CustomerAge if negative and if negative flag it.

thank you in advance.

Re: check the errors and report it

Kurt_Bremser — Tue, 03 Nov 2020 16:03:07 GMT

Same question as in your other thread: how do you receive your data (file format, transmission path, ...)

Re: check the errors and report it

Smitha9 — Tue, 03 Nov 2020 16:16:53 GMT

I receive the SAS dataset

Re: check the errors and report it

ballardw — Tue, 03 Nov 2020 16:26:00 GMT

@Smitha9 wrote:
I receive the SAS dataset

Then WHY does order of variables matter? Really. SAS does not care about the order of the variables generally.

And why would the variable names change? If that is happening then the problem is before you get the data and a process is likely the thing that needs correction.

How do you want the data flagged? Do you want one new variable for each existing variable to hold a "missing" flag value? One variable that holds information for all variables that may be missing?

What does the report of missing data look like? There are many ways to report on such.

Should the flag for negative age be a separate variable? or a different value in the Flag that would hold the "missing" age flag?

Re: check the errors and report it

Kurt_Bremser — Tue, 03 Nov 2020 16:43:47 GMT

@Smitha9 wrote:
I receive the SAS dataset

Then the order of variables is irrelevant.

Finding incorrect spelling can be done by comparing the sashelp.vcolumn entries for your old and the new dataset.