how to convert date with '-' to numeric

[michellel]

Hi,

I have a character variable for date, which shows like '23-JUN-12'. I was trying to convert this char variable into numeric, but could not do that. It seems that SAS does not have format for the date format like '23-JUN-12'. Could you let me know how to do? Thanks so much!

[Reeza · Accepted solution]

Remove the dashes and use date9? You can use compress function to remove the -

[michellel]

it works! thanks so much!

[Tom]

DATE11 works.

data xx;

  input x date11.;

  format x date9.;

  put x=;

cards;

23-jun-12

23jun12

23jun2012

;;;;

[Ksharp]

ANYDTDTE11 works.

Code: Program

data xx;
  input x anydtdte11.;
  format x date9.;
  put x=;
cards;
23-jun-12
23jun12
23jun2012
;;;;

---

Log: Program

Notes (2)

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

53 

54 

55 

56 data xx;

57 input x anydtdte11.;

58 format x date9.;

59 put x=;

60 cards;

x=23JUN2012

x=23JUN2012

x=23JUN2012

NOTE: DATA statement used (Total process time):

  real time 0.84 seconds

64 ;;;;

NOTE: The data set WORK.XX has 3 observations and 1 variables.

  cpu time 0.58 seconds

65 

66 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

76