I'm querying several tables from Oracle and am wondering if there is a procedure out there that will tell me which Oracle tables my extracted fields are coming from. When reading the source code in SAS I can obviously see the names of the Oracle tables that are being used to extract my data, but I am wondering if there is a way to determine this programmatically. If you're wondering what all of this is for -- I'm trying to write a procedure that will essentially create a report inventory so I will be able to determine which Oracle tables/columns are being used on which reports. ... View more

Hello -- I'm attempting to edit the welcome page (welcome.html) of the SAS Stored Process Web Application. I've searched for the physical welcome.html file on my server, and I've found it in a few locations. Does anyone know what the default locations is? I've tried to edit the Welcome.html file, but I can't seem to get my edits to be reflected with I log on to the Stored Process Web Application. After the Welcome.html file has been updated do I need to restart the metadata, jboss, or anything else in order for the changes to be reflected when users log on? Setup: SAS 9.2 on Windows 2008 Server 64-bit. Message was edited by: mdavidson ... View more

Hello -- I'm relatively new to forecasting so I'm looking for some help. I'd like to create a daily volume forecast; I have lots of historical data. I'm using SAS EG 4.1, so I don't have SAS Forecast Studio. Here's the problem. I'm currently able to create a fairly accurate MONTHLY forecast using PROC STATESPACE and a few data steps. I'd like to translate this into a daily forecast, or if possible use PROC STATESPACE to create my daily forecast. My data is seasonal. For example Jan, Feb, and Mar are busy months. Saturday is a light day, Tuesday is the busiest day. Any suggestions? I've been doing a ton of searching on the web, but can't seem to find anything. ... View more

Has anyone ever used SAS to create a word cloud? I know there are several free generators on the web, but has anyone done this in SAS and is there a sample out there? I've searched around but found nothing.... ... View more

Hello, I'm new to pass-through and am trying to connect across two databases using an alias for each connection. This is probably a simple solution, but how can I join the below query by CUST_ID across the two connections? PROC SQL OUTOBS=20; CONNECT TO ORACLE AS CON1 (USER=UID PASSWORD=PASS PATH=DB1 CONNECTION=GLOBAL); CONNECT TO ORACLE AS CON2 (USER=UID PASSWORD=PASS PATH=DB2 CONNECTION=GLOBAL); CREATE TABLE WORK.TEST AS SELECT * FROM CONNECTION TO CON1 (SELECT CUST_ID FROM CUSTOMERS); SELECT * FROM CONNECTION TO CON2 (SELECT CUST_ID,CUST_NAME FROM CUSTOMER_DETAIL); DISCONNECT FROM CON1; DISCONNECT FROM CON2; QUIT; ... View more

I'm getting the following error when trying to create a .csv file from a dataset with character and numeric column names (name, 2008,2009). Is there any way around this, other than exporting to .xls? NOTE: SCL source line. 52 format 2008 best12. ; ____ _______ 22 201 NOTE: SCL source line. 53 format 2009 best12. ; ____ _______ 22 201 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 201-322: The option is not recognized and will be ignored. ... View more

Is it possible to insert a logo into an excel file that is created via SAS? I know you can insert a logo with proc report and ODS PDF with preimage=*, but I have not had any success with logos and excel files. If it is not possible to insert a logo into an excel file, what is the generally accecpted workaround? ... View more