topic Automated code for monthly file update in New SAS User

Automated code for monthly file update

sheetalmahana — Thu, 04 Oct 2018 10:51:47 GMT

Hi,

I am using SAS EG 9.4. I have to update monthly data using SAS. Monthly files are named in raw_file_<mmm-yy> format. Columns in all the files are in same order. Below is the code that I used for 2 months- Jul and Aug 18. However, now i need to this activity for past 1 year in same format. Going forward, i will have to do this activity for every month. After this, i need to merge all this files into 1 master file for further analysis. Please help in automating the code using macro to make it efficient and fast.

data work.raw_file_Jul18;

FORMAT

year_month date9.

Name $char12.

Age BEST8.

department $char12.

salary dollar12.2;

INFORMAT

year_month date9.

Name $char12.

Age BEST8.

department $char12.

salary dollar12.2;

infile "c:/user/data_Jul18"

dlm=';'

MISSOVER
DSD
firstobs=2
lrecl = 32767 ;

input

year_month date9.

Name $char12.

Age BEST8.

department $char12.

salary dollar12.2;

run;

Re: Automated code for monthly file update

RW9 — Mon, 01 Oct 2018 10:34:06 GMT

Need further information. What software are you using. Where is the file (sftp, local drive etc.)? What is the file called? Do you have command line access? Is the file the same each time - i.e. do you have an import agreement which shows the structure? Anything else needed for the append - date calculation etc.?

In theory its just a matter of importing the file and then appending to the existing data, but that is with the very little information you have presented.

Re: Automated code for monthly file update

sheetalmahana — Thu, 04 Oct 2018 11:47:46 GMT

Hi RW9, Added more information to the question. Hope this helps. thanks in advance

Re: Automated code for monthly file update

RW9 — Thu, 04 Oct 2018 12:24:48 GMT

Reeza has already published a page on this topic, with code shown:
https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627