Dear,   In my data set the following variable present.  if there is any change (variable CHG) by id and avisitn, greater than 10, then i need to populate (chgcat1='Max increase >10') for all obs having same id and avisitn   id                    avisitn                   chg                 test 1                       2                          8                     sbp 1                        2                          9                    sbp 1                       2                          7                     sbp 1                        3                          12                   dbp 1                       3                           4                      dbp 2                      1                           10                   sbp 2                      1                            11                   sbp 2                     1                              5                     sbp 2                      1                             4                     sbp output needed id                          avisitn                      chg                                chgcat1 1                            2                               8 1                            2                               9 1                            2                               7 1                            3                               12                             Max increase >10 1                            3                                 4                             Max increase >10 2                           1                               10                            Max increase >10 2                           1                               11                              Max increase >10 2                           1                                5                                Max increase >10 2                           1                                4                                 Max increase >10   The chgcat1 is blank for first 3 obs because none of the obs with id=1 and avisitn=2 have chg greater than 10.   I think i can do this in two data steps. is there any way I can in one step as i have to calculate 12 chgcat. Thanks ... View more

Dear,   In my datasets the following values present. my code works for all obs except these obs. Please help thanks.   ex   id    exdate                      exdose 1      09MAY2016                50 1      09MAY2016                100   ae id             aedate                  1          09MAY2016   code; proc sql; create table dose as select a.*,b.exdose from ae as a left join EX as b on a.id=b.id and a.Aedate-b.exdate >=0 group by a.id,a.aedate having a.Aedate-b.exdate1=min(a.Aedate-b.exdate); quit;   output getting ;   id             aedate                   exdose 1               09MAY2016              50   output need; id             aedate                   exdose 1               09MAY2016              100 ... View more

Dear, I posted this question today morning. The subject that I gave is different than what I posted. That's why I am posting again. Sorry.   In my data the following value is present. My code gave the output i need for all obs except for this value. With my code the value is split into five variables rather than four. In the vendor data, the value is split into 4 variables. I analysed it. I found in the second variable('value2' in the output needed), the length reaches exactly 200. With my code it truncates before. Please help in my code. Thanks   value The OOO re-trained the site staff on re-conoooting current/active suooocts under the updated main OOO at screening. The site staff printed out the updated OOO and included it in the sooject source documents with a note to use the OOO at the subject's next site visit. The site staff created a note-to-file and reported this doooation to the OOO. The site staff will obtain the subject's re-consent during their next visit for the Oooo 00-000 study. The OOO will verify the OOO has been completed at the next OOO. The OOO reminded the site staff to work with the subject at their next Oooo 00-000 visit to obtain the missing consent signature, otherwise the site staff should document/update their note to file in source to reflect in the inability to obtain the signature (update 00JON2000).   code   data one; length temp $200; set data; n+1; do i=1 to countw(value,''); temp=scan(value,i,' ');len=length(temp)+1;output; end; run;   data two; set one; by n; retain sum; if first.n then sum=0; sum+len; if sum gt 200 then do;group+1;sum=len;end; run;   data three; length output $ 200; do until(last.group); set two; by n group; output=catx(' ',output,temp); end; run;   output needed; value1                           The OOO re-trained the site staff on re-consenting current/active subjects under the updated main OOO at screening. The site staff printed out the updated OOO and included it in the subject source         value2 documents with a note to use the OOO at the subject's next site visit. The site staff created a note-to-file and reported this deviation to the OOO. The site staff will obtain the subject's re-consent   value3 during their next visit for the Oooo 00-000 study. The OOO will verify the OOO has been completed at the next OOO. The OOO reminded the site staff to work with the subject at their next Oooo 00-000   value4   visit to obtain the missing consent signature, otherwise the site staff should document/update their note to file in source to reflect in the inability to obtain the signature (update 00JON2000).     output getting;     value1 The OOO re-trained the site staff on re-consenting current/active subjects under the updated main OOO at screening. The site staff printed out the updated OOO and included it in the subject source   value2 documents with a note to use the OOO at the subject's next site visit. The site staff created a note-to-file and reported this deviation to the OOO. The site staff will obtain the subject's   value3 re-consent during their next visit for the Oooo 00-000 study. The OOO will verify the OOO has been completed at the next OOO. The CRA reminded the site staff to work with the subject at their next   value4 Oooo 00-000 visit to obtain the missing consent signature, otherwise the site staff should document/update their note to file in source to reflect in the inability to obtain the signature (update    value5 21JUN2016). ... View more

