topic Re: Create Folder in XYTHOS in SAS Procedures

Create Folder in XYTHOS

RussellAlmeida — Mon, 15 Feb 2010 13:27:11 GMT

Hi,

I have a set of PDF Files with the following format
RD007_123.pdf,
RD006_123.pdf,
RD007_234.pdf,
RD001_235.pdf
where the value 123,234, 235 etc are the unit numbers, there are 1000 Unis and new can be added dynamically.

My requirement is to have a folder 123,234,235 created dynamically in Xythos using SAS or any other tool and then inside this XYTHOS Folder move the files
RD007_123.pdf,
RD006_123.pdf,
RD007_234.pdf,
RD001_235.pdf to their respective unit folder.

Please suggest.

OS: AIX
SAS Version: SAD 9.1.3

Regards
Russell

Re: Create Folder in XYTHOS

SAPPER — Mon, 15 Feb 2010 14:58:18 GMT

I dont think there's a direct way to read PDF files into SAS.
Please go through this discussion where using a 3rd party tool people were able to load PDF data into SAS.
http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/01bf795c710e3013/bf2442313e4c0eff?lnk=raot

Once data is in SAS, we can use the FILE statement with the MOD option to dynamically add multiple datasets to a single file.

http://support.sas.com/documentation/cdl/en/hostwin/61924/HTML/default/chfoptfmain.htm

Thanks
SAPPER

Re: Create Folder in XYTHOS

sbb — Mon, 15 Feb 2010 16:05:49 GMT

You're looking at using SAS FILENAME with the "PIPE" engine in order to read up the OS directory information and generate suitable command invocations against your files and directories.

Suggest reviewing the SAS Companion for AIX as well as the SAS functions related to files and directories for your OS, documented in the SAS Language guide.

Also, there are supplemental technical/conference paper references on the SAS support http://support.sas.com/ website available.

Scott Barry
SBBWorks, Inc.

Re: Create Folder in XYTHOS

DanielSantos — Mon, 15 Feb 2010 17:38:16 GMT

From what I understand you just need to compose and issue the right system commands.

There is more than a way to issue a system commando through SAS, one of which, being the X statement,

See here:
http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a000212624.htm

From there, you can run any system command that you wish.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: Create Folder in XYTHOS

Cynthia_sas — Tue, 16 Feb 2010 01:39:55 GMT

Hi:
It was my understanding that you used XYTHOS with the SAS Enterprise Intelligence Platform web-tier or "middle-tier". I thought that the XYTHOS folders were administered and created and managed with the XYTHOS software. For example, when you write Web Report Studio reports to XYTHOS folders, the folders need to be in existence. I'm not sure about creating/using/administering the XYTHOS folders in batch mode. That might be a question for Tech Support.

Here are some documents and references:
http://support.sas.com/rnd/itech/doc9/admin_oma/security/security_accessdav_ex.html
http://support.sas.com/techsup/technote/ts776.pdf
http://www2.sas.com/proceedings/forum2008/392-2008.pdf
http://support.sas.com/resources/papers/proceedings09/006-2009.pdf

cynthia