I think that it is not the value but the formula that you want to store. Is the following close to what you are looking for? Formats are also an option. [pre]data a; txt = '10~{super 9}'; run; ods escapechar='~'; ods pdf file='c:\temp\super.pdf'; proc print data=a; run; ods pdf close;[/pre] ... View more

Hi: Generally, when people refer to "in-line" macros, they are referring to "session compiled" macro programs that are compiled and used within the same program. Usually, they reside in the WORK library, as described here, in the documentation (as opposed to autocall macro programs or Stored compiled macro programs): http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#/documentation/cdl/en/mcrolref/61885/HTML/default/a002293861.htm And these 2 papers are very good resources for the beginner (in addition to the most excellent books written by Art Carpenter): http://www2.sas.com/proceedings/sugi29/243-29.pdf http://www2.sas.com/proceedings/sugi28/056-28.pdf I'm not sure what you mean by #2 and #3 -- this is an instance where a concrete example or more explanation would be useful. Especially, what you mean by the phrase "enlist tables" in the sentence "Suggest a way to enlist tables that have a column containing string - ‘asset’" If you want to find tables that have a column which contains "asset" as part of a column name, then you will want to search for previous forum postings on the use of the SAS Dictionary tables or the SASHELP "V" tables. And, if this is a homework assignment, then your best resource is your professor or teaching assistant for the class. cynthia ... View more

I think it is not a case of one being better than the other but what is most appropriate for your situation. For example, we use passthru for our large Oracle Production jobs as it is easier to fine-tune, add Oracle hints for better performance and to get support from Oracle DBA's if things go wrong (you can drop the query into SQL Plus, TOAD or some other SQL tool and it will just work). But for ad-hoc work and user jobs SAS SQL is simpler and more productive. ... View more

Hi: You can only "reset" or change titles between program steps -- that generally means at step boundaries -- so you can't reset the TITLE statement between BY groups. However, rather than thinking about how to "turn off" or "hide" the second title statement, think instead about turning off ALL titles and using an alternative method to put text at the top of the output. That alternative method is the ODS TEXT= option. If you look at the program below, run the code and review the results, you will see that ODS TEXT= puts a text string at the very top of the report -- before the first BY group from PROC FREQ. ODS TEXT= is a one-time insertion of a text string...so it will NOT repeat for the second BY group. Usually, the text string that you specify is left justified and in a small font. BY using the <H3> tag, I am getting title-like formatting, without using a TITLE statement. (There is an alternate way to format the TEXT= string, but it involves using a style template, which would be the method you'd have to use for RTF and PDF -- but since HTML has the lovely <H3> tag, that seems a simpler approach for HTML output. cynthia [pre] ods listing close; ods html file='c:\temp\freqlist.html' style=sasweb; title1; footnote; ** 1) create output WITHOUT titles or footnotes; ** 2) and then use ODS TEXT= to place text before FREQ starts (which will be before first BY group); ** Note if using SAS 9.1.3, need to use ODS HTML TEXT= option; ods text='<div><h3 align="center"> Pavan</h3></div>'; proc freq data=a; by gender; tables gender age / list; run; ods html close; [/pre] ... View more

You also should be aware of the following information: Each SAS Web-based application, such as SAS® Web Report Studio and SAS® Information Delivery Portal, must run in a unique browser session. If you attempt to share one browser session across multiple tabs, you will experience unpredictable application behavior. For example, when switching between tabs, you might be repeatedly asked to log into the application. In addition, do not attempt to run SAS Web Report Studio in multiple browser sessions on the same computer. Also, if you are navigating between linked reports, there should be a link to return to the previous report in the target report. Do you not see that link? ... View more

This set-up sounds a little bit old fashioned to me. Please tell a bit more about your users, what this batch/macro program does (output), and what products you license from SAS (or others?). /Linus ... View more

