topic Re: Data validation between excel to database in SAS Programming

Data validation between excel to database

Faizanshaikh — Mon, 20 Dec 2021 23:00:23 GMT

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.

Re: Data validation between excel to database

Reeza — Mon, 20 Dec 2021 23:35:40 GMT

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.

Re: Data validation between excel to database

Patrick — Tue, 21 Dec 2021 03:15:53 GMT

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

Re: Data validation between excel to database

Faizanshaikh — Fri, 24 Dec 2021 23:07:48 GMT

Yes. I know and this part has been done.