So I have a project that if I just click 'Run Project' it will fail, but if I go through manually and run each individual query there is no problem and the project will give the desired output.   Anyone know why this might be happening?   This is the error that happens, ERROR: Unable to get SAS code. Unable to open input data   But like I said I can click through it and it works fine. ... View more

Hello,   So I have a project that has multiple steps to get to my final data set.   At the end I want to automatically export the data as part of the process, when I use the export as a step in project, the step does not link to the data and instead puts itself in a different project in the project tree.   Why is this happening and how do I fix it?   Thanks ... View more

Hello,   So I have two tables, one of them is a historical table (Table 1) that I am storing all data in, the other is a table that updates with new data and deletes old data that is no longer needed (Table 2).   I am wanting to take the new data from Table 2 and add it on to Table 1, what is the easiest way to do this? I will be able to identify the new data as there is a field that identifies new data going in, so the data goes in in batches and I have the name of the new batches going in.   Is Proc Append the best thing in this situation? ... View more