HI All,
I have data as below. I wanted to remove space before a string(/).
Raw data:
subjid Term
101 Inclusion / Exclusion Criteria
Output DAtaset:
subjid Term
101 Inclusion/Exclusion Criteria
So which function i should use to remove space before '/' string and after string '/'. please provide your inputs.TIA
@mounikag wrote:
HI All,
I have data as below. I wanted to remove space before a string(/).
Raw data:
subjid Term
101 Inclusion / Exclusion Criteria
Output DAtaset:
subjid Term
101 Inclusion/Exclusion Criteria
So which function i should use to remove space before '/' string and after string '/'. please provide your inputs.TIA
One way is to use the TRANWRD function to replace the string " / " with just a "/".
data example; x = "Inclusion / Exclusion Criteria"; y = tranwrd(x,' / ','/'); put y=; run;
@mounikag wrote:
HI All,
I have data as below. I wanted to remove space before a string(/).
Raw data:
subjid Term
101 Inclusion / Exclusion Criteria
Output DAtaset:
subjid Term
101 Inclusion/Exclusion Criteria
So which function i should use to remove space before '/' string and after string '/'. please provide your inputs.TIA
One way is to use the TRANWRD function to replace the string " / " with just a "/".
data example; x = "Inclusion / Exclusion Criteria"; y = tranwrd(x,' / ','/'); put y=; run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.