## Computation using SAS

Solved
Super Contributor
Posts: 324

# Computation using SAS

Hello-

I wish to compute length of stay for each observation by subtracting ADT_IN from ADR_OUT.

 ADT_IN ADT_OUT 2/9/2017 19:50 2/10/2017 14:21 2/8/2017 17:50 2/10/2017 12:40 2/7/2017 11:43 2/9/2017 12:50 2/8/2017 12:56 2/11/2017 0:42 2/8/2017 12:56 2/11/2017 0:42 2/8/2017 12:56 2/11/2017 0:42 2/8/2017 12:56 2/11/2017 0:42 2/8/2017 12:56 2/11/2017 0:42 2/8/2017 12:56 2/11/2017 0:42

Accepted Solutions
Solution
2 weeks ago
Occasional Contributor
Posts: 6

## Re: Computation using SAS

[ Edited ]

``````data have;
cards;
2/9/2017 19:50 2/10/2017 14:21
2/8/2017 17:50 2/10/2017 12:40
2/7/2017 11:43 2/9/2017 12:50
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
;

data want;
set have;
/* This code doesn't take into account whether or not adding 1 to the result. */
run;``````

All Replies
Super Contributor
Posts: 324

## Computation using SAS

Hello-

I wish to compute length of stay for each observation by subtracting ADT_IN from ADR_OUT.

data;

Cards;

2/9/2017 19:50   2/10/2017 14:21

2/8/2017 17:50  2/10/2017 12:40

;

run;

Each that has an associated time to it.

Super User
Posts: 23,237

## Re: Computation using SAS

[ Edited ]

I've merged your two posts since they're the same. What have you tried so far? Post any code that you've attempted to date.

Hint, try INTCK and/or direct subtraction.

There's a tutorial on dates and times here:

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/...

Edit: Unfortunately your data step appears incorrect, instructions on posting data is here.

71 data;
73 Cards;

NOTE: Invalid data for ADT_IN in line 74 1-8.
NOTE: Invalid data for ADT_OUT in line 74 10-14.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
74 2/9/2017 19:50 2/10/2017 14:21
NOTE: Invalid data for ADT_IN in line 75 1-8.
NOTE: Invalid data for ADT_OUT in line 75 10-14.
75 2/8/2017 17:50 2/10/2017 12:40
Super Contributor
Posts: 324

## Re: Computation using SAS

Thank you. I didnt meant to post it twice. The first was showing error messages when pasted

Solution
2 weeks ago
Occasional Contributor
Posts: 6

## Re: Computation using SAS

[ Edited ]

``````data have;
cards;
2/9/2017 19:50 2/10/2017 14:21
2/8/2017 17:50 2/10/2017 12:40
2/7/2017 11:43 2/9/2017 12:50
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
2/8/2017 12:56 2/11/2017 0:42
;

data want;
set have;
/* This code doesn't take into account whether or not adding 1 to the result. */
run;``````

Super Contributor
Posts: 324

## Re: Computation using SAS

Thank you!

Occasional Contributor
Posts: 6

[ Edited ]