LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (June 2006, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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?


Back to: Top of message | Previous page | Main SAS-L page