dataset 1: ID DATE 1 10/13/2010 1 10/20/2010 1 10/27/2010 1 11/3/2010 2 1/31/2011 2 1/31/2011 2 2/2/2011 2 2/7/2011 2 2/7/2011 3 7/26/2011 3 7/26/2011 3 7/28/2011 3 8/1/2011 3 8/2/2011 3 8/2/2011 3 8/4/2011 3 8/8/2011 3 8/9/2011   dataset 2: ID Count start  end 1 1 10/18/2010 10/18/2010 2 1 2/1/2011 2/6/2011 3 1 7/27/2011 7/27/2011 3 3 8/2/2011     want: ID DATE Count 1 10/13/2010   1 10/20/2010   1 10/27/2010   1 11/3/2010   2 1/31/2011   2 1/31/2011   2 2/2/2011 1 2 2/7/2011   2 2/7/2011   3 7/26/2011   3 7/26/2011   3 7/28/2011   3 8/1/2011   3 8/2/2011 3 3 8/2/2011 3 3 8/4/2011 3 3 8/8/2011 3 3 8/9/2011 3   I want to merge the dataset1 and dataset2 by id and date, if the date in dataset1 falls in between start and end date of dataset2. in case if the end date is missing in the dataset2 then the count value should be retained across the rest of the observations in dataset1. Any help to achieve this in sas? Thanks ... View more

Have:  ID Day R 1     1     1 Day 1   1 Day 2 run 0 1     1     1     1     1 Day1 run 1 1     1 Day2 run2 1     1       Want: ID Day R 1     1     1 Day 1   1 Day 2 run 0 1   run 0 1   run 0 1   run 0 1   run 0 1 Day1 run 1 1   run 1 1 Day2 run2 1   run2 1   run2   I want to retain the value of R based on the value of Day (R value carried forward until the next Day ). Any help to achieve this using the retain function?   Thanks, ... View more

I am wondering if its possible convert an excel file with multiple sheets in it  to .xpt format. I could not find any information online. Any leads about the convertion from excel (with multiple sheets) to xpt format?  ... View more

I am trying to read a date column in sas from csv file but it gives some error:   error: NOTE: Invalid argument to function INPUT at line 2134 column 11   Appreciate  any help to resolve this issue. Thanks   data: have: id   date 1    27-Apr-12 2    03APR2013 3    11-Mar-13 4   01-Jun-12 my code: data want; set have; format date date9.; date=upcase(date); if not missing(date) then do; lbdt=input(date, ddmmyy9.); end; run;   ... View more

Hi,   I am trying new variables by looking across the different variables (columns) in a row (observation). have: id a b c 1 2 2 1 2 3 1 0 3 1 0 0 4 1 2 3 5 3 2 1   want:   id a b c g1 g2 g3 1 2 2 1 1 1 0 2 3 1 0 1 0 1 3 1 0 0 1 0 0 4 1 2 3 1 1 1 5 3 2 1 1 1 1   If the first row (from a to c) contains value 1 then  g1 will be set to 1 else 0.  if  the 1st row (from a to c) contains value 2 then g2 set to 1 else 0 and so on.    Any help to prepare this dataset in sas?   Thanks. ... View more