topic Re: Using SAS to generate HTML code in SAS Procedures

Using SAS to generate HTML code

AnnieL — Wed, 06 Jun 2012 18:44:50 GMT

Hi everyone! I'm a fairly new user to SAS and have recently run into a problem.

I'm working on a project that requires that I generate a list of URLs while pulling from a variable on the dataset. Each URL is the same except for one value that gets pulled off of the dataset.

ex: http://www.census.gov/cgi-bin/sssd/naics/naicsrch?code="xxx"&search=2007

xxx = the variable I want to pull off of the dataset

I've been using the following code:

. . .

ELSE IF FIRST.xxx AND zzz = 1 THEN PUT ' NOTE: ALL OF <a href=""http://www.census.gov/cgi-bin/sssd/naics/naicsrch?code=' xxx '&search=2007"'">' xxx'</a> IS IN ' yyy '';

. . .

But for some reason, there's an extra space between variable "xxx" and the rest of the link. I end up getting:

http://www.census.gov/cgi-bin/sssd/naics/naicsrch?code=xxx%20&search=2007

Has anyone tried this before and know what's going on? I would greatly appreciate any help at all!

Thank you!

Re: Using SAS to generate HTML code

MikeZdeb — Wed, 06 Jun 2012 19:05:37 GMT

hi ... in the PUT portion, add a backspace ... +(-1) ...

PUT ' NOTE: ALL OF <a href=""http://www.census.gov/cgi-bin/sssd/naics/naicsrch?code=' xxx +(-1) '&search=2007"'">' xxx +(-1) '</a> IS IN ' yyy '';

example ...

data _null_;

xxx = '12345';

put 'this is a test' xxx 'with no backspace';

put 'this is a test' xxx +(-1) 'with a backspace';

run;

the LOG ...

this is a test12345 with no backspace

this is a test12345with a backspace

Re: Using SAS to generate HTML code

AnnieL — Wed, 06 Jun 2012 19:11:10 GMT

Worked perfectly! Thank you so much!

Re: Using SAS to generate HTML code

SteveNZ — Wed, 06 Jun 2012 21:36:28 GMT

Another option:

data test ;

xxx = '12345' ;

url = cats(' NOTE: ALL OF <a href="http://www.census.gov/cgi-bin/sssd/naics/naicsrch?code=',xxx,'&search=2007">',xxx,'</a> IS IN yyy ') ;

run ;