| Date: | Tue, 6 May 2008 12:19:48 -0700 |
|---|
| Reply-To: | nia <sanvi_shinde@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | nia <sanvi_shinde@YAHOO.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | checking order of variable values |
|---|
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Hi All,
I have a sas dataset having variable ID, VISIT and DATE(mmddyy). I
want to check weather the visit number and date are in chronological
order for each id. I would like to select/find the ids not having
visit number or date in ascending order. (e.g. id 103). can anybody
help me with this one?
Thanks,
Nia
ID VISIT DATE
100 2 01/10/04
100 3 01/20/04
100 4 02/10/04
101 2 01/05/04
101 3 01/15/04
102 2 01/08/04
102 3 01/18/04
102 4 01/28/04
102 5 02/01/04
103 2 01/27/04
103 3 01/07/04
|
