Exploratory analysis macro

[Srigyan]

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

like

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

[Quentin]

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.

[Reeza]

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