topic Re: SAS Query in SAS Programming

SAS Query

scb — Fri, 11 Nov 2016 22:37:45 GMT

I have 2 datasets;

dataset a

Name Age

John 70

Apple 67

June 67

Ewan 43

dataset b

Location

London

What is the fastest way to get this result? Anyone can help? Thanks.

Name Age Location

John 70 London

Apple 67 London

June 67 London

Ewan 43 London

LinusH — Fri, 11 Nov 2016 22:40:15 GMT

Cartesian SQL join.

Astounding — Fri, 11 Nov 2016 23:47:46 GMT

Fastest to program? Fastest to execute? Fastest to explain how it works?

Here's one way:

data want;

if _n_=1 then set b;

set a;

run;

The full Cartesian product (already suggested) is a short program as well:

proc sql;

create table want as select * from a, b;

quit;

You can test them on larger data sets and let us know which one is faster.