Date: Tue, 28 Jul 1998 09:48:51 +0500
Reply-To: Bernard Tremblay <bernard@CAPITALE.QC.CA>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Bernard Tremblay <bernard@CAPITALE.QC.CA>
Subject: Re: SOME FUNCTIONS
Hi,
You need SAS 6.12 for this. Check the functions varnum, vartype in
the online help. They can be used exactly for this.
If you have an older version you can get the information from a
SQL select of "type" from dictionary.columns table...
Regards,
Bernard Tremblay
\\\|///
\\ - - //
( @ @ )
+------oOOo-(_)-oOOo----------+---------------------------------+
| Bernard Tremblay | |
| La Capitale | Tel: (418) 646-2401 |
| | Fax: (418) 646-5960 |
| | Int: bernard@capitale.qc.ca |
+-----------------------------+---------------------------------+
| Imaginasys enr | Res: (418) 658-1411 |
| | Int: bertrem@quebectel.com |
+---------------Oooo----------+---------------------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>>Date: Tue, 28 Jul 1998 09:21:40 -0400
>>>From: Jeremy Yuan <Jeremy_Yuan/Claritas@CLARITAS.COM>
>>>Subject: SOME FUNCTIONS
>>>
>>>IS THERE ANY FUNCTION OR METHOD TO TEST WHETHER A VARIABLE IS NUMERIC OR
>>>CHARACTER AT RUN TIME? LIKE:
>>>
>>>IF VAR1 = NUMERIC THAN X=PUT(VAR1);
>>>IF VAR2=CHARACTER THEN Y=INPUT(Y,5.2);
>>>
>>>WHICH FUNCTION CAN TEST WHETHER IT IS NUMERIC OR CHARACTER?
>>>
>>>YOUR HELP IS MUCH APPRECIATED.
>>>
>>>
>>>JEREMY
|