Prev: Unable to read Unicode file into SAS file - able to do after
Next: Problem when using the SAS/GRAPH Procedures: SGPLOT and SGPANEL
From: V V B on 19 Jan 2010 12:32
Hi All,

I'm trying to subset or keep data based on a date range. The data in the
table titled data one (below) includes the date range. The data in the
table titled two (below) represents the information I need to keep based
on the date range in table one.

If the date in table 'Data two' falls within the date range in table 'Data
one' I need to keep both lines.

I've listed examples of the data and the desired output.

Your help will be most appreciated as I just don't know how to code for
this situation.

I'm using PC SAS 9.1.3.

Thanks! Vivian

Data one:
input id $5. From_date date9. To_date date9. Type
$1.;

datalines;
12345 01Jan2009 05jan2009 I;
12345 06Mar2009 08Mar2009 I;
45678 01jun2009 10jun2009 I;
99899 28Jan2009 03feb2009 I;
99811 05May2009 29May2009 I;
44564 01apr2009 02apr2009 I;
12312 04dec2009 19dec2009 I;

Run;

Data two;
Input id $5. from_date date9. Type $1.;

datalines;

12345 04Jan2009 P;
12345 06jun2009 P;
12345 21dec2009 P;
45678 10jun2009 P;
45678 29may2009 P;
99899 15jan2009 P;
12312 06dec2009 P;
12312 03dec2009 P;
99811 01may2009 P;
99811 29may2009 P;
99811 03dec2009 P;
44564 01mar2009 P;
44564 15apr2009 P;
Run;

Desired output:

12345 01Jan2009 05jan2009 I;
12345 04Jan2009 P;
45678 01jun2009 10jun2009 I;
45678 10jun2009 P;
99811 05May2009 29May2009 I;
99811 29may2009 P;
12312 04dec2009 19dec2009 I
12312 06dec2009 P;
 | 
Pages: 1
Prev: Unable to read Unicode file into SAS file - able to do after
Next: Problem when using the SAS/GRAPH Procedures: SGPLOT and SGPANEL