BookmarkSubscribeRSS Feed
paul2877
Calcite | Level 5

I have two data sets: January and February

 

I would like to know if the value apple is in the February Table based on multiple matching

 

January Table

 

Name  Event  Snack

Paul   Picnic   Apple

Paul   Picnic   Orange

Paul   Picnic  Grape

 

February Table

Name  Event  Snack

Paul   Picnic   Apple

Paul   Picnic   Bread

Paul   Picnic  Grape

 

The result I want is

 

Summary Table:

Name  Event  Snack Validation

Paul     Picnic  Apple    Yes

Paul     Picnic  Orange  No

Paul    Picni     Grape  Yes

 

I basically want to know if the snack is in the February table as well

1 REPLY 1
LinusH
Tourmaline | Level 20

Use SQL left join, and use CASE statement to see if there is a matching value from February table.

Data never sleeps

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 693 views
  • 0 likes
  • 2 in conversation