[EpiData-list] found it! Re: EpiData-list Digest, Vol 55, Issue 20

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Tue Jun 10 14:28:26 CDT 2008


Hello!
managed to sort it out, pasting below the proper one if something fyi!

DISP1
  AFTER ENTRY
    IF (DRUG1="EFV") and (DOS1=600) and (DISP1>28) and (DISP1<101) THEN
      DAILYD1=1
      GOTO DRUG2
    ENDIF
    IF (DRUG1="EFV") and (DOS1=200) and (DISP1>118) and (DISP1<181) THEN
      DAILYD1=4
      GOTO DRUG2
    ENDIF
    IF (DRUG1="EFV") and (DOS1=200) and (DISP1>88) and (DISP1<110) THEN
      DAILYD1=3
      GOTO DRUG2
    ENDIF
  END
END


best regards
ziad


On Tue, Jun 10, 2008 at 12:08 PM, Ziad El-Khatib <ziad.khatib at gmail.com> wrote:
> Hi again,
> another question inline with previous query i posted last month, to
> have different -if..then- conditions (pasted below), when i test it,
> it does not write anything under DAILYD1 cell, as instructed below,
> any tips?
>
> DISP1
>  AFTER ENTRY
>    IF (DRUG1="EFV" & DOS1=600 & DISP1>29 & DISP1<101) THEN
>      DAILYD1=1
>    ELSE
>      IF (DRUG1="EFV" & DOS1=200 & DISP1>119 & DISP1<181) THEN
>        DAILYD1=4
>      ELSE
>        IF (DRUG1="EFV" & DOS1=200 & DISP1>89 & DISP1<110) THEN
>          DAILYD1=3
>          GOTO DRUG2
>        ENDIF
>      ENDIF
>    ENDIF
>  END
> END
>
>
>
>
>
> Thank you and best regards
> ziad
>
>
> On Thu, May 29, 2008 at 10:03 AM,
> <epidata-list-request at lists.umanitoba.ca> wrote:
>> Send EpiData-list mailing list submissions to
>>        epidata-list at lists.umanitoba.ca
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>        http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>> or, via email, send a message with subject or body 'help' to
>>        epidata-list-request at lists.umanitoba.ca
>>
>> You can reach the person managing the list at
>>        epidata-list-owner at lists.umanitoba.ca
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of EpiData-list digest..."
>>
>> EpiData-list mailing list
>> ___________________________________
>>
>> Today's Topics:
>>
>>   1. Re: If..then (epidata-list at lists.umanitoba.ca)
>>   2. re: If..then (epidata-list at lists.umanitoba.ca)
>>   3. Re: EpiData-list Digest, Vol 55,  Issue 19 Missing values is
>>      not NA (epidata-list at lists.umanitoba.ca)
>>
>>
>> ---------- Forwarded message ----------
>> From: epidata-list at lists.umanitoba.ca
>> To: epidata-list at lists.umanitoba.ca
>> Date: Wed, 28 May 2008 20:33:07 +0200
>> Subject: Re: [EpiData-list] If..then
>> Perhaps:
>>
>>  AFTER ENTRY
>>   IF v64="NA" THEN
>>     V65=9
>>     V66=9
>>     goto V67
>>   ENDIF
>>  END
>>
>>
>> Regards,
>>
>> Hans
>>
>>
>> epidata-list at lists.umanitoba.ca wrote:
>>>
>>> Hi,
>>> might be easy question, i am trying to write condition under check
>>> file to write value of 9 in 2 places if one cell equal to NA (code
>>> below), it does not work (and no error message), any tips?
>>>
>>>
>>>
>>> Thank you in advance
>>> best regards
>>> ziad
>>>
>>>
>>
>> --
>> Hans L Rieder, MD, MPH
>> Jetzikofenstr. 12
>> 3038 Kirchlindach
>>  Switzerland
>>
>> Tel: +41 31 829 4577
>> Mob: +41 79 321 9122
>> Web: http://www.tbrieder.org
>>
>>
>>
>>
>>
>> ---------- Forwarded message ----------
>> From: epidata-list at lists.umanitoba.ca
>> To: epidata-list at lists.umanitoba.ca
>> Date: Wed, 28 May 2008 23:33:56 +0200
>> Subject: [EpiData-list] re: If..then
>> Just split in three lines:
>>
>> after entry
>>  IF v64=NA THEN
>>  LET V65=9
>>  V66=9
>>    goto V67
>> ENDIF
>>
>>
>> regards
>> Jens Lauritsen
>> EpiData Association
>>
>>
>>
>> ---------- Forwarded message ----------
>> From: epidata-list at lists.umanitoba.ca
>> To: epidata-list at lists.umanitoba.ca
>> Date: Thu, 29 May 2008 09:05:47 -0300
>> Subject: [EpiData-list] Re: EpiData-list Digest, Vol 55, Issue 19 Missing values is not NA
>>  Dear friend Ziad,
>>
>> NA is common expression to identify missing values. If you are working with
>> R or S-Plus then NA is NA. That means that all functions or commands that
>> you want to specify NA, the expression is also NA. However, in Stata or
>> Epidata entry the NAs are epecified by dots (.) and sometimes by empty
>> quotes (" ") depending if the variable of interest is formated as numeric or
>> text. So, my guess is that your check command will work fine if do like
>> this...
>>
>> AFTER ENTRY
>>   IF v64=. THEN
>>     LET V65=9 & V66=9 & goto V67
>>   ENDIF
>> END
>>
>> Best regards,
>> Pedro Emmanuel
>>
>>
>>
>>> Today's Topics:
>>>
>>>   1. If..then (epidata-list at lists.umanitoba.ca)
>>>
>>>
>>> ----------------------------------------------------------------------
>>>
>>> Message: 1
>>> Date: Wed, 28 May 2008 08:47:34 -0700
>>> From: epidata-list at lists.umanitoba.ca
>>> Subject: [EpiData-list] If..then
>>> To: epidata-list at lists.umanitoba.ca
>>> Message-ID:
>>>        <897a5cf60805280847u3b99c66ak6f49e3855b879141 at mail.gmail.com>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>>
>>> Hi,
>>> might be easy question, i am trying to write condition under check
>>> file to write value of 9 in 2 places if one cell equal to NA (code
>>> below), it does not work (and no error message), any tips?
>>>
>>>  AFTER ENTRY
>>>    IF v64=NA THEN
>>>      LET V65=9 & V66=9 & goto V67
>>>    ENDIF
>>>
>>>
>>> Thank you in advance
>>> best regards
>>> ziad
>>>
>>>
>>> ------------------------------
>>>
>>> ________________________________________
>>> EpiData-list at lists.umanitoba.ca
>>> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>>>
>>>
>>> End of EpiData-list Digest, Vol 55, Issue 19
>>> ********************************************
>>>
>>
>>
>> ________________________________________
>> EpiData-list at lists.umanitoba.ca
>> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>>
>>
>


More information about the EpiData-list mailing list