topic Change source file in SAS Procedures

Change source file

lioradam — Sat, 30 Apr 2022 15:06:34 GMT

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

Re: Change source file

Kurt_Bremser — Sun, 01 May 2022 06:28:18 GMT

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.

Re: Change source file

lioradam — Sun, 01 May 2022 12:49:33 GMT

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