Date:         Wed, 4 Apr 2001 07:15:28 -0500
Reply-To:     "Workman, Rob" <Rob.Workman@SULZERCARBOMEDICS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Workman, Rob" <Rob.Workman@SULZERCARBOMEDICS.COM>
Subject:      Re: Macro help
Comments: To: "Richard.Simhon@CORNHILL.CO.UK" <Richard.Simhon@CORNHILL.CO.UK>
Content-Type: text/plain; charset="iso-8859-1"

Richard,

The problem may be that somehow the macro variable var3 is resolving to
nothing.  I would first check that %clean is being invoked correctly with
the named parameters.  I was able to create the error message you described
using this code:

3    data _null_;
4      if in('stuff');
          --
          68
5    run;

ERROR 68-185: The function IN is unknown.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: The DATA statement used 0.11 seconds.

Kind regards,

Rob Workman

-----Original Message-----
From: (richard Simhon) [mailto:Richard.Simhon@CORNHILL.CO.UK]
Sent: Wednesday, April 04, 2001 5:40 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Macro help


SAS-lers

Can anyone help with the macro below. When I submit this I get a message in
the log informing me that the IN function is unknown. Can anyone tell me why
this is as in a non macro format the data step works fine!

%macro clean (var3=,data2=,data1=);
  %let month=%upcase(&month);
  %let year=%upcase(&year);
  %let var1=%upcase(&var3);
  %local varlists;
  %let varlists=%str( YEAR POLST MEMB C_AREA BEDS CLMS_NO P_TYPE PROPAGE
PROPUSE MARRIED DOB INCEPT C_XS B_XS NO_PAYT REF_INS P_TYPE
                     P_AREA CNCD_ID BNCD_ID SLF_CNT CON_TYP REPAIR UNOC_DY
UNOC_EV UNOC_MT SUBS_VN SUBS_EV CONV JVSI C_CLMS B_CLMS
                     POL_AGE );
    %if %index(&varlists,%str( &var3 )) >0
      %then %do;
        data aa&&month.&year;
         set house.aa&&month.&year;
         if &var3 in ("&data1") then &var3=&var3; else
         if &var3 in (" ",".") then &var3=" "; else
            &var3=&data2;
        run;
    %end;
%mend clean;

Thanks in advance

Richard Simhon
Business Analyst
Allianz Cornhill
Tel +(44) 01483 552628






**********************************************************************
Copyright in this message and any attachments remains with us.  It is
confidential and may be legally privileged.   If this message is not
intended for you it must not be read, copied or used by you or
disclosed to anyone else.   Please advise the sender immediately if
you have received this message in error.

Although this message and any attachments are believed to be free of
any virus or other defect that might affect any computer system into
which it is received and opened it is the responsibility of the
recipient to ensure that it is virus free and no responsibility
is accepted by Cornhill Insurance PLC for any loss or damage in any
way arising from its use.

Cornhill Insurance Plc, Registered in England number 84638,
Registered Office 32 Cornhill, London EC3V 3LJ.

Regulated by the Personal Investment Authority for life and pensions only.
Member of the General Insurance Standards Council for direct general
insurance only.
**********************************************************************