Hi,   I need help in concatenation. I have two variables : ID Agent and Agentoth (all CHAR) Sample data:              01 Steriods     ABC                                    02 Other          XYZ                                    03 ATG Expected out put is : Agent,agentoth   data med; by ID; attrib AGENT_ length=$100; if index(lowcase(AGENT),"other")>0 then do; AGENT_= "Other, "|| AGENTOTH; end; if AGENT_ =" " then AGENT_ = AGENT; output step_01_dat_final; run; This code above concatenates only if the agent name is 'Other'. I need to concatenate if there is anything in the Agenoth, else leave. Any suggestions? Thank you,   Regards, Nasya   ... View more

Hi,   Please find the code below. Basing on one of the following conditions are TRUE/FALSE=, the output EARLYD is generated as YES or NO. There are multiple records for one ID. However, I am having trouble generating the F_EarlyD(column). I have attached the excel with the expected output for reference.   Any help is appreciated. data d4; attrib EarlyD length=$4; by ID; if (upcase (AUNIT) = 'U/L' AND (AT > 2000)) or (upcase (AUNIT) = 'μkat/L' AND (AT > 33.3)) or (upcase (AST) = 'BILIRUBIN LEVEL' AND upcase(ASUNIT) = 'MG/DL' AND (ASUNIT > = 10)) or (upcase(AST) = 'BILIRUBIN LEVEL' AND upcase(ASUNIT) = 'μMOL/L' AND (ASUNIT > = 171.0367)) or (upcase(AST) eq 'INR LEVEL' AND (ASUNIT >= 1.6)) or (upcase(PRIMYN) = 'Yes') then EarlyD="Yes"; else EarlyD="No"; run; Output_Expected: ID EarlyD? F_EarlyD 01-001 Yes Yes 01-001 No   01-001 No   01-001 No   01-001 No   01-001 No   01-001 No   01-002 No No 01-002 No   01-003 Yes Yes 01-004 Yes Yes 01-004 Yes   01-004 Yes   01-005 No No 01-005 No   01-005 No         Thank you,   Regards, Nasya ... View more

Hi, I am trying the following code and can some one let me know where this is going wrong? I am trying to compare all the terms from AE and with the ' if ' condition display the output as NEW/NO CHANGE/UPDATED. data final; merge der1_ (in=a) der4_ (in=b) ied (in=c) dmr (in=d) rfr(in=e); by UNOSID; if b; keep SUBJECT AETERM AESEV AESER YESREAS AEREAD AEINTROP AEREL AEANT AESTDAT_ AEENDAT_ AEACN AEACNSP AEOUT LPSDAT_ PULREL AEYES AECM TDDAT_ TDDAYS SEX_D DTHDAT_ AGE_D DTHCAU DTHCAUSP ARREST HOSPDDAT_ DDIS RRINDIC RRINDOT RRCINDIC RFHEPC RFCANCER SEX AGE MELD INC4 EAD; run; proc sort data=final NODUPKEY; by _ALL_; RUN; proc sort data=final out=c_final ; by SUBJECT; run; proc sort data=previous.final out=o_final(rename=(AETERM =o_AETERM AESEV=o_AESEV AESER=o_AESER YESREAS=o_YESREAS AEREAD=o_AEREAD AEINTROP=o_AEINTROP AEREL=o_AEREL AEANT= o_AEANT AESTDAT_=o_AESTDAT_ AEENDAT_=o_AEENDAT_ AEACN=o_AEACN AEACNSP=o_AEACNSP AEOUT=o_AEOUT LPSDAT_=o_LPSDAT_)); by SUBJECT; run; /* Create a new dataset with the new variable STATUS. STATUS is reflected in the output as NO CHANGE, UPDATED accordingly*/ data current.final; attrib STATUS length=$25.; merge c_final(in=a) o_final(in=b keep=SUBJECT o_AETERM o_AESEV o_AESER o_YESREAS o_AEREAD o_AEINTROP o_AEREL o_AEANT o_AESTDAT_ o_AEENDAT_ o_AEACN o_AEACNSP o_AEOUT o_LPSDAT_); by SUBJECT; if a and b then do; if ((AETERM = o_AETERM , (AESEV=o_AESEV , (AESER=o_AESER , (YESREAS=o_YESREAS , (AEREAD=o_AEREAD, (AEINTROP=o_AEINTROP, (AEREL=o_AEREL, (AEANT= o_AEANT, (AESTDAT_=o_AESTDAT_, (AEENDAT_=o_AEENDAT_, (AEACN=o_AEACN, (AEACNSP=o_AEACNSP, (AEOUT=o_AEOUT, (LPSDAT_=o_LPSDAT_ ))))))))))))))) then do; Status='No Change'; end; if (AETERM ne o_AETERM, (AESEV ne o_AESEV, (AESER ne o_AESER, (YESREAS ne o_YESREAS, (AEREAD ne o_AEREAD, (AEINTROP ne o_AEINTROP, (AEREL ne o_AEREL, (AEANT ne o_AEANT, (AESTDAT_ ne o_AESTDAT_, (AEENDAT_ ne o_AEENDAT_, (AEACN ne o_AEACN, (AEACNSP ne o_AEACNSP, (AEOUT ne o_AEOUT, (LPSDAT_ ne o_LPSDAT_)))))))))))))) then do; if a ne b then do; Status='Updated'; end; if a and not b then do; Status='New'; output; end; run; This error is popping up. Any help is appreciated. ! (AEACNSP=o_AEACNSP, (AEOUT=o_AEOUT, (LPSDAT_=o_LPSDAT_ )))))))))))))) then do; ERROR 22-322: Syntax error, expecting one of the following: (, [, {.   ERROR 76-322: Syntax error, statement will be ignored.   Thank you,   Regards, Nasya   ... View more