06-14-2017 05:00 AM
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.
06-14-2017 09:15 AM
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;