topic Comparing two variables in SAS Programming

Comparing two variables

nrk1787db1 — Wed, 15 Feb 2017 11:35:57 GMT

I have two variables named MNEMONIC and Details. I need to compare values in these variables and find out if replacing Mnemonic with Details creates value.

I'm using COMPGED to compare these variables as below

GED_SCORE = COMPGED(UPCASE(STRIP(COMPRESS(MNEMONIC,' :_/\-'))) ,
UPCASE(STRIP(COMPRESS(DETAILS,' :_/\-')))) ;

And have written few conditions to remove records which doesnt fetch me any value if I replace MNEMONIC with Details

IF GED_SCORE = 0 THEN DELETE ;

IF GED_SCORE < 35 THEN DELETE ;

Could anyone please suggest better way of doing this ?

Sample Dataset: { Edited }

Mnemonic               Details
ABC:Test_Admin      All Britain Corp Test Admin User
ESPC                        East Special Port Center
Memo                      Memo by post
Green_Card_holder  Green Card Holder

Replacing Mnemonic with Details for 1st and 2nd records create high value ; For 3rd value provided is average and for last replace doesn't provide any value as it is the same words replaced by special characters.

There are about 2 millions of records and just for performance reasons I don't want to replace all of them. Hope this helps.

{ Edited }

Main reason for doing this fuzzy_logic is to save space.

Re: Comparing two variables

art297 — Tue, 14 Feb 2017 15:23:04 GMT

It would help if you provided an example dataset.

Art, CEO, AnalystFinder.com

Re: Comparing two variables

RW9 — Tue, 14 Feb 2017 15:24:45 GMT

Not sure what we can suggest, you haven't told us anything other than you have that line of code. If it works then good. I can certainly suggest not coding all in uppercase as it makes it virtually unreadable.

Re: Comparing two variables

nrk1787db1 — Tue, 14 Feb 2017 16:15:30 GMT

Thank you for your response, Tried giving a small 5 records dataset as example.

Re: Comparing two variables

art297 — Tue, 14 Feb 2017 16:52:53 GMT

What are you trying to accomplish? Are you trying to save space, combine similar "details", or something else?

Art, CEO, AnalystFinder.com