Date:         Thu, 30 Oct 2003 10:11:59 -0500
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Inserting raws in a dataset
Comments: To: Franz <franz_cl2003@YAHOO.FR>
Content-Type: text/plain

Franz:
It appears to me that you are trying to create titles for each var_1 group.
For that SAS provides displays (PROC PRINT, REPORT, etc.) BY <variable> with
titles preceding each BY group. You do not have to make a dataset look like
a data display prior to printing it or displaying it in a window.
Sig

-----Original Message-----
From: Franz [mailto:franz_cl2003@YAHOO.FR]
Sent: Thursday, October 30, 2003 9:54 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Inserting raws in a dataset


Dear all,

Here is the situation I have:

var_1   var_2

1       aaaa
1       bbbb
1       cccc
2       dddd
2       eeee
2       fffff
2       gggg
3       hhhh
3       pppp
4       kkkk

I would like to create a third variable (text)
the following way:
BEFORE the first occurence of a var_1 value
(1,2,3 or 4) I would like to define the value
of the new variable text, so that for the new
observations in the dataset will have missing
values for var_1 and var_2.

var_1   var_2   text
                 t_1
1       aaaa
1       bbbb
1       cccc
                 t_2
2       dddd
2       eeee
2       fffff
2       gggg
                 t_3
3       hhhh
3       pppp
                 t_4
4       kkkk


Any help?

Many thanks & kind regards,
Franz.




__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/