02-14-2014 04:50 PM
I feel like i'm stuck on something so simple, and I just dont know why...
I have 2 data sets
... 800,000 records
.. (365 days)
I would like to create a table that merges the two, where date is repeated across all FSALDU's
... (800,000*365=292M records)
Your help greatly appreciated, thanks in advance.
02-14-2014 05:06 PM
create table want as
from name_of_dataset_with_fsaldu_goes_Here join name_of_date_table;
You'll get a message in the log about a full cartesian join and it will take some time.
But another option would be:
do date = '01JAN2013'd to '31DEC2013'd;
format date yymmdd10.;
might be quicker. Also when you need to modify the process to incude a leap year SAS does that because it knows which years, or at least for the next 10,000 or so, which will need a leap day and you needn't build a new dates data set.