convert numeric value to ddmmmyy:hh:mm:ss

Reply
Frequent Contributor
Posts: 77

convert numeric value to ddmmmyy:hh:mm:ss

The input numeric data comes in the form:

 

1826801215
1826801215
1826801215
1826801215
1826801215
1826801215
1826801215

 

I tried the following code without success:

 

data have;
	set have;
	date1 = Input( Put( date1, 10.), yymmdd10.);
	format date1 Date10.;
run;

Thanks for your help.

PROC Star
Posts: 7,791

Re: convert numeric value to ddmmmyy:hh:mm:ss

Sounds like you are looking for the datetime. format.

data have;
  input datetime;
  format datetime datetime.;
  cards;
1826801215
1826801215
1826801215
1826801215
1826801215
1826801215
1826801215
;

Art, CEO, AnalystFinder.com

 

PROC Star
Posts: 827

Re: convert numeric value to ddmmmyy:hh:mm:ss

is your req to "convert" using put function?

data have;
input date ;
datalines;
1826801215
1826801215
1826801215
1826801215
1826801215
1826801215
1826801215
;

data want;
set have;
_date=put(date,datetime.);
run;
Ask a Question
Discussion stats
  • 2 replies
  • 99 views
  • 1 like
  • 3 in conversation