topic Re: Substring for data in dataset and sql table in SAS Programming

Substring for data in dataset and sql table

imdickson — Wed, 14 Jun 2017 09:00:14 GMT

Hi Guys,

With the guides and helps from fellow members here, i now can have data from dictionary in dataset by using this code:

data want;
  set sashelp.vcolumn (where=(libname="CDSSTG"));

run;

However, i want to remove the first 5 character from this column called memname and also remove the last character.

I did read up some guides for substr but if i want to apply it for the entire column in a dataset, may i know if i need to use loop?

Need your guide.

RW9 — Wed, 14 Jun 2017 09:05:33 GMT

Like:

data want;
  set sashelp.vcolumn (where=(libname="CDSSTG"));
  memname=substr(memname,6,lengthn(tmp)-6);
run;

Ksharp — Wed, 14 Jun 2017 13:15:41 GMT

plz post it as text not picture, I don't want type it by hand.

And don't forget to post the output .

data _null_;
x='CSTG_XXXXX_ARERT';
y=prxchange('s/^[a-z]+_|[a-z]$//i',-1,strip(x));
put x= y=;
run;