<html>
<body>
In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML.
Any way to do this in SAS?
<div align="left" style="min-height: 9pt; "><font face="Arial" color="#000080"><span style="font-size:8pt"><b>Stover,Susan<TEST>, 6/21/2018 12:47:47 PM: </b></span></font><font face="Arial"><span style="font-size:8pt"> <br /></span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt">Can this be set to retest with recent or new records? This issue
was encountered while Susan was testing code</span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt"><br /></span></font><font face="Arial" color="#000080"><span style="font-size:8pt"><b>________________________________________</b></span></font><font face="Arial"><span style="font-size:8pt"><br /></span></font><p></p>
</div>
</body>
</html>
How about this one:
data have;
infile cards truncover;
input x $2000.;
new_x=urldecode(prxchange('s/<[^<>]+>//',-1,x));
cards4;
<html>
<body>
In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML.
Any way to do this in SAS?
<div align="left" style="min-height: 9pt; "><font face="Arial" color="#000080"><span style="font-size:8pt"><b>Stover,Susan<TEST>, 6/21/2018 12:47:47 PM: </b></span></font><font face="Arial"><span style="font-size:8pt"> <br /></span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt">Can this be set to retest with recent or new records? This issue
was encountered while Susan was testing code</span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt"><br /></span></font><font face="Arial" color="#000080"><span style="font-size:8pt"><b>________________________________________</b></span></font><font face="Arial"><span style="font-size:8pt"><br /></span></font><p></p>
</div>
</body>
</html>
;;;;
run;
proc print noobs;run;
How about this one:
data have;
infile cards truncover;
input x $2000.;
new_x=urldecode(prxchange('s/<[^<>]+>//',-1,x));
cards4;
<html>
<body>
In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML.
Any way to do this in SAS?
<div align="left" style="min-height: 9pt; "><font face="Arial" color="#000080"><span style="font-size:8pt"><b>Stover,Susan<TEST>, 6/21/2018 12:47:47 PM: </b></span></font><font face="Arial"><span style="font-size:8pt"> <br /></span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt">Can this be set to retest with recent or new records? This issue
was encountered while Susan was testing code</span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt"><br /></span></font><font face="Arial" color="#000080"><span style="font-size:8pt"><b>________________________________________</b></span></font><font face="Arial"><span style="font-size:8pt"><br /></span></font><p></p>
</div>
</body>
</html>
;;;;
run;
proc print noobs;run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.