BookmarkSubscribeRSS Feed
Jorn
Calcite | Level 5

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?

1 REPLY 1
FriedEgg
SAS Employee

Either use %sysfunc when you call htmldecode function or put the function inside your PROC SQL select.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 1191 views
  • 3 likes
  • 2 in conversation