Hi, I want to create a validation summary report for a table or a csv file. I have a sql table with x columns and the x columns has y no of records. The validations include lookups,missing values, duplicates and invalid values. e.g. name1        numeric1       date1      name2 The data I have taken from sql which is imported using the proc import data= option. Now, I would like to have a report with each column against which the number of invalid records. On top of the report the overall no of records provided and the table name or csv filename. I am using the sas university edition to do this.  Could anyone please guide on how do I do this, I am pretty new to sas and can do the basics ... View more