Date:         Mon, 2 Oct 2006 21:58:08 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: question on macro
Comments: To: jeri_ji@FREDDIEMAC.COM
In-Reply-To:  <OFDD2F6EDD.2F8CC837-ON852571FB.00769BAD-852571FB.0076ACA6@freddiemac.com>
Content-Type: text/plain; format=flowed

Jeri ,

Well the macro language isnt for new users even though they would like it to
be.

Try:

Data Need ;
Set Have ;

Do Range = 'Low' , 'Mid' , 'High' ;
  Output ;
End ;

Run ;




Toby Dunn

When everything is coming at you all at once, your in the wrong lane.

A truly happy person is someone who can smile and enjoy the scenery on a
detour.





From: Jeri Ji <jeri_ji@FREDDIEMAC.COM>
Reply-To: Jeri Ji <jeri_ji@FREDDIEMAC.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: question on macro
Date: Mon, 2 Oct 2006 17:36:13 -0400

I am a new sas user and have the following question.

I have some data look like this:

obs     age
1       36
2       24
And I need a data set look like this:
obs     age     Range
1       36      Mid
1       36      Low
1       36      High
2       24      Mid
2       24      Low
2       24      High

What can I do? Thanks a lot.

Jeri