data AHDMYHIV.CustOrd2
.
.
.
merge AHDSAS.customer_dim(in=inC) work.order_fact(in=inO);
by customer_id;
if inC=1 and inO=1;
run;
Hi and welcome to the communities!
See here: IN= Dataset Option
The condition can be abbreviated to this:
if inC and inO;
Hi and welcome to the communities!
See here: IN= Dataset Option
The condition can be abbreviated to this:
if inC and inO;
For more about the IN= option, see the article "Where did it come from? Adding the source of each observation to a SAS data set." The article also discusses the INDSNAME= option on the SET statement, which can be a useful option to know about.
Nearly 200 sessions are now available on demand in the Innovate Hub.
Watch Now →SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.