|
Dear Momo,
I can only help you partially. You state "&sysdate9."d . &sysdate9
represents today's date (as the textual value of the automatic macro
variable) and the d descriptor converts it a numeric date value. Dates
internally are just numbers. Formats only are applied when printing. SAS
counts the date as the number of days since 01Jan1960; so 01Jan1961 would
have the value 366 (1960 is a leap year). It is very much the question
whether Lotus Notes uses the same data definition. If not, then a
transformation (in days) has to be performed to reobtain synchroneousness. [
E.g. JMP, a SAS related product uses the reference date 01Jan1970; very
confusing. ] Maybe you could read the date as text instead and then use some
appropriate SAS function to convert to a date value and associate a date
format.
Furthemore, when stating "&sysdate9."d , this results in "04FEB2002."d . SAS
can not convert this to the equivalent date value, as the period inside the
character value does not apply and disturbs the conversion; you have to
remove the period, any format specification does not apply here.
HTH a little.
Regards - Jim.
--
Y. (Jim) Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070
senior statistician, P.O. Box 1 fax. +31 412 407 080
senior data manager 5350 AA BERGHEM IMRO TRAMARKO: a CRO
J.Groeneveld@ITGroups.com the Netherlands in clinical research
My computer has no idea what I am doing; sometimes the reverse also applies.
Notice of confidentiality: this e-mail may contain confidential information
intended for the addressed recipient only.
If you have received this e-mail in error please delete this e-mail and
please notify the sender so that proper delivery
can be arranged.
> -----Original Message-----
> From: momozeus [SMTP:momozeus@YAHOO.COM.CN]
> Sent: Monday, February 04, 2002 9:35 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: A TIME PROBLEM ON READING DATA FROM NOTES
>
> As I know, if I want to read data from Lotus Notes Database, I can use
> odbc
> ,
> but a time proble confuse me . I problem is as follows:
> If I want to read data from Notes, and it's not wise to read all data from
> Notes,
> so I use where condition in a data step, the code is like that:
>
> data work.a;
> set notes.b;
> where date1="&sysdate9."d;/*suppose there is a
> date1 varible which format is date9. in data set
> notes.b*/
> run;/*suppose notes is the library notes database set through odbc*/
>
> While I run , the error accurs as the follows:
> ERROR: CLI column bind error: [Lotus][ODBC Lotus Notes]Invalid
> argument value.
>
> If I run this:
> data work.a;
> set notes.b;
> run;
> All is ok.
>
> I don't know here where anyone encouter this problem ,and how to solve it.
> Any advice is welcome.
> Thanks.
> momo
| 
