topic Re: remove last 3 characters in SAS Programming

remove last 3 characters

gzr2mz39 — Tue, 21 Jun 2011 18:56:23 GMT

I want to remove the last 3 characters (i.e. :00) from a variable.
For example, how do I change these 3 observations:
8:00:00
7:45:00
10:00:00

to this format
8:00
7:45
10:00

Thank you.

Re: remove last 3 characters

p12937 — Tue, 21 Jun 2011 19:31:47 GMT

Here are a few options:
data t;
infile cards;
input t $8.;
length solution1 solution2 solution3 $5.;
solution1=scan(t,1,':')||':'||scan(t,2,':');
solution2=put(input(t,time8.),time5.);
solution3=reverse(substr(reverse(trim(left(t))),4));
cards;
8:00:00
7:45:00
10:00:00
;

Re: remove last 3 characters

Ksharp — Wed, 22 Jun 2011 01:32:26 GMT

What type is your variable? Numeric or Character?
[pre]

data t;
infile cards;
input t $8.;
time=put(input(t,time8.),hhmm5.);
cards;
8:00:00
7:45:00
10:00:00
;
run;
[/pre]

Ksharp

Re: remove last 3 characters

gzr2mz39 — Wed, 22 Jun 2011 15:57:33 GMT

Numeric.
Your response and p12937's response were very helpful.
Thank you.

Re: remove last 3 characters

Patrick — Thu, 23 Jun 2011 01:40:26 GMT

Hi

If the type is numeric then assigning another format like Ksharp showed would do:

format time hhmm5.;

HTH
Patrick