What would be the SAS equivalent of the following SQL below?
libname testing "c:/res/IDB/testing";
proc sql;
create table work.temp as
select *
from testing.cr96to2004
where tapeyear>2002
outer union corresponding
from testing.cr2005on;
data temp;
set testing.cr96to2004(where=(tapeyear>2002)) testing.cr2005on;
run;
View solution in original post
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.