topic Creating script to compare excel files in New SAS User

Creating script to compare excel files

Dumi1 — Thu, 31 Oct 2019 07:34:26 GMT

Hi Guys

Please help me create a script to compare products from an excel sheet to an excel output sheet

For an example :

You run a product and when its done you have to compare with the spec that you have if all fields or products were run in that ouput. So far we currently doing it manually. We look at the file and check the spec and it it off one by one. There should be a way I can run a script right?

Re: Creating script to compare excel files

Kurt_Bremser — Thu, 31 Oct 2019 08:51:14 GMT

It's easy to compare datasets, and that is where you should do your tests. What Excel does with the data is some kind of elaborate lottery, after all. And WILL change with the next Excel version.

Re: Creating script to compare excel files

Dumi1 — Thu, 31 Oct 2019 09:06:18 GMT

thanks Kurt, let me play around with it