topic Re: convert numeric value to ddmmmyy:hh:mm:ss in SAS Programming

convert numeric value to ddmmmyy:hh:mm:ss

capam — Thu, 18 Jan 2018 19:51:49 GMT

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.

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

art297 — Thu, 18 Jan 2018 20:00:04 GMT

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

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

novinosrin — Thu, 18 Jan 2018 20:20:37 GMT

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;