Help using Base SAS procedures

how to convert date with '-' to numeric

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

how to convert date with '-' to numeric

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!


Accepted Solutions
Solution
‎07-13-2015 04:13 PM
Super User
Posts: 19,815

Re: how to convert date with '-' to numeric

Posted in reply to michellel

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

View solution in original post


All Replies
Solution
‎07-13-2015 04:13 PM
Super User
Posts: 19,815

Re: how to convert date with '-' to numeric

Posted in reply to michellel

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

Contributor
Posts: 67

Re: how to convert date with '-' to numeric

it works! thanks so much!

Super User
Super User
Posts: 7,050

Re: how to convert date with '-' to numeric

Posted in reply to michellel

DATE11 works.

data xx;

  input x date11.;

  format x date9.;

  put x=;

cards;

23-jun-12

23jun12

23jun2012

;;;;

Super User
Posts: 10,028

Re: how to convert date with '-' to numeric

Posted in reply to michellel

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 

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 290 views
  • 0 likes
  • 4 in conversation