Done. Thanks again for your help. On to the next post ... how to schedule a batch process ... ... View more

Awesome!!! You guys are SAS geniuses! Thanks a million for your help. I got exactly what I needed. COLUMNS WITHOUT DATA Obs TableVar TableVarLabel NLevels NMissLevels NNonMissLevels 1 UPDATED_BY UPDATED_BY 1 1 0 2 UPDATE_DATE UPDATE_DATE 1 1 0 ... View more

I apologize for being misunderstood. In the above report, what tells me which columns have no data? Below is a sample dataset. Why doesn't the report list observations 9 and 10 only? FLAG_ID MDVC_ID MR_GATEWAY_ID FLAG_COUNT ORIGIN_DATE INSERTED_BY INSERT_DATE UPDATED_BY UPDATED_DATE 20621 586064 62 1 01JUN2015:00:00:00 WACSMDMS 01JUN2015:12:10:02   . 20621 586074 62 1 01JUN2015:00:00:00 WACSMDMS 01JUN2015:12:10:02   . 20621 586082 62 1 01JUN2015:00:00:00 WACSMDMS 01JUN2015:12:10:02   . 20621 586083 62 1 01JUN2015:00:00:00 WACSMDMS 01JUN2015:12:10:02   . ... View more

Here's the code I changed: data WORK.FILTER_FOR_MDVC_FLAGS; set WORK.FILTER_FOR_MDVC_FLAGS; call missing(ENTRY_DATE, FLAG_ID, MDVC_ID, MR_GATEWAY_ID, FLAG_COUNT, ORIGIN_DATE, INSERTED_BY, INSERT_DATE, UPDATED_BY, UPDATE_DATE); run; ods select none; ods output nlevels=want(where=(NNonMissLevels=0)); proc freq data=WORK.FILTER_FOR_MDVC_FLAGS nlevels; table _all_; run; ods select all; title 'COLUMNS WITHOUT DATA'; proc print;run; QUIT;     Here's the report generated: COLUMNS WITHOUT DATA Obs TableVar TableVarLabel NLevels NMissLevels NNonMissLevels 1 ENTRY_DATE ENTRY_DATE 1 1 0 2 FLAG_ID FLAG_ID 1 1 0 3 MDVC_ID MDVC_ID 1 1 0 4 MR_GATEWAY_ID MR_GATEWAY_ID 1 1 0 5 FLAG_COUNT FLAG_COUNT 1 1 0 6 ORIGIN_DATE ORIGIN_DATE 1 1 0 7 INSERTED_BY INSERTED_BY 1 1 0 8 INSERT_DATE INSERT_DATE 1 1 0 9 UPDATED_BY UPDATED_BY 1 1 0 10 UPDATE_DATE UPDATE_DATE 1 1 0     The columns UPDATED_BY, UPDATE_DATE do not contain data. How can I get the report to list these two column names? Thanks in advance!  ... View more

Thanks, KSharp! How do I create the same report using the Enterprise Guide? ... View more

Exactly! Is there an easy way to make this happen? ... View more

Thanks for responding. I'm very new to SAS, so something simple like below will do just fine:   COLUMNS WITHOUT DATA   Customer_Name_2 Name_Title Name_Suffix Address_Line_3 Post_Directional_Code etc. ... View more