I am working with data from MS SQL Server that is surfaced in SAS as a data library via SAS Access for ODBC and wanted to know if there is a system option that treats the MS SQL data type of DATETIME as a SAS date instead of a SAS DATETIME. Right now I am having to use the datepart function to extract the date prior to doing any date comparisons. ANy ideas or am I stuck with using the datepart function? ... View more

Wanted to ask if there is a flag, switch or even programming technique to prevent a user from invoking a stored process if it ahs already been invoked. Any suggestions would be greatly appreciated. Many Thanks ... View more

Need some input on the construct of a list report that I am working on in WRS. Does anyone now the answer to the following items? 1. When a list report is rendered in WRS via the use of a stored process, do the proc report or proc print procedures explicitly control column layout and column wrapping or are these setting overridden by WRS? 2. Does WRS support the creation of list reports where the columns of a data observations can be split across multiple rows. I know that I can dow this in Crystal Reports and Cognos but have not seen this capability explicitly mentioned in any user documentation. For example, a single record consists of a name and address on line 1 and line two of observation consists of a comment. ... View more

Does anyone know if it is possible to kick of the distribution of a web report via code that is run as part of a scheduled job via the SAS OS Job Scheduler? I know that this seems like an odd question but I need to distribute reports to users based upon information that an existing program downloads from a data vendor on a nightly basis. Unfortunately, the data vendor provides me with the data when new activity takes place and it can be several days between updates. As a result, I only want to distrubte reports when I have recieved fresh data from the vendor. Many Thanks, James ... View more

Is it possible for PROC SQL to support custom functions. For example, prior to executing my select query it is necessary to invoke the following custom function fms.fms_multiorg.set_org_id( 707 ). Any quittance would be greatly appreciated. ... View more

I am working on a project where a data file is sent via e-mail and wanted to ask if it is possible on EG to perform the following actions: 1. Connect to the MS Exchange message store. 2. Extract the file attachement from the e-mail. Trying to improve a process by eliminating manual steps. Any help or suggestions would be greatly appreciated. James ... View more

I have the following questions related to setting properties in WRS 4.2: 1. If properties are set via the use of the LocalProperties.xml, is it still possible to set properties in SMC via the Advanced tab (Application Management ► Configuration Manager ► Web Report Studio 4.2.)? 2. Is there a paper, table or reference work that lists the all of the available properties that can be set by an administrator and values and/or range of values that these properties can be assigned? 3. Specifically, what property can be used to increase the default number of rows used in a WRS table from 40 to 54? Many Thanks, James ... View more

Wanted to know if anyone has been able to distributed a report via e-mail with url's that are active? I am using WRS 4.2 and have embedded a line of text that is linked back to a detail report. The report is delievered via e-mail but the url appears to be stripped out of the message? Any ideas? JM ... View more

All - Is it possible to replace a column across a whole project instead of the individual elements of a project? I have a user who is not a programmer and she has written a fair number of projects that now need to be modified due to changes in some of the underlying support tables. Any advise would be greatly appreciated. Many Thanks, jdm ... View more