Date:         Wed, 6 Jul 2005 04:36:25 +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: need help in solving this problem
Comments: To: shankardasm@GMAIL.COM
In-Reply-To:  <1120624128.006169.222480@g47g2000cwa.googlegroups.com>
Content-Type: text/plain; format=flowed

Shanks,

No offense but his sounds an awful lot like a homework question.

Now You will need to look into Proc Report and Data _null_, By group
processing and/or class statement, and finally my advice is if you don't how
to do the afore mentioned then forget the macro as it will cause your more
headachs than you have asprin.

Now having said that if you want help, then help us help by providing a
small sample datasetand what you expect the results to be.

Also would you like that in generic SAS output form, RTF, PDF, HTML, Excel
file, Access file?



Toby Dunn




From: shanky <shankardasm@GMAIL.COM>
Reply-To: shanky <shankardasm@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: need help in solving this problem
Date: Tue, 5 Jul 2005 21:28:48 -0700


Hello everyone:

Situation: A department store is having different products. The input
includes store number, product number, whether the product is brought
or sold, date of transaction in mmddyy10 format, unit price  and # of
units transacted.

Problem 1: I have to create a table for displaying following
information: Listing by store the store, products bought, total worth
of products bought.

Problem 2: the products can be sold only after they are bought in a
particular store. I would like to know how i can clean the data and
output the errors.

Problem 3: Proc freq will show which products are bought across all
stores. I would like to know can i get the same information using 1)
any other "PROC" and 2) only using DATA step and no "proc"

Problem 4: I want to output a dataset showing for each store: the
earliest purchase date, earliest sale date and total profit for each
product.

Problem 5: a macro for each store to show information across products.

Thanks in advance;

Shanks