topic Re: Proc Append Monthly Data in SAS Studio

Proc Append Monthly Data

DME790 — Thu, 13 Feb 2020 23:02:08 GMT

Hi All,

a lot rusty with SAS but getting back into using it.

I need to append monthly data sets to an existing SAS Table called HolData. The new data is in /folders/myfolders/Data/November.xlsb.

This is what I have so far - any help is appreciated.

FILENAME REFFILE '/folders/myfolders/Data/November.xlsb';

Proc append data=  out=work.HolData;

Run;

Cheers

Dean

SASKiwi — Fri, 14 Feb 2020 00:54:53 GMT

proc append base = Mylib.HolData
                     data = Mylib.MonthlyData
                     ;
run;
quit;

Tom — Fri, 14 Feb 2020 02:58:22 GMT

The first thing you will probably need to do is convert the file to a readable format. Open it in Excel and save it as an XLSX file instead.