Useful SAS queries for newbies

/* get the dataset dictionary (SAS meta data) for your dataset */
PROC SQL;
CREATE TABLE MYLIB.myDataset AS SELECT *
FROM DICTIONARY.TABLES
WHERE UPCASE(LIBNAME)=”MYLIB” AND memname=%upcase(“myDatasetName”);
DATA MYLIB.myDataset;
SET MYLIB.myDataset;
RUN;QUIT;

/* set/update the dataset label name (description) */
DATA MYLIB.myDataset (label=”This is my label description for the dataset”);
SET MYLIB.myDataset;
RUN;QUIT;