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 (774 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 (710 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
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 16 replies
  • ‎08-09-2022 12:56 PM
  • 4365 views
  • 3 likes
  • 5 in conversation