You can do the cartesian crossing via a hash object in a data step:
data want;
set sashelp.rent days_1 (obs=0);
if _n_=1 then do;
declare hash h (dataset:'days_1',ordered:'a');
h.definekey('date');
h.definedata(all:'Y');
h.definedone();
declare hiter hi ('h');
end;
do while (hi.next()=0);
output;
end;
run;
This loads DAYS_1 into the hash object (think lookup table) named h, and stores it in ascending order by DAY (even if the original dataset was not sorted). This takes place during the first iteration of the data step ("if _n_=1"). The hash object is "retained" for all susequent iterations.
Then for each obs in sashelp.rent, the program uses the hash iterator hi to step through (i.e. retrieve) every dataitem (think "row") in h, and outputs it.
The reason I used "obs=0" in the SET statement for the days_1 dataset is to force SAS to make provision for all the variables in days_1 in the program data vector (the hash object declare statement won't suffice). But not to actually read in the data (which IS done in the declare statement).
... View more
