| 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> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Conversion of character month to numeric month |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Hi,
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.
JB
|
