A few things. the value clause only accepts values not expressions/functions such as datetime.  To get what you want I would create temporary SAS data set then insert that dataset into your oracle table.  See my example below data one; det=1; mydate=datetime(); format mydate datetime.; run; proc sql;   insert into myora.test1 (det,mydate)   select det,mydate from one; quit; ... View more

A quick question before I try to answer. If your source data is in a RDMS like Oracle, DB2, Teradata, SQL server, you can query the system tables and find the index on the tables which are unique.  If not any of the answers above will work. ... View more

I would put in a help ticket.  It looks like the user (you) has not been put into the system via sas management console. ... View more

Generally with an array you use some type of do loop. See my example below: data b; set a; array m(12); zero=0; do i=1 to dim(m); zero=zero+(m ne 0); end; run; ... View more

you can also check DINFO to get all the items in a directory ... View more

I've used the MONOTINC function with no ill effects for one table processing. I believe when joins occur the MONOTONIC function may fail. Sounds like a fun experiment! ... View more

i did notice in your code that the LIBNAME names uses OLEBD to connect to SQL Server and the SQL Pass-through uses ODBC. Try using the same connection method and see what happens. D ... View more

Unfortunately not. I would love to have a PRODUCT function and a SUMPRODUCT function, but in the mean time you'll have to use an ARRAY to calculated it. ... View more

Hello I work exclusively in SAS Enterprise Guide and have had the same problem that you have. I solved mine by directly accessing the Windows DLL that contains the copy/move function by using the SASCBTL attribute table with the MODULE family of call routines and functions. Below is a link to a paper that I wrote for SESUG 2010 that describes how to do this. paper http://analytics.ncsu.edu/sesug/2010/CC06.Putnam.pdf SAS DOC http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#accdll.htm Enjoy D ... View more

Just convert the date to a character like below data two; set one; format myweek weeku6.; myweek=raw_date; cat_week=put(raw_date,weeku6.); run; ... View more

SAS has a number of date functions and formats that you could use to solve your problem. Try the WEEK function or WEEKU./WEEKW. formats Try looking at the documentation http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003154994.htm http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002604217.htm below is a quite example for week begining with Sunday data one; format raw_date yymmddp10.; input raw_date yymmdd10.; datalines; 2009.01.05 2009.01.06 2010.01.05 2011.01.05 ; run; data two; set one; format myweek weeku6.; myweek=raw_date; run; ... View more

It all depends on how the new record is inserted into your master table and how big your table is. There are many was to accomplish this functionallity. I would use any of the 4 methods below: 1) I would create a timestamp and the most recent record would be the max timestamp, additional you can create a new record flag from the transaction set. 2) create a new record flag from the incoming data set See below for a quick code snippet. 3) create an audit data set 4) create a unique sequential id for your master file and store the max value in another table. All inserted record would be incremented by 1 then any ID greater than the max id would be new. data master_table; format timestamp datetime21.2; ID=1;value='HELLO';timestamp=datetime();output; ID=2;value='WORLD';timestamp=datetime();output; run; proc sql; create table max_id as select max(id) as max_id from master_table; select max_id into :max_id from max_id; quit; data transaction_table; value='TEST '; run; data master_table; set master_table (in=inMaster) transaction_table (in=inTransaction) ; * create timestamp to find newest record; * create 1/0 indicator for newest record; * increment id by 1; if inTransaction then do; counter+1; timestamp=datetime(); new=(inTransaction); id=&max_id+counter; end; run; ... View more

i don't think the CONNECTWAIT option is causing your problems. Since the log snippet isn't producing an ERROR maybe your data doesn't have any rows which may be unexpected. Is there any subsetting based on dates or anything like that when the data sets like WORK.FIVE is being produces? ... View more