Data validation between excel to database

[Faizanshaikh]

Hello all.
I am new in sas community and I am very exciting to join this community for get help of sas programming challenges.
I have a question.
I have a excel file with the some data and same as a table available in sql server so i want know you how can I verify all cells or data of excel sheet with sql server table.
Please let me know any idea for data verification.
Thanks for advance.

[Reeza]

PROC COMPARE is a good place to start but I would expect many issues when importing from Excel and comparing to a DB.

Excel doesn't enforce data types, ie a column can contain a mix of numeric and character data. When SAS imports that data it has to guess at types and lengths, which are usually rigidly enforced in a DB. But PROC COMPARE is a good starting point.

[Patrick]

To add to what @Reeza wrote: Do you already know how to read Excel data and a SQL Server table into SAS?

[Faizanshaikh]

Yes. I know and this part has been done.