Hi everyone, I am trying to create a before and after specific date based on month and days on two/four other dates depending on a frequency variable. Here is an example of my date:   transac_date freq first_date second_date third_date fourth_date 20150102 2 20190430 20191030 . 20100302 2 20190430 20191030 . 20121102 2 20190430 20191030 . 20020716 4 20250228 20250531 20250831 20021211 4 20250228 20250531 20250831 20030108 4 20250228 20250531 20250831 What I need looks like this: transac_date freq first_date second_date third_date fourth_date before_tran_date after_trans_date 20150102 2 20190430 20191030 . . 20141030 20150430 20100302 2 20190430 20191030 . . 20091030 20100430 20121102 2 20190430 20191030 . . 20121030 20130430 20020716 4 20250228 20250531 20250831 20251130 20020531 20020831 20121211 4 20250228 20250531 20250831 20251130 20121130 20130228 20030108 4 20250228 20250531 20250831 20251130 20021130 20030228 Any help is greatly appreciated! ... View more

Hi everyone,   I am very new to the array function so I apologize in advance if my question sounds silly. Is there a way to specify the number of observations in arrays through a list? I am trying to use the following code from @hashman and create 100 views from a huge dataset. I was wondering if there is a way to specify the list of percentages instead listing (5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5). data _null_ ; array pct p1-p20 (5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5) ; lo = 1 ; do over pct ; cpct + pct ; hi = ceil (cpct * divide (n, 100)) ; call execute (catx (" ", cats ("data v", _i_), "/", cats ("view=v", _i_), ";")) ; call execute (catx (" ", "set have (firstobs=", lo, "obs=", hi, ") ;")) ; call execute ("run ;") ; lo = hi + 1 ; end ; stop ; set have nobs = n ; run ;     Thank you! ... View more

Hi everyone,   I am trying to run a proc sql for 100 datasets and was wondering if it is possible to use a do loop instead of writing the same code 100 times. here is my proc sql:   proc sql; create table new&i as select distinct a.*,b.date, b.date2, b.x, b.y, b.z from v&i a, &data b where abs(intck('day',a.date,b.date))<=29 group by a.id, a.date having abs(a.date2-b.date2) eq min(abs(a.date2-b.date2)) ; quit; Any help is greatly appreciated!   ... View more

Hi everyone,   I want to add column Y from table B to table A if, for each ID, the values in column Y are right after or before the values of column X in table A.   table A: ID    X 1     9 2     6 3   11   table B: ID    Y 1     4 1     3 1     7 1     11 1     16 2     1 2     8 2     5 2     9 3   7 3   9 3   14 3   13   What I need: ID    X     Y 1     9     7 1     9    11 2     6     5 2     6     8 3   11     9 3   11     13     Thank you! ... View more

Hi everyone, This seems like a simple problem but I can't figure it out. I want to repeat rows between two years by group.  here is a sample of my data: data have; input id name $ role $ year1 year2; datalines; 1 Jon CEO 2000 2004 2 Mike President 2006 2008 3 George Advisor 2010 2010 ; And here is what I am looking for. id name role year1 year2 year3 1 Jon CEO 2000 2004  2000 1 Jon CEO 2000 2004  2001 1 Jon CEO 2000 2004  2002 1 Jon CEO 2000 2004  2003 1 Jon CEO 2000 2004  2004 2 Mike President 2006 2008  2006 2 Mike President 2006 2008  2007 2 Mike President 2006 2008  2008 3 George Advisor 2010 2010  2010   Thank you! ... View more