Change source file

[lioradam]

Hello all,

I imported an excel file and then built a process flow base on that excel file (add query builders, program, etc).

Now I would like to replace the original excel file with a new excel file that has the same variables, but different observations.

Can I connect the new excel file to the process flow (replace the former excel file with the new one), so I would not have to build the process flow all over again?

Thanks in advance,

Lior

[Kurt_Bremser · Accepted solution]

You should be able to modify the filename in the Import node, but leave the target dataset name unchanged.

But there is the usual caveat when using Excel files: changes in data can cause changes in structure (variable type and attributes). For a consistent process, use a different file format (csv), the Copy Files task, and a manually written data step.

[lioradam]

Hi Kurt,

Thank you for your answer. Actually, I found another (less elegant) solution: I copy the new data into the original source data (copy from the new excel file to the original excel file) and the SAS automatically updates the data. but I will try your suggestion as well.

Thank you,

Lior