topic Exploratory analysis macro in SAS Programming

Exploratory analysis macro

Srigyan — Tue, 28 May 2019 12:57:54 GMT

Is there any macro which can give an exploratory analysis for a dataset and create a dataset for all variable at once, char or numeric both.Whatever not applied for char that will be blank

Label-Variable name

Type- i.e. char/date/num

length-length of variable

no of record

nmiss

how many unique value

mean

median

mode

std dev

p value etc

Re: Exploratory analysis macro

Quentin — Tue, 28 May 2019 13:02:54 GMT

If you search over at lexjansen.com for terms like "data dictionary" and "codebook" I think you'll find plenty of user group papers that present macros to do this sort of reporting.

Re: Exploratory analysis macro

Reeza — Tue, 28 May 2019 17:52:30 GMT

If you have SAS Studio or Enterprise Guide, there's a task called 'Characterize Data' that will do this.