Hi.
I am trying to load an article which is stored as encoded html. So basicly this line:
<p>Hello world ; : ' " ! @ # $ % ^ & * ( ) </p>
is stored as %3Cb%3EHello%20world!%20%3B%20%26%20%40%20'%3Cb%3E%0A
Using proc stream and proc sql I can retrieve the data. Now my problem is decoding the content. Obviously, I looked into HTMLDECODE
However I am having trouble getting it to work in combination with Proc stream. Here is how I retrieve it
%let GetContent =%sysfunc(dosubl(
proc sql noprint;
select M.content into :article SEPARATED by ''
from BE_TEMP.BI_ARTICLE M where M.id eq 12;
quit;
));
%let newArticle = htmldecode(&article)
&newArticle
Can anyone spot the problem?
Either use %sysfunc when you call htmldecode function or put the function inside your PROC SQL select.
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.