Date:         Thu, 16 Nov 2006 07:22:02 GMT
Reply-To:     LWn <lars.wahlgren.pleasenospam@STAT.LU.SE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         LWn <lars.wahlgren.pleasenospam@STAT.LU.SE>
Organization: Telia Internet
Subject:      Re: Proc Tabulate or Proc Freq or Proc Report
Comments: To: sas-l@uga.edu

"Geethalakshmi B" <Geetha.Lakshmi@CLINIGENEINTL.COM> skrev i meddelandet
news:OF17577AFC.C9591C4F-ON65257228.0013BA17-65257228.0023878F@biocon.com...
> Please note the change in my e-MAIL Domain from BIOCON.COM to
> CLINIGENEINTL.COM.
> All future correspondence to me should be addressed to
> firstname.lastname@clinigeneintl.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
>

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