About LB

LB · ‎08-01-2012

Hi all, I have two small technical details to work out in which I hope this is feasible- 1) A blank placeholder within a spanned header- Within proc report I have: columns ('PROCESS' ('Placeholder' ComplianceHHa,ComplianceHH complianceISOa,complianceISO DOT_1000a,DOT_1000 complianceATPa,complianceATP)) The issue is that if I use ' ' then the left boundary line does not appear and it looks odd-is there a way to get this to be blank...or insert a URL link even better? 2) So in total there is- columns ('PROCESS' ('Placeholder' ComplianceHHa,ComplianceHH complianceISOa,complianceISO DOT_1000a,DOT_1000 complianceATPa,complianceATP)) ('OUTCOME'('1 Month' numa,num /*lastmoa,lastmo*/) ('3 Months' lastmoa3,lastmo3) ('12 Months' numa12,num12 lastmoa12,lastmo12)) ; Is there a way to create an small space between the two sections- I have attempted to use an extra column called emp but it leaves "blank squares" with borders. Any help much appreciated. Lawrence

LB · ‎07-31-2012

Cynthia- Duly noted. Thanks. Lawrence

LB · ‎07-31-2012

OK Cynthia-It was a good start and it helped me enough to get to where I want to go but I have a curious issue with a phantom issue- I essentially have a report that makes use of a ODS PDF text statement- ods text="\S={leftmargin=1.5in preimage='T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\TEMPLATE\LOGO.bmp' font_size=7 font_weight=bold} Hospital-Associated xxx Infection"; It works after the cover page, or the 2nd page of the report, but then when I run the statement it seems to be attaching a whole another image that is for the cover page? I am stumped. I realize that you probably need the code but I'd rather do that off-line. Lawrence It works properly on the 2nd page of the report, after the cover page, but then

LB · ‎07-30-2012

Many Thanks! Lawrence

LB · ‎07-30-2012

Hello all; I am looking for some guidance on using background images for a report cover- Essentially there is a mandated image but then I want to add about 3 spaced lines with text and images that are linked to other pages in the report. If anyone has any guidance to any SUGI papers or others that might have some ideas that would be great. If I attempt to set the image as a background image now, it simply shrinks it..code thus far.. I know that I can embed the image in a proc template statement but I only need it for the first page. Thanks. Lawrence ods escapechar="\"; ods listing gpath="P:\" ; ods graphics on/reset=all antialias=on width=9in height=5in border=no ; options nodate nonumber center leftmargin=.25in rightmargin=.25in topmargin=.05in bottommargin=.15in orientation=landscape; ods pdf file='P:\Report.pdf' style=Styles.XCL dpi=300; ods pdf text="\S={topmargin=1in leftmargin=1in backgroundimage='T:\Hospital Reporting Team\Inp Quality Analytic Team\HA-CDI\HA-CDI Dashboard\TEMPLATE\dashboardheader.bmp'}"; ods run; ods pdf close;

LB · ‎07-30-2012

many thanks Keith!

LB · ‎07-23-2012

Thanks Keith-That helps immensely-One quick question-what if I do want to set the number of characters as I don't want to see 'no '500 characters' infiltrate' which is entirely possible. That is why I was containing it to 30 characters. Lawrence

LB · ‎07-23-2012

Hello all- I am attempting to use a regular expression such as below: prxparse('/[ N|N| n|n]o.{1,30}infiltrate/i'); For no infiltrate or No infiltrate. However it is also picking up non xxx infiltrate, normal...infiltrate. How do I limit it to just no? I do need the character spaces as there are quite a number of words that can can appear between the two words. Thank you. Lawrence

LB · ‎07-10-2012

Thanks both of you! Both solutions help although TomKari's answer works a tiny bit better. Another question for you TomKari- How can I set the first letter of lung to be either upper or lowercase? Lawrence

LB · ‎07-10-2012

