Short: – Prints out only names of variables (without attributes) in SAS dataset.
PROC CONTENTS DATA=SASHELP.CLASS SHORT;
RUN;
Default it prints list of variables in Alphabetical order, but need to print in both alphabetic and dataset order
PROC CONTENTS DATA=SASHELP.CLASS SHORT POSITION;
RUN;
Default it prints list of variables in Alphabetic order, but need to print in only dataset order
PROC CONTENTS DATA=SASHELP.CLASS SHORT /*POSITION*/ VARNUM;
RUN;
Centiles: – Print centiles information for indexed variables
/*SIMPLE INDEX */
PROC SQL;
CREATE INDEX NAME ON SASHELP.CLASS (NAME);
QUIT;
/* COMPOSITE INDEX*/
PROC SQL;
CREATE INDEX NAME ON SASHELP.CLASS (NAME,SEX,AGE,HEIGHT,WEIGHT);
QUIT;
PROC CONTENTS DATA= SASHELP.CLASS CENTILES;
RUN;
Out2:- Specify the name of an output data set to contain information about indexes and integrity constraints
PROC CONTENTS DATA= SASHELP.CLASS OUT =DATASET1 OUT2=DATASET2;
RUN;
Data=_all_:- Prints descriptor information for all the datasets in library.
PROC CONTENTS DATA=WORK._ALL_;
RUN;
Nods:-Suppress the printing of individual files
NODS can use with only DATA=_ALL_.
PROC CONTENTS DATA=WORK._ALL_ NODS;
RUN;
Fmtlen: – Print the length of a variable’s informat or format
PROC CONTENTS DATA= SASHELP.CLASS FMTLEN;
RUN;
Directory: – Print a list of the SAS files in the SAS library
PROC CONTENTS DATA= SASHELP.CLASS DIRECTORY;
RUN;
Order: – COLLATE | CASECOLLATE | IGNORECASE | VARNUM
Collate – Prints list of variables in alphabetical order beginning with uppercase and then lowercase names.
Casecollate – Prints list of variables in alphabetic order even if they include mixed-case names and numerics.
Ignorecase – Prints list of variables in alphabetical order ignoring the case of letters.
Varnum – It is same like Varnum option (means prints variables in dataset order).
PROC CONTENTS DATA= SASHELP.CLASS ORDER=VARNUM;
RUN;
Memtype: –
The contents statement produces output only for member types like DATA, VIEW, and ALL, which includes DATA and VIEW.
PROC DATASETS MEMTYPE=DATA;
CONTENTS DATA=SASHELP._ALL_;
RUN;
PROC DATASETS MEMTYPE=DATA;
CONTENTS DATA=SASHELP._ALL_;
RUN;
To get contents off all catalogs
PROC CONTENTS MEMTYPE=LIB.CATALOG;
RUN;
To get contents off all Views
PROC CONTENTS MEMTYPE=LIB.VIEW;
RUN;