| Date: | Fri, 2 Jun 2006 10:15:34 -0400 |
| Reply-To: | Rathindronath <mehedisas@YAHOO.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Rathindronath <mehedisas@YAHOO.COM> |
| Subject: | First.Variable |
|---|
I have a dataset like the following:
sasname patinet reldays diap Lvacl
QTC 000152 1 Day 1, HR 1 83
QT 000151 2 Dat2 74
HTRATE 000751 1 Day 1, HR 0 75
HTRATE 000751 2 Day 1, HR 0 79
I need a dataset as follow:
sasname patinet reldays diap Lvacl
QTC 000152 1 Day 1, HR 1 83
QT 000151 2 Dat2 74
HTRATE 000751 1 Day 1, HR 0 75
Note: when valus for all the variables (Other than the variable Reldays)
are same
for two or More observations The observation with the value of 2 for the
the variable
Relday will be deleted.
I tried the following way, But sure it is not working:
Proc sort data = ECG;
BY patient sasname dai relday;
Run;
Data ECG;
Set ECG;
BY patient sasname dai relday;
If first.relday = 1;
Run;
Can anyone be kind enough to help me out this?
|