Hi EJ, Thanks a lot for the reply. I am trying to create a reusable project to be used by n number of users. The idea is to allow the users to upload an xlsx file. Once the file is in the server, plan is to use proc import. The structure of xlsx is known ( 3 character columns and 2 numeric columns). Numeric columns are cost price and list price. My requirement is to check if the numeric columns ( cost and list price) has any non numeric value like character values or invalid values and produce a report with those observations. so the list of values is not known Regards, Sheeba S
... View more
