Hello I am also having this problem. I found your post in the discussion forum, although I can see it was from a long time ago. Did you manage to find a solution? George ... View more

What I wanted to point out is that a table update in place (or in the same library/physical location) will always have a big performance hit, and that one should consider playing "ping-pong" with the data if that is a feasible option, as it does speed up things nicely. And when one is on the task of improving the storage setup, one might want to go the whole way and also include the WORK/UTILLOC considerations, because sorting and the utility file of SQL is always part of the SAS game. ... View more

A better question to ask is why and how you would use project repositories. SAS(R) 9.4 Intelligence Platform: System Administration Guide, Third Edition ... View more

Well, it's always possible that your actual DATA step is more complex than the one you have shown here.  But looking at just this code, you don't really need a DATA step at all.  The observations and data values in X_FINAL are identical to X_UPDATED.  You could just use X_UPDATED and build your indexes (hate that word!) using a different tool that doesn't need to read in each observation individually the way a DATA step does. Looking at the number of variables for which you are creating an index, it concerns me that the programs that use the indexes might be less efficient as well.  But you haven't posted any of that code so it's difficult to judge. ... View more

I'm not sure if it would run any faster but this looks like you might investigate and EXCEPT operation. ... View more

Thanks Amir ... View more

It is possible, but absolutely NOT best practice. As soon as you edit the source code, everything in the metadata that you have defined will have no effect on the code. So, if you want add some code, do it in pre/post code to the job/transformations. If you want to change the, that's a different story, and needs separate discussions on each occasion I believe... Do you have any special changes in mind? ... View more

You may want to look into Graph Template Language as there are some additional features such as this available. The GTL REFERENCELINE statement allows labeling a reference line, controlling the font and color of text and some minimal control over where in relation to the line the label will appear. ... View more

If that was indeed only introduced in 9.3, take a look at: http://support.sas.com/resources/papers/proceedings11/095-2011.pdf ... View more

I checked and got some similar(old) posts ... And I took and applied following bold statments from these posts to my code:   options nodate nonumber; ... first page content.... options number; options pageno = 1; ...second page content.... This worked for me.  Thank you. ... View more