topic Re: Datetime format in SAS Studio

Datetime format

Vasu33 — Fri, 03 Nov 2017 10:15:41 GMT

How to reads the date time fields like 3/5/2017 12:00:00 AM from CSV file.?

Thanks in advance

RW9 — Fri, 03 Nov 2017 10:18:41 GMT

Use the appropriate informat:

GertNissen — Fri, 03 Nov 2017 12:21:50 GMT

Are you looking for something like

data input;

format date datetime.;

input date mdyampm21.2;

datalines;

3/5/2017 12:00:00 AM

;

run;

Vasu33 — Fri, 03 Nov 2017 12:28:35 GMT

Thanks very much.

But i have used MDYAMPM. and it seemed to work fine.

I would like to understand what is the difference between mdyampm21.2; & MDYAMPM.

Am i missing something here?

Thanks again.

Ksharp — Fri, 03 Nov 2017 12:52:56 GMT

data input;
format date datetime.;
input date anydtdtm32.;
datalines;
3/5/2017 12:00:00 AM
;
run;

GertNissen — Mon, 06 Nov 2017 12:53:17 GMT

It will depend on your format, as there are many ways to write date, time etc with or without different details..

default if MDYAMPM19.