Proc Tabulate or Proc Freq or Proc Report

Proc Tabulate or Proc Freq or Proc Report

Post by Geetha.Lak » Fri, 17 Nov 2006 12:15:52


Please note the change in my e-MAIL Domain from BIOCON.COM to CLINIGENEINTL.COM.
All future correspondence to me should be addressed to XXXX@XXXXX.COM


Dear All,

I have a data set like this:

(Embedded image moved to file: pic02082.jpg)

I wanted the output in this format,

(Embedded image moved to file: pic22929.jpg)

Which Procedure to use. Thanks in Advance.

Regards,
Geetha.
__________________________________________________________________________
Confidentiality Statement
The Information attached herewith is strictly confidential and for the
authorised use of the intended recipient only. If you are not the intended
recipient, please notify the sender or Biocon Limited immediately.
__________________________________________________________________________
BIOCON LIMITED, 20th K. M. Hosur Road, Electronic City P.O
Bangalore-560 100, INDIA Website : www.biocon.com
Phone: 00-91-80-2808 2808 Fax: 00-91-80-2852 34 23
 
 
 

Proc Tabulate or Proc Freq or Proc Report

Post by Geetha.Lak » Fri, 17 Nov 2006 15:27:51

Please note the change in my e-MAIL Domain from BIOCON.COM to CLINIGENEINTL.COM.
All future correspondence to me should be addressed to XXXX@XXXXX.COM


Dear Howard,

Very sorry, it was copied and pasted from Excel.

Existing data set:

a b c d
1 2 3 45.2
2 2 3 69.8
3 2 3 58.2
1 3 3 56.2
2 3 3 98.6
3 3 3 48.2


Required output:

a b c d
1 45.2
2 2 3 69.8
3 58.2
1 56.2
2 2 3 98.6
3 48.2


Thanks & Regards,
Geetha.



"Howard Schreier
<hs AT dc-sug DOT
org>" To
Geethalakshmi B
16/11/2006 09:01 < XXXX@XXXXX.COM >
AM cc

Subject
Re: Proc Tabulate or Proc Freq or
Proc Report










Pictures are not allowed. Please present your examples as text.

On Thu, 16 Nov 2006 08:45:52 +0530, Geethalakshmi B


CLINIGENEINTL.COM.
XXXX@XXXXX.COM



__________________________________________________________________________
Confidentiality Statement
The Information attached herewith is strictly confidential and for the
authorised use of the intended recipient only. If you are not the intended
recipient, please notify the sender or Biocon Limited immediately.
__________________________________________________________________________
BIOCON LIMITED, 20th K. M. Hosur Road, Electronic City P.O
Bangalore-560 100, INDIA Website : www.biocon.com
Phone: 00-91-80-2808 2808 Fax: 00-91-80-2852 34 23

 
 
 

Proc Tabulate or Proc Freq or Proc Report

Post by LWn » Fri, 17 Nov 2006 16:22:02


"Geethalakshmi B" < XXXX@XXXXX.COM > skrev i meddelandet


If your problem is exactly as above try this data step.

data Existing ;
input a b c d ;
datalines ;
1 2 3 45.2
2 2 3 69.8
3 2 3 58.2
1 3 3 56.2
2 3 3 98.6
3 3 3 48.2
;;;;

data Required ;
set Existing ;
if a ne 2 then do ;
b = . ; c = . ;
end ;
run ;


HTH / LWn
 
 
 

Proc Tabulate or Proc Freq or Proc Report

Post by nospa » Sat, 18 Nov 2006 13:07:49

n Thu, 16 Nov 2006 11:57:51 +0530, Geethalakshmi B
< XXXX@XXXXX.COM > wrote:

CLINIGENEINTL.COM.
XXXX@XXXXX.COM

I can see the pattern (except for the second "2" on the 5th line of output).
I cannot see the rationale. Please describe what is being done, and why.