Date: Tue, 12 Apr 2005 16:03:31 -0400
Reply-To: Nathaniel_Wooding@DOM.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nat Wooding <Nathaniel_Wooding@DOM.COM>
Subject: Re: Data problem..
Content-Type: text/plain; charset="US-ASCII"
Kumar
Assuming that, as Rose suggested, the Ds indicate missing data (in anycase,
they are not valid numbers), you may specify
missing d ;
in your data step and this will tell SAS not to gripe if it encounters a
"number" with a d in it. Moreover, the value displayed will be the missing
value .d
(note the period in front of the d).
Try the following modification to your code.
Nat Wooding
Data y;
missing d ;
Input sysbp diabp pulse temp respire 7. subjid $3.
;
Cards;
88 55 53 D D . 118
83 50 67 D D . 118
85 50 57 D 36.4 118
88 55 80 D D . 118
90 52 67 D 36.3 118
85 46 63 D D . 118
D D D D D . 119
D D D D D . 119
D D D D D . 119
D D D D D . 118
D D D D D . 118
Run;
proc print data=y;
run;
"Sridhar, Kumar"
<nsridhar@MEDAREX To: SAS-L@LISTSERV.UGA.EDU
.COM> cc:
Sent by: "SAS(r) Subject: Re: Data problem..
Discussion"
<SAS-L@LISTSERV.U
GA.EDU>
04/12/05 03:38 PM
Please respond to
"Sridhar, Kumar"
Here's a sampling of the data I am dealing with.
Data x;
Input sysbp diabp pulse temp respire 7. subjid $3. ;
Cards;
88 55 53 D D . 118
83 50 67 D D . 118
85 50 57 D 36.4 118
88 55 80 D D . 118
90 52 67 D 36.3 118
85 46 63 D D . 118
D D D D D . 119
D D D D D . 119
D D D D D . 119
D D D D D . 118
D D D D D . 118
Run;
Thanks and regards
_________________________
Kumar Sridhar
Sr.Statistical Programmer
Medarex Inc.
Bloomsbury NJ
(908)479-2622
_________________________
-----------------------------------------
