Traditional web-based reporting with SAS BI tools

Creating Clusters in SAS SPDS Environment

Reply
Contributor
Posts: 59

Creating Clusters in SAS SPDS Environment

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
SAS Employee
Posts: 238

Re: Creating Clusters in SAS SPDS Environment

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
Ask a Question
Discussion stats
  • 1 reply
  • 184 views
  • 0 likes
  • 2 in conversation