Date: Tue, 23 Oct 2001 13:54:26 -0400
Reply-To: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Subject: Re: how to make such data set
Content-Type: text/plain; charset="iso-8859-1"
Momo,
In that case:
(1) Create a data set that contains as many observations as days in a month.
Assign zero as the value of num. For example, this could form your base
data:
data base ;
do day = 1 to 31 ;
retain num 0 ;
output ;
end ;
run ;
(2) Output your actual data as one record per day in any one of the ways
suggested earlier.
(3) Update your base data with your actual data.
data updated ;
update base actual ;
by day ;
run ;
Kind Regards,
Venky
#****************************************#
# E-mail: venky.chakravarthy@pfizer.com #
# swovcc@hotmail.com #
# Phone: (734) 622-1963 #
#****************************************#
-----Original Message-----
From: momo [mailto:momozeus@YAHOO.COM.CN]
Sent: Monday, October 22, 2001 9:10 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: how to make such data set
thank you all!
and i want to ask another question
if i have the following data set
data set1;
input day;
cards;
1
1
1
2
3
3
.
.
;
and so on .in fact ,in my plan the variable day mean the day of the
month,if i want to build the next data set set2; that contain two variable
day num from set1,while day mean the day of month and num mean the thing
happen in that day
data set2;
input day num;
cards;
1 3
2 1
3 2
4 0
5 0
. .
and so on,then how can i do it
thanks
momo
|