Date: Mon, 15 May 2000 15:41:25 +0100
Reply-To: peter.crawford@DB.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Peter Crawford <peter.crawford@DB.COM>
Subject: Date variables and non-relevant cases
Content-type: text/plain; charset=us-ascii
sounds like the proper use for "special missing value" and user informat....
When converting from the "outside" into the "SAS System World" use a user informat to interpret these special cases. Such a user informat may be created with code like
proc format;
invalue ourdat
'99.99.9999' = .R /* not Recorded */
'09.09.9999' = .A /* not Available */
other = [ddmmyy10.] /* any other input */
;
run;
Then, instead of using informat DDMMYY10. use informat OURDAT10.
Documented in "the brown book"
aka Technical Report 222 changes and enhancements v6.07
Good luck
Peter Crawford
Datum: 15.05.2000 15:06
An: SAS-L@listserv.uga.edu
Antwort an: PapanikolaouP@cardiff.ac.uk
Betreff: Date variables and non-relevant cases
Nachrichtentext:
Dear All,
I have 1 variables which take on date values. This does not however
occur for the entire domain of the variables. That is, there are some
values which need to be given special numerical values such as 99 for
Non Recorded and 9 for Non-Available. I am wondering how could i do
this? That is, do i need to provide any specific SAS commands to have
SAS understand that 99 (9) means Non-Recorded (Non-Available) and
thus distinguishing between these values and the standard date-
values?
I would appreciate your comments. Thank you very much indeed for your
time. I look forward to hearing from you.
Yours Sincerely
Panos
Panos Papanikolaou
*********************
Research Fellow
Nursing, Health and Social Care Research Centre
SONWS
UWCM
Heath Park
Cardiff
CF14 4XN
Great Britain
E-mail: papanikolaoup@cf.ac.uk
Direct line: +44 (0)29 2074 2197
Fax: +44 (0)29 2074 5521