Creating Clusters in SAS SPDS Environment

tejeshwar — Mon, 23 Aug 2010 09:51:29 GMT

Hi,

I am trying to create a cluster on a large data in an SPDS environment based on actual dates. I am trying to create 24 members storing 24 months of history from a large SPD table "acquisition_tb" on libname "train". Also each member will store month worth of data based on a date named "entered_date". for ex: if the entered_date is between 01 - 29th Jan then store in member 1, if between 30th Jan-28th Feb then store in member 2. Can anyone share a SAS syntax to accomplish the same.

Thanks so much for the help.

Regards,
Tej Message was edited by: tejeshwar

Re: Creating Clusters in SAS SPDS Environment

AngelaHall — Mon, 23 Aug 2010 13:42:45 GMT

In Base SAS you can output a single data set into to multiple tables with one DATA step. This might be sufficient for you when attempting to parse out tables.
Here is an example:

data test1 test2;
set sashelp.shoes;
if region='Canada' then output test1;
else if region='Africa' then output test2;
run;

~ Angela
http://sas-bi.blogspot.com

topic Creating Clusters in SAS SPDS Environment in SAS Web Report Studio

Creating Clusters in SAS SPDS Environment

Re: Creating Clusters in SAS SPDS Environment