Date: Sat, 10 Sep 2011 09:30:36 -0500
Reply-To: "Data _null_;" <iebupdte@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Data _null_;" <iebupdte@GMAIL.COM>
Subject: Re: Need HELP
In-Reply-To: <1315636581.78666.YahooMailNeo@web95612.mail.in.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1
This example should work better than my last non working example. As
far as I can figure you will need an alias for each order/group
variable you want to have printted on every row. You could instead
sort the data and use DISPLAY for all varibles.
proc report data=sashelp.class nowd list headline;
columns sex sex=sex2 name age;
define sex / order noprint;
define sex2 / order;
define name / display;
define age / display;
compute before sex;
*rc = seechar(sex);
rsex = sex;
endcomp;
compute sex2;
sex2 = rsex;
endcomp;
run;
On Sat, Sep 10, 2011 at 1:36 AM, Vishali Rajiv <vishalirajiv@yahoo.com> wrote:
> Hi,
>
>
> can any one give me the solution for the below output.
>
> Name sname transcation amount
> -------------------------------
> peter loma usa 300
> europe 400
> Nelson olll usa 500
> europe 600
> India 700
>
> I am getting above output, after grouping with the proc report I had group the name and location ,after grouping i am getting above output but my lient wants the format of out like below,I have applied only "DISPLAY " statement with out group ,but some of my another columns were getting blanks .
>
> Name sname transcation
> -------------------------------
> peter loma usa 300
> peter loma europe 400
> Nelson olll usa 500
> Nelson olll europe 600
> Nelson olll India 700
>
>
> any one can help me with the SAS Code.I had group the name and location ,after grou
>
> Thanks.
>
| 
