| Date: | Tue, 10 Jun 2008 15:34:19 -0700 |
|---|
| Reply-To: | "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV> |
|---|
| Subject: | Re: How to get the number of days between two dates |
|---|
| In-Reply-To: | <29306269-5f76-4334-95ed-586ad63d4adf@8g2000hse.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=iso-8859-1 |
|---|
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of cwgmath
> Sent: Tuesday, June 10, 2008 3:05 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: How to get the number of days between two dates
>
> I am working with a date set where I have an entry date and an exit
> date. I need to determine the number of days within those two dates.
> For example an entry date is 9/29/2000 and an exit date is
> 10/17/2000. Any help would be of great benefit. Thank you in advance
> for you assistance.
>
> Chris
>
Chris,
If your dates are stored as numeric SAS dates, it is as simple as
Days = exit_date - entry_date;
If your dates are held as character variables, then you just need to convert the variables to SAS dates using the input function.
Data want;
entry_date_c = '9/29/2000';
exit_date_c = '10/17/2000';
entry_date = input(entry_date_c,mmddyy10.);
exit_date = input(exit_date_c,mmddyy10.);
days = exit_date - entry_date;
Run;
Hope this is helpful,
Dan
Daniel J. Nordlund
Washington State Department of Social and Health Services
Planning, Performance, and Accountability
Research and Data Analysis Division
Olympia, WA 98504-5204
|
