topic Re: macro data_audit in SAS Programming

macro data_audit

alips — Tue, 24 Mar 2020 14:38:14 GMT

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!

Re: macro data_audit

DavePrinsloo — Tue, 24 Mar 2020 11:15:37 GMT

what exactly is your problem?

Re: macro data_audit

alips — Tue, 24 Mar 2020 11:23:06 GMT

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.

Re: macro data_audit

DavePrinsloo — Tue, 24 Mar 2020 13:42:33 GMT

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.