"DePuy, Venita" <depuy001@DCRI.DUKE.EDU> wrote in message
> Hi all -
> not having any luck finding a concise way to change months (JAN, FEB, MAR)
> to numbers (1,2,3).
> What I have is month, day, year in 3 fields. So OCT, 15, 2003.
> numeric, numeric).
> I'm wanting to change the OCT to 10 so I can use the MDY function to
> a date out of it.
> The only method I've come up with (in spite of searching Online Docs &
> online in general) is a series of if/then statements . . if mon='JAN' then
> mon1=1; else if mon='FEB' then mon1=2; . . etc.
> Any thoughts?
> Either on a concise way to change months, or an equivalent function for
> that would take a 3-letter character variable for the month?
> Thanks much!
> Venita DePuy
> Statistician II, Center for Clinical and Genetic Economics
> Duke Clinical Research Institute
> (919) 668-8087