I know that this is an old post, but this is exaclty what I am attempting to do.  Did you every find a resolution to this...other than creating scripts and including a call to those scripts in your startup process?   Thanks, Ricky ... View more

To be more precisely: data table1; input ID $ 1-2 data $ 3-10; ID_2=ID+1; datalines; 1 sysdate 2 sysdate 3 sysdate 4 sysdate 5 sysdate 6 sysdate 7 sysdate 8 sysdate 9 sysdate 10 sysdate ; run;   data table2; input ID $ 1-2 data $ 3-10; ID_2=ID+20; datalines; 1 sysdate1 2 sysdate2 3 sysdate3 ; run;   After loading tables in memory (we are in a distributed env) i used this program: proc imstat data=valibr.table1; UPDATE data=valibr.table2; run; fetch / format ; quit;   Unfortunately it doesen't work. The result is: Rows from the table HPS.TABLE1 ID data ID_2 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23 3 sysdate3 23   ... View more

In my case a XML column trows of the SQL Instance CDC script to create the mirror table and adds the column called unused_1. Here are the steps that I did to get it to work.  Pega Training in Chennai 1. Create the table in the CDC Designer console as you usually would. 2. Copy the CDC instance deployment script (from the right of the screen) 3. Remove the table that is being dropped when data is added. 4. Copy the table creation and CDC section from the script, remove the unused_ column, and execute. 5. The mirror table is now created and CDC is activated on it. 6. Check that the table is in the CDC designer.   VMware Training in Chennai 7. Add data to the oracle table and see the changes being recorded. Do more testing of data being moved. I hope this helps! I took me quite a while to figure this work around out and I hope it will be fixed in future versions.   PHP Training in Chennai ... View more

Co-located storage is only relevant if you have a distributed VA/LASR environment. So I take it from your answers that you are on a single node, right? If so, yes, "SAS" is your data storage. I have no experience in how/when to synchronize this kind of set-up. If you are using Base SAS for your main "off line" storage, make sure that it has as fast I/O as possible. You could use SPDE which could speed up read access (to fasten up the load to LASR). ... View more

Hi Nikhil, You might also find this discussion thread useful Kind Regards, Michelle ... View more

Hi Abhishek, Thanks for your responce. We need to rename the dataset dynamically using SAS code. Nikhil ... View more

Agree kurt missed that other one.... ... View more

Better use this community not the other... https://communities.sas.com/thread/74709   (no need for duplicated posts / can be frustrating) ... View more

This is the far better option. I think you need -logparm "rollover=session" in there for it to work ... View more

To the remarks made by user24feb: - Pretty good post from SAS User Groups - You have some more options for scheduling, and the one that fits better in your needs, it is something for you to decide:      - SAS Grid Manager : pretty expensive license, but includes Platform Computing for Scheduling (with its beautiful functionalities) and will add you nice features like parallel processing, load balanding, high availability and improved scheduling.      - You can use your own Enterprise Scheduler: it will require from you to do some manual work, but it has some good advantages, like the possibility to integrate your SAS processes with other processes within your Enterprise flows. ... View more