OK all- So I am trying to figure out regular expressions and I am having a little bit of a challenge. I am text mining a note field (that can have thousands of characters)-below is just one parameter that I am looking for- I am looking for it to return a (or any) value-but it just returns blanks- Essentially I am looking for certain key phrases- such as: lungs are clear lungs clear lungs appear clear Thanks in advance for your help- Lawrence data temp2; set notes; if _n_=1 then do; re= prxparse('/lung\w{0,15}clear/'); if prxmatch(re,note_text) then ch=1; end; retain re; run;

LB · ‎06-07-2012

Andre; Not sure if this is one of those differences between 9.2 & 9.3 but it fails in 9.2. Thank you for your assistance. Yes I am looking to modify a report to "mimic" buttons with url links. If need be, I can import the buttons as jpegs and then assign them url links. Lawrence

LB · ‎06-06-2012

Hello all; I am essentially using the title statement as a way to create "buttons" with white for the color and a blue background color- What I am attempting to do is assign separate url links to each element and this is where I have problems- The code I have is below-In the end I need to add pdf anchors but for the purposes of the code I am just including basic urls- Thank you. Lawrence options ls=130 nonumber nodate nocenter; ods pdf file='temp.pdf'; title; ods escapechar='^'; title j=center "^{style [borderleftwidth=2pt borderleftcolor=black borderbottomwidth=3pt borderbottomcolor=black borderrightwidth=2pt borderrightcolor=black bordertopwidth=3pt bordertopcolor=black background=blue color=white url='http://www.yahoo.com' ] A } | ^{style [borderleftwidth=2pt borderleftcolor=black borderbottomwidth=2pt borderbottomcolor=black borderrightwidth=2pt borderrightcolor=black bordertopwidth=2pt bordertopcolor=black background=blue color=white url='http://www.google.com'] B }"; data _null_; file print; put 'xxx'; run; ods pdf close;

LB · ‎06-04-2012

Astounding- Thanks for the tip. That helps. Lawrence

LB · ‎06-04-2012

Thanks data_null_! That helped! Lawrence

LB · ‎06-04-2012

Hi all- I have an issue that has been confounding me to no end- I have a query that goes like this- PROC SQL; SELECT sum(CASE WHEN COMPLIANT='NO' then 1 else 0 END),count(*) into :NUM1, :NUM2 from XYZ where put(FAC_ID,$shortfix.)='XXX' /*group by FAC_ID*/ quit; When I call the macro variables NUM1 and NUM2, NUM1 has a big trailing space- I have attempted to modify it as putting it as a character variable to no avail. NUM2 works just fine. Any answers, solutions would be great. Thanks Lawrence

Online Status	Offline
Date Last Visited	‎08-12-2024 05:16 PM

Re: embedding macro in data step (involving array)

Re: embedding macro in data step (involving array)

Re: embedding macro in data step (involving array)

Re: embedding macro in data step (involving array)

Re: embedding macro in data step (involving array)

Re: embedding macro in data step (involving array)

embedding macro in data step (involving array)

Re: Tying an event to a date in a row (for each specific member)

Re: Tying an event to a date in a row (for each specific member)

Tying an event to a date in a row (for each specific member)

Re: embedding macro in data step (involving array)

Re: embedding macro in data step (involving array)

Re: Tying an event to a date in a row (for each specific member)

Re: Creating dummy set w/ dates

Re: FTP transfer issues -corrupt files

Re: Hyperlinking sheets within SAS ODS Excel

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

Re: ODS EXCEL OUTPUT (GRAPHS) NOT rendering

blank placeholders within subheaders and blank spaces between columns

Re: Report cover in ODS using a background image

Re: Report cover in ODS using a background image

Re: Report cover in ODS using a background image

Report cover in ODS using a background image

Re: reg expressions part II-controlling the "no" in the expression

Re: reg expressions part II-controlling the "no" in the expression

reg expressions part II-controlling the "no" in the expression

Re: regular expressions (with PERL)

regular expressions (with PERL)

Re: ODS title statement with background colors and url linkage for eac...

ODS title statement with background colors and url linkage for each el...

Re: declaring macro parameters in PROC SQL and length issues

Re: declaring macro parameters in PROC SQL and length issues

declaring macro parameters in PROC SQL and length issues