topic Re: Extracting word in SAS Programming

Extracting word

KalaBhairava — Wed, 29 Aug 2018 11:29:17 GMT

how to extract AM ,PM from time format Eg:1:40:00 PM

Kurt_Bremser — Wed, 29 Aug 2018 11:49:26 GMT

Please supply example data in a data step with datalines, so we can see variable types, formats and values, and use it for testing.

PeterClemmensen — Wed, 29 Aug 2018 11:49:41 GMT

Is the value 1:40:00 PM extracted from a character variable or an actual SAS time variable?

Please be more specific in your requirements

Ksharp — Wed, 29 Aug 2018 11:51:32 GMT

data have;
x='19:20:21't;
format x timeampm.;
run;

data want;
 set have;
 want=scan(vvalue(x),-1);
run;

KalaBhairava — Wed, 29 Aug 2018 12:13:32 GMT

it is in time format (timeampm11.)