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

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

Wub_SAS — Wed, 17 May 2023 23:05:27 GMT

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.

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

SASKiwi — Thu, 18 May 2023 00:15:13 GMT

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.

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

ballardw — Thu, 18 May 2023 00:50:27 GMT

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.

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

Wub_SAS — Thu, 18 May 2023 22:02:56 GMT

Ok, thank you for the tips.

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

Wub_SAS — Thu, 18 May 2023 22:03:39 GMT

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