|Date: ||Tue, 4 Jan 2005 09:24:30 -0800|
|Reply-To: ||JB <jinbtong@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||JB <jinbtong@GMAIL.COM>|
|Subject: ||Conversion of character month to numeric month|
|Content-Type: ||text/plain; charset="iso-8859-1"|
I have used PROC import to import a dataset in csv format. One of the
clumns in the dataset referes to the date of the record and is defined
as character variable in the original dataset. As a result, all the
dates read like '01JUL1993' and I had trouble applying SAS month and
year function directly to extract the month and year in numeric term.
I wonder if there is anyway I can extract from this variable the month
in numeric term.
Thanks a lot in advance.