Remove leading and trailing zeros from character field

[reneeharper]

I don't know how this happens. I can't reproduce the experience, so it is hard to debug.

I have been working with the Jive tech support staff.  They suggested that we verify the the post was opened as a question -- this one was. And that the person who is trying to mark it as helpful verify that they are actively logged in (refresh the page to make sure your log in hasn't expired).

The other option for @Csc to try is to select Reply on the answer they want to mark as correct.  It should also show up then.

I'd love to hear from you if either of these things work.

[help_me_i_dumb]

data want;
	set test;
	format z_char $5.;

	/* Remove leading */
	z_char=strip(put(input(strip(textchar), 5.), 5.));

	/* Remove trailing */
	P=findc(z_char, "0", 'K', -length(z_char)); 
	 if P then Y = substr(z_char, 1, P); 

run;