BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8

when performing a inner join a where or On will yeild same results?

from  INDIV a , acct b ,char c,tads d

      where a.id=b.id and

      a.id=d.id and

    a.id1=d.id1

Idea is to get columns where there are common id's

1 REPLY 1
Reeza
Super User

A database professional’s best friend - The SAS Training Post

The above may be very helpful.

You can always get to where your going by more than one path, but some are faster than others Smiley Happy

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 944 views
  • 1 like
  • 2 in conversation