topic Re: Cut off part of string in SAS Programming

Cut off part of string

PatrykSAS — Mon, 21 Jun 2021 09:37:01 GMT

Hello,

how can I cut off part of sting like in below example:

VAR

USE_01

USE_12

USE_03

I want to keep only numbers without "0" -> so result should be 1,12,3

How can I achieve this?

tdswart — Mon, 21 Jun 2021 10:46:09 GMT

Hello,

You could fix this with a data step and tranwrd. Below you can see an example (with example dataset) that gives the result you want in 2 steps.

data work.sastest;
input VAR1 $char6.;
format VAR1 char6.;
datalines ;
USE_01
USE_12
USE_03
;
run;

data work.sastest2;
set work.sastest;
VAR2= tranwrd(VAR1,'USE_','');
VAR3= tranwrd(VAR2,'0','');
run;

Hope this helps you!

PaigeMiller — Mon, 21 Jun 2021 10:48:46 GMT

I want to keep only numbers without "0" -> so result should be 1,12,3

It's really hard to generalize from such a small example. So let me ask a few questions

Are the first four characters always USE_ or can they be something else?
Is there always an underscore?
What would you do about USE_10, the above statement seems to indicate you don't want it because it has a zero

PatrykSAS — Mon, 21 Jun 2021 11:06:20 GMT

Hi PaigeMiller,
Yes its always pattern USE_ with underscore
If its USE_10 I'd keep number 10

PaigeMiller — Mon, 21 Jun 2021 11:12:03 GMT

data want;
    set have;
    part_of_string = input(scan(var,2,'_'),3.);
run;