Date: Wed, 5 Jul 2006 04:48:17 -0400
Reply-To: Jim Groeneveld <jim2stat@YAHOO.CO.UK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jim Groeneveld <jim2stat@YAHOO.CO.UK>
Subject: Re: Create dataset names from variable values
The example SQL code, which I provided is not good.
The intention is to generate a list of unique values as a macro variable.
You could do that by (*untested*):
PROC FREQ DATA=YourData NOPRINT;
TABLES Variable / OUT=Scratch /* or whatever name */ (KEEP=Variable);
%LET Datasets = ; %* initialize empty list;
CALL EXECUTE ('%LET Datasets = &Datasets ' || LEFT(TRIM(Variable))
|| ';' );
%PUT List of datasets = &Datasets;
But there may be a nice SQL solution as well.
Regards - Jim.
Jim Groeneveld, Netherlands
Statistician, SAS consultant
On Wed, 5 Jul 2006 03:41:15 -0400, Donal Kelly <donal.kelly@CSO.IE> wrote:
>I am trying to split a dataset into 20 individual files and assign a
>dataset name based on the value of a certain variable within each dataset
>(see sample code below). I can split the file easily enough by looping
>through the Region ids, but I can't figure out how to pass the value of
>Region for each file to the dataset name.
>I've been trying to pass the value of Region to a macro variable but with
>ID Region Reg_ID
>01 North 1
>02 North 1
>03 South 2
>04 South 2
>05 East 3
>06 East 3
>07 West 4
>08 West 4
>Outcome > North.sas7bdat, South.sas7bdat etc. .
>I would appreciate any suggestions that are out there.