cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Alexxxxxxx
Pyrite | Level 9 Alexxxxxxx
Pyrite | Level 9
Go to Solution

find strings between (),[],{},' '," " and split them in new variables

Posted 03-18-2019 12:10 PM (1625 views)

Dear all,

 

How can I find all strings between (),[],and {} (such as <BR>, [FONT],{BODY},'A',"JUICE") and split them in a new variable?

 

Especially, for the 

'JUICE<BR>apple<footer>',I expect to add a blank between 'JUICE' and 'apple'

 

by using the following code,


data have ;
  infile datalines truncover;
  input name $100.;
  datalines;JUICE<BR>apple[footer] 
juice <BR> apple 
juice<BODY> 'apple' 
juice{BODY} apple 
[BR]juice apple
<figure> "juice" LTD
 ;
run;

data want1;
   set have;
   RegExID = prxparse('/<\w*>/');
   start=1;
   call prxnext(RegExID, start, length(name), name, pos, length);
      do while (pos > 0);
         html = substr(name, pos, length);
         newname=prxchange('s/<\w*>//', -1, name);
         output;
         call prxnext(RegExID, start, length(name), name, pos, length);
      end;
   keep name html newname;
run;

I get 

namehtmlnewname
JUICE<BR>apple<footer><BR>JUICEapple
JUICE<BR>apple<footer><footer>JUICEapple

 

however, I expect to add a blank between 'JUICE' and 'apple'

namehtmlnewname  
JUICE<BR>apple<footer>BRJUICE apple
JUICE<BR>apple<footer>footerJUICE apple

 

 

 

 

Could you please give me some suggestions about this?

thanks in advance.

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20 PeterClemmensen
Tourmaline | Level 20

Re: find strings between (),[],{},' '," " and split them in new variables

Posted 03-18-2019 02:16 PM (1572 views)  |   In reply to Alexxxxxxx

Ah, I see what the problem is. The old Quotes Within Quotes problem 🙂

 

This

 

data have ;
  infile datalines truncover;
  input name $100.;
  datalines;
JUICE<BR>apple[footer] 
juice <BR> apple 
juice<BODY> 'apple'
<figure> "juice" LTD
;

data want;
   format name html newname;
   set have;
   RegExID = prxparse('/<\w*>|\[\w*\]|\(\w*\)|"\w*"|''\w*''/');
   start=1;
   call prxnext(RegExID, start, length(name), name, pos, length);
   newname=prxchange('s/<\w*>|\[\w*\]|\(\w*\)|"\w*"|''\w*''/ /', -1, name);
      do while (pos > 0);
         html = substr(name, pos+1, length-2);
         output;
         call prxnext(RegExID, start, length(name), name, pos, length);
      end;
   keep name html newname;
run;

proc print data=want;
run;

gives you

 

 

Capture.PNG

The DATA to DATA Step Macro
Blog: SASnrd

View solution in original post

0 Likes
5 REPLIES 5
PeterClemmensen
Tourmaline | Level 20 PeterClemmensen
Tourmaline | Level 20

Re: find strings between (),[],{},' '," " and split them in new variables

Posted 03-18-2019 01:03 PM (1601 views)  |   In reply to Alexxxxxxx

Just made a very small change to your program in the PRXCHANGE Function. See if this does the trick

 

data have ;
  infile datalines truncover;
  input name $100.;
  datalines;JUICE<BR>apple[footer] 
juice <BR> apple 
juice<BODY> 'apple' 
juice{BODY} apple 
[BR]juice apple
<figure> "juice" LTD ;
run;
data want1;
   set have;
   RegExID = prxparse('/<\w*>/');
   start=1;
   call prxnext(RegExID, start, length(name), name, pos, length);
      do while (pos > 0);
         html = substr(name, pos, length);
         newname=prxchange('s/<\w*>/ /', -1, name);
         output;
         call prxnext(RegExID, start, length(name), name, pos, length);
      end;
   keep name html newname;
run;
The DATA to DATA Step Macro
Blog: SASnrd
0 Likes
Alexxxxxxx
Pyrite | Level 9 Alexxxxxxx
Pyrite | Level 9

