macro data_audit

[alips]

Hello, I need to help. I have to write a code that calculates Distinct_Values,: Missings,: Special Values (-99999; -99998, - 99997, -99996), Err. Values (values with -) for all variables in data set.

Thanks!

[DavePrinsloo]

what exactly is your problem?

[alips]

I have a code that calculates Distinct_Values,: Missings,: Min,: Mean,: Max
but I need to change the code to calculate Distinct_Values,: Missings,: Special Values (-99999; -99998, - 99997, -99996), Err. Values (values with -) for all variables in data set.

[DavePrinsloo]

I suggest you write the code you need for a single table and column with a hard-coded column name and tables, and then add that to your macro and replace the hard-coded names with macro variables.