Date: Fri, 25 Feb 2005 02:34:23 -0800
Reply-To: Dan <shao_chieh@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dan <shao_chieh@YAHOO.COM>
Organization: http://groups.google.com
Subject: Outputting the frequency beside the dataset
Content-Type: text/plain; charset="iso-8859-1"
Hi!
This is the original dataset:
Stock Date
AA 12/12/2002
AA 12/12/2002
AA 12/12/2002
BB 12/12/2002
BB 12/12/2002
AA 12/13/2002
AA 12/13/2002
BB 12/13/2002
AA 12/14/2002
BB 12/14/2002
BB 12/14/2002
AA 12/15/2002
AA 12/15/2002
AA 12/15/2002
AA 12/15/2002
BB 12/15/2002
This is the output in the data set form;
Stock Date FREQ
AA 12/12/2002 3
AA 12/12/2002 3
AA 12/12/2002 3
BB 12/12/2002 2
BB 12/12/2002 2
AA 12/13/2002 2
AA 12/13/2002 2
BB 12/13/2002 1
AA 12/14/2002 1
BB 12/14/2002 2
BB 12/14/2002 2
AA 12/15/2002 4
AA 12/15/2002 4
AA 12/15/2002 4
AA 12/15/2002 4
BB 12/15/2002 1
The objective is the output the frequency by stock and date and output
the relevant frequency beside the date.
Could someone help me? Thanks alot.
Kind regards,
Daniel