Dear,   In my data the following value is present. My code gave the output i need for all obs except this value. With the code the value is split into five variables rather than four. Please help in my code. Thanks   value The OOO re-trained the site staff on re-conoooting current/active suooocts under the updated main OOO at screening. The site staff printed out the updated OOO and included it in the sooject source documents with a note to use the OOO at the subject's next site visit. The site staff created a note-to-file and reported this doooation to the OOO. The site staff will obtain the subject's re-consent during their next visit for the Oooo 00-000 study. The OOO will verify the OOO has been completed at the next OOO. The OOO reminded the site staff to work with the subject at their next Oooo 00-000 visit to obtain the missing consent signature, otherwise the site staff should document/update their note to file in source to reflect in the inability to obtain the signature (update 00JON2000).   code   data one; length temp $200; set data; n+1; do i=1 to countw(value,''); temp=scan(value,i,' ');len=length(temp)+1;output; end; run;   data two; set one; by n; retain sum; if first.n then sum=0; sum+len; if sum gt 200 then do;group+1;sum=len;end; run;   data three; length output $ 200; do until(last.group); set two; by n group; ouput=catx(' ',output,temp); end; run;   output needed; value1                           The OOO re-trained the site staff on re-consenting current/active subjects under the updated main OOO at screening. The site staff printed out the updated OOO and included it in the subject source         value2 documents with a note to use the OOO at the subject's next site visit. The site staff created a note-to-file and reported this deviation to the OOO. The site staff will obtain the subject's re-consent   value3 during their next visit for the Oooo 00-000 study. The OOO will verify the OOO has been completed at the next OOO. The OOO reminded the site staff to work with the subject at their next Oooo 00-000   value4   visit to obtain the missing consent signature, otherwise the site staff should document/update their note to file in source to reflect in the inability to obtain the signature (update 00JON2000).     output getting;     value1 The OOO re-trained the site staff on re-consenting current/active subjects under the updated main OOO at screening. The site staff printed out the updated OOO and included it in the subject source   value2 documents with a note to use the OOO at the subject's next site visit. The site staff created a note-to-file and reported this deviation to the OOO. The site staff will obtain the subject's   value3 re-consent during their next visit for the Oooo 00-000 study. The OOO will verify the OOO has been completed at the next OOO. The CRA reminded the site staff to work with the subject at their next   value4 Oooo 00-000 visit to obtain the missing consent signature, otherwise the site staff should document/update their note to file in source to reflect in the inability to obtain the signature (update    value5 21JUN2016).                                          ... View more

Dear,   In my data, the following values are present. I am not  getting the output I need with my code. Please help. Thanks.   value ALLEGRA-D /01367401/ AMOXICILLIN W/CLAVULANATE POTASSIUM ASCORBIC ACID W/BETACAROTENE/BIOTIN/08634701/ BUDESONIDE W/FORMOTEROL FUMARATE ESOMEPRAZOLE MAGNESIUM HYDROCODONE COMPOUND /01224801/   output needed; ALLEGRA-D  AMOXICILLIN W/CLAVULANATE POTASSIUM ASCORBIC ACID W/BETACAROTENE/BIOTIN BUDESONIDE W/FORMOTEROL FUMARATE ESOMEPRAZOLE MAGNESIUM HYDROCODONE COMPOUND    code:  value1=compress(value,'','d');   output getting; ALLEGRA-D// AMOXICILLINW/CLAVULANATE POTASSIUM ASCORBICACID W/BETACAROTENE/BIOTIN// BUDESONIDEW/FORMOTEROLFUMARATE ESOMEPRAZOLEMAGNESIUM HYDROCODONECOMPOUND// ... View more

Dear,   I attached a notepad file containing first 5 rows from a csv file. I used the following code. It worked. But I am not understanding why I have use firstrow=6 rather than firstrow=5 when the data starts in the 5 row.   data dv; infile "C:\Users\tt\Desktop\three.csv" delimiter=',' firstobs=6 missover dsd; format Screening_no DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired $200.; input Deviation_no Screening_no Subject DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired; run; ... View more

Hi,   I have to merge two data sets. For second OBS, I have to concatenate two values from data2 because data1 has aen1 and aen2 values are populated. How to merge the values . Please help. Thanks   data1   ID         trt                                 aen1             aen2 1          paracetamol                   1 1          ibuporfen                         1                    2     data2   id         term                aen 1           headche          1 1          cramps              2   output needed;   id         trt                                        indication 1          paracetamol                       headche 1           ibuporfen                          headche,cramps                 ... View more

Dear,   what formay I have to use to convert a value into 'dd hh:mm'' format.    eg;   variable1                      variable2 06JUN15:09:19             06JUN15:10:54   output needed; duration(variable2-variable1) 0 01:35   Thanks       ... View more