cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
PGStats
Opal | Level 21 PGStats
Opal | Level 21

Re: Alternate to sql using data step

Posted 08-09-2022 01:43 PM (305 views)  |   In reply to RAVI2000

Is usubjid a unique key in table adae?

 

Is usubjid a unique key in table adbmk?

 

Why is this a left join? The condition anl02fl="Y" will essentially transform it into an inner join.

PG
0 Likes
Reply
RAVI2000
Lapis Lazuli | Level 10 RAVI2000
Lapis Lazuli | Level 10

Re: Alternate to sql using data step

Posted 08-09-2022 01:47 PM (241 views)  |   In reply to PGStats
because I would like to see the subjects from left(adbmk) table alone. usubjid is the unique key for both the datasets.
0 Likes
Reply

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.

Watch How to Concatenate Values on YouTube

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
  • 16 replies
  • ‎08-09-2022 12:56 PM
  • 1097 views
  • 3 likes
  • 5 in conversation