topic Re: Can anyone help in creating a macro in SAS Programming

Can anyone help in creating a macro

anilsabs — Mon, 21 Nov 2016 18:14:11 GMT

In my folder there are multiple files,i just want to create a Sas dataset that contains only one variable which has the values excel file names,means it should fetch excel files names and store in one variable.

Re: Can anyone help in creating a macro

Reeza — Mon, 21 Nov 2016 18:16:38 GMT

SAS 9.4 Macro documentation has a set of examples, Example 2 is how to list all files in a directory, including sub directory. So this is a bit more than you want but can be modified to give you what you want.

http://support.sas.com/documentation/cdl/en/mcrolref/67912/HTML/default/viewer.htm#n0js70lrkxo6uvn1fl4a5aafnlgt.htm

Re: Can anyone help in creating a macro

anilsabs — Mon, 21 Nov 2016 18:20:39 GMT

Thanks for the solution provided Reeza. Can you help in writing the code and explain .

Re: Can anyone help in creating a macro

Reeza — Mon, 21 Nov 2016 18:24:51 GMT

Please review the link and give it a shot first. It has full code AND walks through it section by section below in more detail that I would.

If you have no sub-folders in your directory you can use it as is.