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@lists.umanitoba.ca wrote:
Send EpiData-list mailing list submissions to epidata-list@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@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@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:
- Re: If..then (epidata-list@lists.umanitoba.ca)
- re: If..then (epidata-list@lists.umanitoba.ca)
- Re: EpiData-list Digest, Vol 55, Issue 19 Missing values is not NA (epidata-list@lists.umanitoba.ca)
---------- Forwarded message ---------- From: epidata-list@lists.umanitoba.ca To: epidata-list@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@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@lists.umanitoba.ca To: epidata-list@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@lists.umanitoba.ca To: epidata-list@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:
- If..then (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Wed, 28 May 2008 08:47:34 -0700 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] If..then To: epidata-list@lists.umanitoba.ca Message-ID: 897a5cf60805280847u3b99c66ak6f49e3855b879141@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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 55, Issue 19
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list