A more normal data structure might look something like this (presuming SOC is the unique key): SOC_Dim SOC SOC_Description Feature_Code Product_Type SOC_Fact SOC Business_Date Rate You would need to insert new products records into SOC_DIM each month and all records into the fact table: proc sql; create table work.soc_new as select      t1.SOC      t1.SOC_Description      t1.Feature_Code      t1.Product_Type from      NewData t1      left outer join work.soc_dim t2      on t1.soc=t2.soc where      t2.soc is null; insert into soc_dim (      SOC      SOC_Description      Feature_Code      Product_Type) select      SOC      SOC_Description      Feature_Code      Product_Type     from work.soc_new; insert into SOC_FACT (      soc,      business_Date,      rate) select      soc,      business_date, /*not sure where the date actually comes from*/      rate from      work.new_data; quit; Then, it's a fairly straightforward question to use in queries/views: proc sql; select      t1.*,      t2.rate as Rate_20141231 from      soc_dim t1      left outer join (select * from soc_dim where business_Date='31dec2014'd) t2           on t1.soc=t2.soc ; quit; ... View more

If you have a variable that represents a date of information, effective date or date collected or however you may think of it, in your master data set you can always select subsets of data based on that variable with data set option where data want;      set have (where = ( '01NOV2014'd le DateOfInformation le '31DEC2014'd); run; for example. You could use the above approach to test what a change to a report would look like for prior data or possibly if their became a request to compare quarters. You can get summaries over many different time periods using a formatted value of the date variable without having to create new variables. Suppose you want to examine the maximum and minimum of the billing rate for each product over time at quarterly intervals: Proc means data=have max min; class product DateOfInformation; var Billingrate; format DateOfINformation YYQ6.; run; Same information for yearly intervals: Proc means data=have max min; class product DateOfInformation; var Billingrate; format DateOfINformation Year4.; run; Or a review of the monthly: Proc means data=have max min; class product DateOfInformation; var Billingrate; format DateOfINformation YYMM6.; run; ... View more

Thank you, that's help me a great deal. ... View more