topic extract year from a character variable in SAS Programming

extract year from a character variable

gzr2mz39 — Wed, 16 Oct 2013 17:05:18 GMT

I have a character variable with the following data:
9/6/2013 11:16:13 AM
8/2/1994 4:18:06 PM
11/15/1995 3:54:36 PM

How would I go about extracting the four-digit year (eg 2013)?

Thank you.

Reeza — Wed, 16 Oct 2013 17:10:26 GMT

Try using the scan function with a space and / as delimiter.

year=scan(var, 3, "/", 's');

Documentation on the SCAN function is here:

Haikuo — Wed, 16 Oct 2013 17:22:24 GMT

Or try this:

data _null_;

input var$40.;

year=year(input(var,ANYDTDTE32.));

put year=;

cards;

9/6/2013 11:16:13 AM

8/2/1994 4:18:06 PM

11/15/1995 3:54:36 PM

;

Haikuo