Barheat - thanks for the day of week tip - I have been trying to use something like this but must have missed something along the way. Pavan@SAS- We are running 9.2 on a remote server with XP, and this is how I get to the scheduler: Start -> All Programs -> Accessories -> System Tools -> Scheduled Tasks And in the run window I have the following all in one string: D:\SAS9.2\SASFoundation\9.2\sas.exe -AUTOEXEC D:\SASData\myarea\AUTOEXEC.SAS -SYSIN D:\SASData\myarea\run_this_file.sas Good luck! Wendy T Message was edited by: WendyT ... View more

Answer given here (in principal the same what data _null_ told you): http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/fbc8b03b447ca319# ... View more

S, u r correct. There is no other way !!! Thanks !!! ... View more

Hi: By default, ODS -recreates- your FILE= file every time you run your program. As far as I know, there is no capability to "append" files for any ODS destination except for ODS HTML, as described in this Tech Support note: http://support.sas.com/kb/23/660.html (ODS HTML works this way because you are creating 1 HTML file and the opening and closing tags are controllable using the NOTOP and NOBOT suboptions.) In contrast, ODS RTF and ODS PDF do not allow appending of files. http://support.sas.com/kb/24/034.html http://support.sas.com/kb/35/375.html From what you say: "there is an output in an excel sheet. i want to append my next output into the same sheet ..." It seems like ODS HTML (or ODS MSOFFICE2K) -might- work for you. The catch is that this technique will only work if your first/original file was also created with ODS HTML. When you use ODS HTML, you are not creating a true, binary Excel file -- you are creating an ASCII text file of HTML tags that Excel knows how to open and render. When you create your first ODS HTML file, be sure to use the NOBOT suboption. Then when you create your second ODS HTML file, be sure to use the NOTOP suboption. You should see both outputs in one HTML file -- which Excel will interpret as one sheet -- because 1 HTML page = 1 sheet in 1 workbook. If you have an existing -binary- Excel workbook to which you want to add your report, I believe that you cannot use ODS to accomplish this task unless you first IMPORT the first workbook into SAS and then rewrite the first file's information, along with your new report -- using ODS HTML. Or, you could convert your report into a SAS dataset and then use PROC EXPORT or the Excel LIBNAME engine to write the report DATA to a new sheet in the binary Excel workbook. The approach that you choose will be dependent on how that first sheet was created. You might wish to work with Tech Support on this question, as they can help you choose from the various options, based on information about your first sheet, which version of SAS you're using and which version of Excel/Office you're using. cynthia ... View more

Hi: If you are using the RTF or PDF destinations, then you can change your orientation system option to Landscape, which may fit all the variables on one page. Otherwise, you may need to make two passes thru the data to get your report the ways you want. For example, in the program at the end of this post, in Step 1, there are 2 passes thru SASHELP.SHOES and in Step 2, the orientation has been changed to landscape orientation. cynthia [pre] data shoes; set sashelp.shoes; Thisobs = _n_; run; **1) Make 2 passes thru the data; options orientation=portrait; ods rtf file='twopass.rtf' ; ods pdf file='twopass.pdf'; proc report data=shoes nowd; title 'Some variables'; column Thisobs region product subsidiary sales; run; proc report data=shoes nowd; title 'The rest of the variables (repeat thisobs and region for ID purposes)'; column Thisobs region inventory returns stores; run; ods _all_ close; **2) Use Landscape orientation; option orientation=landscape; ods rtf file='useland.rtf' ; ods pdf file='useland.pdf'; proc report data=sashelp.shoes nowd; title 'Use Landscape Orientation to Display All Columns'; column region product subsidiary sales inventory returns stores; run; ods _all_ close; [/pre] ... View more

non-breaking space ... View more

Have a look at the DOC - both SHEET= and RANGE= parameters can be enclosed in double-quotes. Also there is some mention about coding the trailing "$" for the sheet, which you may want to also review for relevance. Scott Barry SBBWorks, Inc. SAS Support website http://support.sas.com/ - the 9.2 doc here should be relevant to your interests, I would say: SAS/ACCESS(R) 9.2 Interface to PC Files: Reference Microsoft Excel Workbook Files Microsoft Excel Files Essentials http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003103761.htm ... View more