We can use PROC CONTENTS statement to look at the overview of the data from important info such as total number of observations and variables in the dataset to page size and number of observations on first page and so on.
PROC CONTENTS DATA=USCensus.data VARNUM; RUN;
After the overview of the dataset, it will show each variable name and information associated to it. We can use VARNUM to return the variable number exactly as what stated on the dataset.
INFORMAT column basically shows how each column is read on SAS and converted to something else which is captured or shown on FORMAT column. So we have TotalPop variable which is read on SAS as “BEST32” to ensure long numeric keys are properly captured and converted to “BEST12”. Generally we do not worry or change anything when data is read or captured on SAS, however there might be unique cases when we need to manually write syntax to ensure correct data and conversion is captured on SAS.
Categories: SAS Learning