Re: find strings between (),[],{},' '," " and split them in new variables

Posted 03-18-2019 01:25 PM (1594 views)  |   In reply to PeterClemmensen

thanks draycut,

 

but I get 

namehtmlnewname
JUICE<BR>apple[footer]<BR>JUICE apple[footer]
juice <BR> apple<BR>juice apple
juice<BODY> 'apple'<BODY>juice 'apple'
<figure> "juice" LTD<figure>"juice" LTD

besides, 

 

I cannot get the expected result by following code,

data want1;
   set have;
   RegExID = prxparse('/<\w*>|[\w*]|{\w*}|'\w*'|"\w*"/');
   start=1;
   call prxnext(RegExID, start, length(name), name, pos, length);
      do while (pos > 0);
         html = substr(name, pos, length);
         newname=prxchange('s/<\w*>|[\w*]|{\w*}|'\w*'|"\w*"/ /', -1, name);
         output;
         call prxnext(RegExID, start, length(name), name, pos, length);
      end;
   keep name html newname;
run
0 Likes
Alexxxxxxx
Pyrite | Level 9 Alexxxxxxx
Pyrite | Level 9

Re: find strings between (),[],{},' '," " and split them in new variables

Posted 03-18-2019 01:46 PM (1584 views)  |   In reply to PeterClemmensen

for example,

 

name
JUICE<BR>apple[footer] 
juice <BR> apple 
juice<BODY> 'apple'
<figure> "juice" LTD

I expect to get 

namehtmlnewname
JUICE<BR>apple[footer] BRJUICE apple 
JUICE<BR>apple[footer] footerJUICE apple 
juice <BR> apple BRjuice  apple 
juice<BODY> 'apple'BODYjuice
juice<BODY> 'apple'applejuice
<figure> "juice" LTDfigureLTD
<figure> "juice" LTDjuiceLTD
0 Likes
PeterClemmensen
Tourmaline | Level 20 PeterClemmensen
Tourmaline | Level 20

Re: find strings between (),[],{},' '," " and split them in new variables

Posted 03-18-2019 02:16 PM (1573 views)  |   In reply to Alexxxxxxx

Ah, I see what the problem is. The old Quotes Within Quotes problem 🙂

 

This

 

data have ;
  infile datalines truncover;
  input name $100.;
  datalines;
JUICE<BR>apple[footer] 
juice <BR> apple 
juice<BODY> 'apple'
<figure> "juice" LTD
;

data want;
   format name html newname;
   set have;
   RegExID = prxparse('/<\w*>|\[\w*\]|\(\w*\)|"\w*"|''\w*''/');
   start=1;
   call prxnext(RegExID, start, length(name), name, pos, length);
   newname=prxchange('s/<\w*>|\[\w*\]|\(\w*\)|"\w*"|''\w*''/ /', -1, name);
      do while (pos > 0);
         html = substr(name, pos+1, length-2);
         output;
         call prxnext(RegExID, start, length(name), name, pos, length);
      end;
   keep name html newname;
run;

proc print data=want;
run;

gives you

 

 

Capture.PNG

The DATA to DATA Step Macro
Blog: SASnrd
0 Likes
Alexxxxxxx
Pyrite | Level 9 Alexxxxxxx
Pyrite | Level 9

Re: find strings between (),[],{},' '," " and split them in new variables

Posted 03-28-2019 12:50 PM (1507 views)  |   In reply to Alexxxxxxx

Hello @PeterClemmensen 

 

I have a new question during the process.

the 

HARDY(FRNS.)'A'

cannot be processed by the code 

I expect to get 

nameCOMPANY_NAME_inBCOMPANY_NAME_noB
HARDY(FRNS.)'A'FRNS.HARDY
HARDY(FRNS.)'A'AHARDY

However, I only get 

nameCOMPANY_NAME_inBCOMPANY_NAME_noB
HARDY(FRNS.)'A'AHARDY(FRNS.)

 

Could you please give me some suggestions?

0 Likes

sasinnovate.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • ‎03-18-2019 12:10 PM
  • 1626 views
  • 0 likes
  • 2 in conversation