I have no personal experience on this topic-point, however I believe you can use SAS Web Reporting Studio (WRS) indirectly with relational databases. You may find these links from the SAS support website http://support.sas.com/ useful - I found them using the SEARCH facility on the main webpage: Designing Information Maps for Ad Hoc Reporting Diane Hatcher, SAS, Cary, NC http://www2.sas.com/proceedings/sugi29/104-29.pdf http://support.sas.com/documentation/cdl/en/biwaag/61238/HTML/default/a002994053.htm http://www2.sas.com/proceedings/sugi31/013-31.pdf Scott Barry SBBWorks, Inc. ... View more

Please provide information about what is considered a "SAS error" in both cases, ideally pasting part the SASLOG into your forum post reply. Techniques for generating errors, both in a DATA step, and a macro (compilation) execution are fairly straightforward. There is an ABORT ABEND statement in SAS DATA step processing. Also, there is a SAS %ABORT statement in Macro language. Scott Barry SBBWorks, Inc. SAS MACRO language DOC - %ABORT Statement http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a002475061.htm ... View more

It may be easier to post what data you would like to see represented as output. But, if I understand your question, you want to change occurences of "+" or "-" characters with a multi-character string "0.0" - yes or no? If YES, the TRANWRD function in a SAS DATA step can accomplish the task. If NO, then please post a reply to the forum group with INPUT and OUTPUT data representations, along with an explanation to what you want accomplish. Scott Barry SBBWorks, Inc. ... View more

Correction: the 3/2009 date is not end-of-life service. Simply, info is provide on the page. Scott ... View more

SAS Support provides an anchor hyperlink to SAS 8.2 end-of-life service date (3/2009), provided below. Scott Barry SBBWorks, Inc. Support Services for Current and Prior Releases of Software http://support.sas.com/techsup/support.html#non-current ... View more

Using your SUBJECT, I used the website search facility and also Google advanced search with lowercase parameter site:sas.com to limit the search to the SAS.COM website, and found these two papers related to SAS/ETS software: http://support.sas.com/rnd/app/papers/tsfs.pdf Also, an acronym TSFS (Time Series Forecasting System) may help reveal additional reference materials. The link below references a technical paper on PROC MDC, if useful: http://support.sas.com/rnd/app/papers/mdc.pdf Scott Barry SBBWorks, Inc. ... View more

A search of the SAS support website http://support.sas.com/ revealed the related document link below, which mentions in the PRACTICE chapter 1 section about an accompanying CD-ROM. Scott Barry SBBWorks, Inc. SAS(R) Certification Prep Guide: Base Programming http://support.sas.com/publishing/pubcat/chaps/59332.pdf ... View more

Suggest you check the SAS support website http://support.sas.com/ and the SEARCH FACILITY using the forum post subject to start. I found several references on the topic / subject posted. Scott Barry SBBWorks, Inc. ... View more

Your request is somewhat an unreasonable one. Do you have the software installed somewhere? On what OS platform? With what set of SAS licensed components? Server and/or client product suite? These are rhetorical points/questions being raised in reply to your post. If you have a justified requirement for such information, given the attention/effort involved with others, you may want to consider opening a SAS support tracking issue for such a request... Scott Barry SBBWorks, Inc. ... View more

Investigate the SAS support website http://support.sas.com/ and search on VALIDVARNAME CONFIG option in various DOC references and TECHNOTE and HOTFIX reference items. Scott Barry SBBWorks, Inc. ... View more

The SAS support website http://support.sas.com/ has SAS hosted documentation and supplemental technical conference (SGF and SUGI) papers. I used the website SEARCH facility and found this conference paper which reference on using BREAK with the PAGE option. Scott Barry SBBWorks, Inc. Beyond the Basics: Advanced PROC REPORT Tips and Tricks Allison McMahill, SAS Institute Inc., Cary, NC http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf PROC REPORT: Compute Block Basics – Part I Tutorial Arthur L. Carpenter California Occidental Consultants http://www2.sas.com/proceedings/forum2008/031-2008.pdf ... View more

Suggest you explore using the SAS DATA step technique with multiple OUTPUTs, one for each file, and as you mentioned, using IF FIRST. to increment a count variable. Then use the SAS OUTPUT statement to send an observation to an output file name based on the incrementing variable. Then code your PROC PRINT steps, one for each split-file. Another option is using SAS MACRO language concept with a macro coded using %DO and %END; to process your input records and generate "n" output files. A list of COUNTRY values can be generated with PROC SQL, generating a list of SAS macro variables, for which you would process each in your macro to create a split-file, and then print it. The SAS support website http://support.sas.com/ has SAS hosted documentation, and also there are technical papers on this type of topic. Suggest you consider using the SEARCH facility at the website to identify references related to your post and also check the archives for this forum. Here is one of the technical conference papers I found using the SAS support website SEARCH facility: WHAT WOULD I DO WITHOUT PROC SQL AND THE MACRO LANGUAGE Jeff Abolafia, Rho, Inc., Chapel Hill, NC http://www2.sas.com/proceedings/sugi30/031-30.pdf SAS MACRO language -- Using PROC SQL with the SAS Macro Facility http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a001360983.htm -- Creating and Using Macro Variables http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a002595788.htm Suggest developing a SAS program to accomplish your objective, re-post a reply with the code, for feedback from the forum. Scott Barry SBBWorks, Inc. ... View more

I expect that this SAS support website http://support.sas.com/ note is applicable, even though ODS is not mentioned. You may want to investigate your options using ODS CSV, possibly, or open a SAS support tracking issue for more current information on support status, likely not until SAS 9.2, if then (phase 1 release). Also, there are other technical papers and SAS technotes on the SAS support website - suggest you may check there for more information. Scott Barry SBBWorks, Inc. Usage Note 19774: SAS® 9.1.3 SP4 for Windows does not support access to Microsoft Office 2007 Excel and Microsoft Access 2007 with cetain SAS/ACCESS® software http://support.sas.com/kb/19/774.html Usage Note 31956: Using the MSOffice2k ODS destination with Microsoft Excel 2007 generates a dialog box http://support.sas.com/kb/31/956.html ... View more

If not mentioned in the links provided by Cynthia, the SAS FILENAME FTP engine is a possibility to read data directly from z/OS MVS operating system, however you will need to have an FTP privilege to mount a tape defined for your remote host system. Also, considerations must be made for the DCB attributes as well for the remote host file type you are reading -- not an issue if straight F/FB/V/VB though. Scott Barry SBBWorks, Inc. ... View more

In the future, please send a new post to the forum with each new question. For your second question, you can use PROC IMPORT to read your CSV file, if you want SAS to do the processing for you, otherwise you can use the DATA step technique, with INFILE statement having a DSD and DLM=',' keyword, followed by your own INPUT statement to read the CSV-formatted input file. The SAS support website http://support.sas.com/ and its SEARCH facility can help identify SAS product documentation and also technical topic reference papers on the use of PROC IMPORT or reading an input CSV-formatted (delimited) file using a DATA step. Scott Barry SBBWorks, Inc. ... View more