Date:         Wed, 30 Sep 2009 16:26:07 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: creating individual records from range
Comments: To: Nicole Bibb <nicole.bibb@blueshieldca.com>
In-Reply-To:  <200909302105.n8UJtwQt004497@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

I think you can use a lot of different procs to do this - proc freq with
LEVELS, proc expand, or the good old

data test;
set fmtset;
do value=start to end;
output;
end;
keep <things you are interested in>;
run;

-Joe


On Wed, Sep 30, 2009 at 4:05 PM, Nicole Bibb
<nicole.bibb@blueshieldca.com>wrote:

> I have a proc format I turned into a dataset. The problem now is the
> ftmname has a range of values attached. I need each value individually
> with the ftmname. For example,
>
> Ftmname    START    END
> BLUE         894    899
> RED          700    702
>
> I need a dataset like
>
> label     value
> BLUE      894
> BLUE      895
> BLUE8     896
> BLUE      897
> BLUE      898
> BLUE      899
> RED       700
> RED       701
> RED       702
> Not sure where to start...
>