Hi all,   When i use the index function to parse the following texts to yield "BAN", both the records are getting a hit, whereas it should ideally be only the first.  Also, is there a way to specify the code to look for the word BAN after two underscores?   I'm using: a=index(TYPE,"BAN");   TYPE abcde_DT_BAN_OO_3MORE_LIF_CPM_728x90_abcde xyz_ab_RMBAN_PR_BHV_NOGEN_DCPM_160x600_uvwxyz   Thanks.     ... View more

Hi there, I'm new to SAS EG and am having trouble working with it. I cannot create SAS datasets from EG as SAS is not installed locally. When I import a CSV file into EG and try to filter on the variables, it gives me an ERROR saying that the file WORK.XXX does not exist. What do I have to do to be able to be able to filter on a variable in this dataset and create a new one with reduced variables? Thank you. ... View more

Hi, This follows from a question I'd posted earlier. My data looks like this, each person's purchase of a particular product at a given year...and his/her marital status over the years (Married or Divorced). I need a single column that will give me the marital status according to year of purchase. So for person 1, the STATUS should be Married, person 2 Married, person 3 Divorced etc. How can I get at this? Person Year of purchase M_2009 M_2010 M_2011 M_2012 D_2009 D_2010 D_2011 D_2012 STATUS 1 2009 1 1 0 0 0 0 1 1 Married 2 2012 1 1 1 1 0 0 0 0 Married 3 2012 0 1 Divorced 4 2011 1 0 0 1 5 2009 0 0 0 0 1 1 1 1 6 2010 0 0 0 1 1 1 7 2011 1 1 0 0 Thanks! ... View more

Hi, I'm trying to assign a marital status to different individuals looking at their history over the last few years (survey data). I'm only interested in those whose status have remained same all along. So the first individual, was married the first two years and divorced later...and gets dropped out. Individual 3 gets a status because he entered the survey in 2012...etc. Person M_2009 M_2010 M_2011 M_2012 D_2009 D_2010 D_2011 D_2012 STATUS 1 1 1 0 0 0 0 1 1 NA 2 1 1 1 1 0 0 0 0 Married 3 1 1 Married 4 1 0 0 1 NA 5 0 0 0 0 1 1 1 1 Divorced 6 0 0 0 1 1 1 Divorced 7 1 1 0 0 Married How do I get at this quickly? I tried some clauses in the data steps, but cannot seem to include every possible combination. I have several thousand records. Thanks in advance! ... View more

Hi, I'm trying to write a code that will calculate ages of all members of a family (MEM1 to MEM7) from their dob. My data looks like this FAMILY MEM1 MEM2 MEM3 MEM4 MEM5 MEM6 MEM7 001 2/1/1941 9/1/2000 2/1/2004 . . . . 002 6/1/1989 . . . . . . 003 8/1/1963 8/1/1963 . . . . . 004 9/1/1994 6/1/2000 . . . . . When I run the following code, it says MEMi variable is uninitialized. Please help. data a; set b ; array age {7} age1-age7; array age_mem {7} age_mem1-age_mem7; do i=1 to 7; age(i)=floor( (intck('month', MEM(i), '01jan2013'd) -(day('01jan2013'd) < day(MEM(i))))/12); age_mem(i)= age(i)-(floor( (intck('month', MEM(i), '01jan2013'd) -(day('01jan2013'd) < min(day(MEM(i)), day(intnx('month','01jan2013'd,1) -1)))/12))); output; end; run; Thanks! ... View more