You could use SASHELP.VCLOUMN as a base for issuing PROC FREQ (or any other procedure/program that count missing/null values). One way is to wrap it in a macro which you make "call execute" to. Append the results in the macro to total "null" table, and join back with dictionary.columns.

Be aware that you need to table scan all your tables, so this could take a while if your database is quite large.

The above query worked excelently. But instead of count of null observations can i get only the column name which is having its entire observations null in the output that means datasetname columnname (having obsrvations null in entire column)

I made a few modifications on the original macro based on the clause "Count(Var)" witch counts the number of non-null values of the Var variable. So when Count(var) = 0 means that ALL values of the variable are nulls or missing: