> With macros, use double quotes. The SAS Macro > Facility will not look inside of single quotes. Technically, this is too sweeping a statement. You cannot really say that Macro *never* look inside of single quotes as shown on the thread started with this sas-l posting. ... View more

To do that, you'd have to insert a zero value into the data... data test; input month count ; cards; 1 10 2 20 3 0 4 19 5 5 ; symbol1 value=dot height=2 interpol=join; axis1 order=(1 to 5 by 1) minor=none offset=(5,5); axis2 order=(0 to 25 by 5) minor=none offset=(0,0); proc gplot data=test; plot count*month=1 / haxis=axis1 vaxis=axis2; run; ... View more

It's been quite some time since I've made powerpoint ready graphs. When I did, I used the cgm driver to create a file and then imported that into PP. That was the best method then. I note that it is still referenced in http://support.sas.com/techsup/technote/ts674/ts674.html. Regardless of the method you choose, the document is worth reading. ... View more

I think I stated my question incorrectly. base= with the ods html does what I want. base= allows me to change the path of the image file in the html source code. ... View more

You might want to look at a post I made to SAS-L a couple of years ago. In that post, I addressed fitting a segmented regression model. I only presented mechanics for fitting a model with a single join point and I did not show any of the permutation distribution testing. But that post might provide you with some basic methods which you can extend as necessary. See: http://www.mathkb.com/Uwe/Forum.aspx/sas/33115/segmented-regression-problem ... View more

thank you. ... View more

Although it specifically addresses LEGEND control, the paper http://www2.sas.com/proceedings/sugi29/086-29.pdf also discusses many of the same approaches. ... View more

You are missing a FILENAME statement to clear the allocated. Also, I executed your code, after adding the CLEAR, and the EMAIL had an attachment. Scott Barry SBBWorks, Inc. Suggested Google advanced search argument, this topic / post: send email attachment site:sas.com ... View more

Check the system-default for LRECL= and review the FILE statement, possibly with consideration for your OS, as well. Info can be found in the SAS Language Elements documentation and also the SAS "companion" document for your OS. Scott Barry SBBWorks, Inc. Suggested Google advanced search argument, this topic / post: file statement lrecl site:sas.com ... View more

I just noticed the OP is using a DATA step, so it's not necessary to use the character-string for &SYSDATE or &SYSDATE9 -- you can get the current date using one of several techniques, such as TODAY() function or a RETAIN SAS variable assigned to a constant "&SYSDATE9"D, and the use your DATA step variable to assign a date character-string in whatever format you choose, using a SAS output FORMAT. Given the code initially posted, no %SYSFUNC(...) is even needed. Scott Barry SBBWorks, Inc. ... View more

thanks DanH, i was looking for your answer a long time ... View more

Hi: You may need to change the STYLE template that you're using so that the USERTEXT style element has a justification of center. For ODS HTML, I do not believe that just= inside your style override will work for images. There are some Tech Support notes that show how to change the UserText element. The method you use in your style template will differ, depending on whether you have SAS 9.2 or SAS 9.1.3. cynthia ... View more

I just Googled filename email site:sas.com and found the answer in the first hit. ... View more

The problem is that you want a third type of quote mark. We only have two, but if we remember that the quote mark surrounding the entire string is really a character used by the parser to designate the string itself, we can take advantage of the parsing process. Surround the whole string with single quotes, as you have already done. Then change each interior single quote to two single quotes (not a double quote - hard to distinguish here). This forces the parser to take a second pass. [pre] data _null_; x = '< \a href="javascript:window.external.AddFavorite(''http://www.sas.com'', ''Portal'')" style="font-size:12px;color:black;font-family:verdana;">Click here<\a>'; put x=; run; [/pre] This technique, and its variants, allows you even more than three levels of quoting. ... View more

Hi: Well, if you were doing the report in PROC REPORT, the style override would be: [pre] style(header)={url='http://www.sas.com' foreground=purple background=pink} [/pre] However, I'm not sure that URL= will work with these data step objects, though. If you CAN use FILE: as the right argument, for setting a cell URL, I'm not sure that it will work with the FORMAT_CELL method. You might also want to check in the pre-production documentation. The pre-production documentation is here: http://support.sas.com/rnd/base/datastep/dsobject/Power_to_show_documentation.pdf In the documentation, I also note that there is an OBJECT.HREF method as shown here: [pre] obj.href(data: “SAS Home page”, file: “http://www.sas.com/index.html”); [/pre] So, it seems like your FILE: might be OK if you used a different method than OBJ.FORMAT_CELL Since the ODS DATA step object is still pre-production, you might want to check with Tech Support on this question. If they don't know the answer, they can work with the developers to get you the answer. cynthia ... View more