topic output a dataset with a dynamic name rather than staic name in SAS Programming

output a dataset with a dynamic name rather than staic name

kwu — Fri, 24 Sep 2010 17:59:24 GMT

I am trying to partition a input table and only want to go through the input table only once and based on the partition key to output to the table.
I wonder if it is possible to output obs to a dynamic dataset name.

what I plan to do is to sort the input dataset by the partition key variable, then output to a new dataset when a new partitionkey is detected. however, I could not find a way to specify a output dataset name dynamically.

any suggestion would be appreciated.

Re: output a dataset with a dynamic name rather than staic name

Patrick — Sat, 25 Sep 2010 00:19:58 GMT

Hi
I would say this can't be done with one pass through the data as the output data sets are defined during compilation time but you only know how many and which names of data sets you need during execution time.

A possible approach would be to add a data _null_ step creating the SAS syntax you need, write this syntax to a temporay file and then %include this file after the data _null_ step to get it executed.

HTH
Patrick

Re: output a dataset with a dynamic name rather than staic name

sbb — Sat, 25 Sep 2010 22:22:46 GMT

Using the DATA step and HASH technique, you have the OUTPUT() method that can dynamically create SAS files.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:
hash output method documentation site:sas.com

Re: output a dataset with a dynamic name rather than staic name

Patrick — Sun, 26 Sep 2010 10:59:24 GMT

Beautyful!
I didn't realise this possibility of hash object usage so far.

Thanks a lot, Scott!

Re: output a dataset with a dynamic name rather than staic name

data_null__ — Sun, 26 Sep 2010 15:12:21 GMT

This paper addresses the topic.

http://analytics.ncsu.edu/sesug/2008/SBC-119.pdf

Re: output a dataset with a dynamic name rather than staic name

kwu — Mon, 27 Sep 2010 14:16:07 GMT

Your guys are rock!!!
Thank you all very much indeed.