Compare file specification table to test data

bmerry1 — Thu, 04 Oct 2012 20:06:48 GMT

Hi and thank you in advance for any assistance. I was hoping to get some information on what may be a useful/best method using SAS to compare a reference data file that contains a specific set of values and labels to a production data file that utilizes the codes. For example:

Reference data:

CARMODEL CARTYPE

Camaro sport

Landcruiser suv

Explorer suv

Ranger truck

Production data file:

DRIVER CARMODEL CARTYPE

Toonces Camero sport

Danny Explorer suv

Henry Camero sport

Winston Landcruiser truck

I would like to be able to compare the production file against the reference data file to check for programming/entry errors--for example 'Camero' instead of 'Camaro' and Landcruiser incorrectly associated with truck instead of suv. I had been exploring using PROC COMPARE, but this does not seem to be the appropriate method for performing this type of one to many comparison. I would really appreciate and guidance, suggestions, or approaches anyone is willing to share. Thank you again for your time and assistance.

Re: Compare file specification table to test data

Linlin — Thu, 04 Oct 2012 20:17:26 GMT

not tested code:

proc sql;

select * from production

where catx('-',upcase(carmodel),upcase(cartype))

not in (select catx('-',upcase(carmodel),upcase(cartype)) from reference);

quit;

Re: Compare file specification table to test data

bmerry1 — Fri, 05 Oct 2012 13:45:48 GMT

Thank you Linlin. Worked perfectly. I appreciate your taking the time to respond.

Best,

Brian

topic Re: Compare file specification table to test data in SAS Programming

Compare file specification table to test data

Re: Compare file specification table to test data

Re: Compare file specification table to test data