Okay, definitely made some progress. Thanks for all the suggestions! Still having the issue of missing a month (i.e. no row of data) when begin_date is >14. What I want is for the previous month's data to carry forward so there are 12 months per year. I need some sort of code that says, if day >14, bump to next month AND carry forward previous month. Or something to that effect. Suggestions?   Here's my current code:   *Updated April 13, 2016; libname eitc 'C:\Users\tub68397\Desktop\Projects\Legal Datasets\Panel Datasets for Nick'; *Import Excel Data; PROC IMPORT OUT= work.eitc DATAFILE= "C:\Users\tub68397\Desktop\Projects\Legal Datasets\Panel Datasets for Nick\2_1_2016 EITC Data Stat.xlsx" DBMS=xlsx REPLACE; SHEET="2_1_2016 EITC Data"; GETNAMES=YES; RUN; *Extract Day, Month, Year & sort; data sort; set eitc; day = day(begin_date); month= month(begin_date); year= year(begin_date); run; proc sort data=sort; by day month year; run; *Panel Data by Month & Year, laws enacted on or after the 15th of the month, bump to subsequent month; data panel; set eitc; if day(begin_date) < 15 then begin_date=intnx('month',begin_date,0); else if day(begin_date) > 14 then begin_date=intnx('month',begin_date,1); do i=1 to intck('month',begin_date,end_date); mon_yr=cats(put(month(intnx('month',begin_date,i-1)),z2.),"-",put(year(intnx('month',begin_date,i-1)),z4.)); mon = 0; mon = substr(mon_yr,1, 2); yr = 0; yr = substr(mon_yr,4, 4); output; end; run; ... View more

Thanks! Last (hopefully!) wrinkle. I now have a missing month when it skips to following month for the 15th or later dates. So it will go from Jan to Mar (skip Feb). I would want the data to carry from Jan to Feb. Suggestions? ... View more

Okay, data look good now. I generally import data form Excel. How would I show data in the form of a data step? One other, related question, if I want to use a rule to assign month based on day, how would I incorporate that into the code I have? For example, if a law changed during the first 14 days of a month, I want to use the month already there in the Begin_Date. If the law changed on Day 15 or after, I want to change the month to the following month. So April 14, stay April. April 15th, change to May. Can that be done in the do loop? Thanks for all your help!! ... View more

Here's my code, with yours at the bottom:   libname eitc 'C:\Users\tub68397\Desktop\Projects\Legal Datasets\Panel Datasets for Nick'; *Import Excel Data; PROC IMPORT OUT= work.eitc DATAFILE= "C:\Users\tub68397\Desktop\Projects\Legal Datasets\Panel Datasets for Nick\2_1_2016 EITC Data Stat.xlsx" DBMS=xlsx REPLACE; SHEET="2_1_2016 EITC Data"; GETNAMES=YES; RUN; proc print data=eitc; run; *Extract Year, Month, Day from Begin Date & End Date; data date; set eitc; Start_Year = year(Begin_Date); End_Year = year(End_Date); Start_month = month(begin_date); end_month = month(end_date); Start_Day = day(Begin_date); End_day = day(end_date); if start_day>14 then new_month=start_month+1; else new_month=start_month; yearmon = start_year * 100 + new_month; format yearmon mmyys.; run; *Sort by State Year Month; proc sort data=date; by state start_year new_month; run; *Panel Data by year; data year; set date; by state; do year = start_year to end_year; output; end; run; data have (drop=i); set year; state="AK"; begin_date="01JAN1980"d; end_date="02Jan2016"d; do i=1 to intck('month',begin_date,end_date); mon_yr=cats(put(month(intnx('month',begin_date,i-1)),z2.),"-",put(year(intnx('month',begin_date,i-1)),z4.)); output; end; run; proc freq data=have; tables state; run;   ... View more

For some reason, it's only doing it for AZ. Do I need to add code? ... View more

Great, that worked for AZ! I have a dataset with all 50 states. Do I need to repeat the step for each state? ... View more

HAVE (State, Start_Date, End_Date) AK, 1/1/1980, 2/1/2016, AR, 1/1/1988, 12/31/1990,    WANT (State, Start_Date, End_Date, Mo_yearvar) AK, 1/1/1980, 2/1/2016, 1/1980 AK, 1/1/1980, 2/1/2016, 2/1980 AK, 1/1/1980, 2/1/2016, 3/1980 AK, 1/1/1980, 2/1/2016, 4/1980 AK, 1/1/1980, 2/1/2016, 5/1980 ... AR, 1/1/1988, 12/31/1990, 1/1/1988 AR, 1/1/1988, 12/31/1990, 2/1/1988 AR, 1/1/1988, 12/31/1990, 3/1/1988 AR, 1/1/1988, 12/31/1990, 4/1/1988 ... ... View more

I think so? 271 PROC PRODUCT_STATUS;RUN; For Base SAS Software ... Custom version information: 9.4_M2 Image version information: 9.04.01M2P072314 For SAS/STAT ... Custom version information: 13.2 For SAS/GRAPH ... Custom version information: 9.4_M2 For SAS/ETS ... Custom version information: 13.2 I tried to post data to the forum and it wasn't formatting correctly. I'll try again. ... View more

Hi Kurt, Thanks for your response. I tried that approach and also just ran your code and am getting the same result: it's showing me the months for which changes to data were reflected in changes to the start_date, but it's not creating rows for every month and carrying the data down until the next change. ... View more

Thanks for the quick reply! I'm not sure what you mean by showing test data in a datastep. Does the attached help?     ... View more