BookmarkSubscribeRSS Feed
Smitha9
Fluorite | Level 6

Dataset A:

ID       Episode

1          1000

2         3000

3        4000

4       5000

 

Dataset B:

ID  Episode

1      1000

2      2000

3      7000

5     9000

 

Proc Sql;

create table check as

select a.*,b.*

from datasetA as a on a.ID=b.ID and a.Episode=b.Episode

where b.ID-NULL and b.Episode=NULL

;

quit;

 

Please let me know the result and how it works. thank you in advance.

1 REPLY 1
Kurt_Bremser
Super User

Maxim 4. Try It.

Read the log, correct your mistakes, rinse, repeat.

 

First hint: b.* cannot work, as both variables are already coming from a.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

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