topic Re: how to convert date with '-' to numeric in SAS Procedures

how to convert date with '-' to numeric

michellel — Mon, 13 Jul 2015 20:10:34 GMT

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!

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

Reeza — Mon, 13 Jul 2015 20:13:49 GMT

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

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

michellel — Mon, 13 Jul 2015 20:28:37 GMT

it works! thanks so much!

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

Tom — Mon, 13 Jul 2015 20:37:00 GMT

DATE11 works.

data xx;

input x date11.;

format x date9.;

put x=;

cards;

23-jun-12

23jun12

23jun2012

;;;;

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

Ksharp — Tue, 14 Jul 2015 13:15:15 GMT

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;

56 data xx;

57 input x anydtdte11.;

58 format x date9.;

59 put x=;

60 cards;

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

66 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;