Any guide/workflow material which I can adapt for data cleaning and management in SAS

[Wub_SAS]

Hi, my SAS skill is a beginner and I am looking for any good guide/workflow material which I can adapt to have a robust data cleaning and management procedure and documentation. If anyone has any suggestion, I will be very grateful to know. Thank you.

[SASKiwi]

SAS has a product for data cleaning called SAS Data Quality. Unfortunately, I doubt you would have it available to you and the documentation does not include "how to" guides for particular techniques.

I suggest you start with one use case, say cleaning one column. The first step would be analyse the data in the column and if it is a character column, report on the distinct values like this:

proc freq data = MyData;
  table MyColumn / missing;
run;

Then you need to compare the report with what values you expect that column to have, so you can now identify the values that are errors. 

[Wub_SAS]

Ok, thank you for the tips.

[ballardw]

A book that may be of interest:  https://support.sas.com/en/books/reference-books/codys-data-cleaning-techniques-using-sas.html

There are some excerpts available for download but the book needs to be purchased for everything.

[Wub_SAS]

Thank you very much! I like the excerpts and plan to buy the book.