Hellow friends,
data
data test;
length usercation $ 200;
input usercation $ ;
cards;
PDF_STUDY_11225_15/12/2016
PDF_45896_12/05/2017_HTT
PDF_STUDY_CURVE
;
run;
I want to create a new variable which contains just the first carcaterial part of the variable usercation before the '_'
for example: PDF_STUDY_11225_15/12/2016 ->PDF_STUDY
PDF_45896_12/05/2017_HTT ->PDF
PDF_STUDY_CURVE -> PDF_STUDY_CURVE
In fact I would like automated processing for many lines.
Thank you very much for your help!
Please try
data test;
length usercation $ 200;
input usercation $ ;
cards;
PDF_STUDY_11225_15/12/2016
PDF_45896_12/05/2017_HTT
PDF_STUDY_CURVE
;
run;
data want;
set test;
if prxmatch('/_\d/',usercation)>0 then new=substr(usercation,1,prxmatch('/_\d/',usercation));
else new=usercation;
run;
Please try
data test;
length usercation $ 200;
input usercation $ ;
cards;
PDF_STUDY_11225_15/12/2016
PDF_45896_12/05/2017_HTT
PDF_STUDY_CURVE
;
run;
data want;
set test;
if prxmatch('/_\d/',usercation)>0 then new=substr(usercation,1,prxmatch('/_\d/',usercation));
else new=usercation;
run;
Thank you very much!
it works very well!
Minor correction to @Jagadishkatam's suggested code:
data want; set test; if prxmatch('/_\d/',usercation)>0 then new=substr(usercation,1,prxmatch('/_\d/',usercation)-1); else new=usercation; run;
Art, CEO, AnalystFinder.com
Thank you very much for correction!
it works very well!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.