Importing text data from a 'Queue'

TimCampbell — Fri, 04 Jan 2013 13:52:10 GMT

Hi all,

My next project in SAS will involve setting up some scheduled jobs in DI studio to import some set format text files into SAS from a 'file queue' like setup.

The basic setup will need to be that SAS will

check a directory for new files
Import the new file whilst checking data etc.
Move the imported file to a 'Done' subdirectory if successful

I am fairly confident with how the import and formatting process will need to work and setting up the jobs to run on a regular schedule or even monitor the folder for new files however i am not sure how to get SAS to move the physical text files around once they have been processed.

Has anyone had to do this before or has an idea on what i would need to make this happen?

If it helps, the server that is running the code is Linux.

Thanks in advance,

Tim

Re: Importing text data from a 'Queue'

ballardw — Fri, 04 Jan 2013 16:13:39 GMT

You can check directory and file status using the DINFO and FINFO functions and related, see the online help for examples.

The X command in SAS sends sytem commands to the OS such as copying, deleting or moving files. Actually anything you can instruction you can do with a command line can be done with the X command.

topic Importing text data from a 'Queue' in SAS Programming

Importing text data from a 'Queue'

Re: Importing text data from a 'Queue'