Dear All,   Can some one help with edit check. I have dataset with three collumns ID, DATE, TIME.   I have to write a program to confirm that  assessment time between two measurements should be at least 2 minute apart.I have to output the discripancies where the assessments are performed within 2minutes.   Below is the sample data.   10031001 28SEP2015 08:36 10031001 28SEP2015 08:38 10031001 28SEP2015 08:39 10031001 28SEP2015 08:40 10031001 28SEP2015 08:42 10031001 28SEP2015 08:44 10031001 28SEP2015 08:46  10031002 28OCT2015 08:36 10031002 28OCT2015 08:39 10031002 28OCT2015 08:40 10031002 30OCT2015 08:40 10031002 30OCT2015 08:41 10031002 30OCT2015 08:43 10031002 30OCT2015 08:45   The output shoudl look like this   10031001 28SEP2015 08:38 10031001 28SEP2015 08:39 10031001 28SEP2015 08:40 10031002 28OCT2015 08:39 10031002 28OCT2015 08:40 10031002 30OCT2015 08:40 10031002 30OCT2015 08:41   Thanks in advance Rakesh ... View more

Dear All,   Can some one guide me with the below query.   Part 1/Cycle 1/Day 1/Pre-Dose: I have to output only: Cycle 1/Day 1 from adjacent string(Have to strip off values before the first slash and after the last).   Part 1/Cycle 1/Day 1/6 Hr: Cycle 1/Day 1 Part 1/Cycle 1/Day 15/Pre-Dose: Cycle 1/Day 15 Part 1/Cycle 1/Day 8: Cycle 1/Day 8 Part 1/Cycle 1/Day 21: Cycle 1/Day 21 Also, Can someone please guide in converting 10FEB2015 into SAS DATE. Thanks in advance. Rakesh ... View more

Dear All,   Can some one help me with output for identifying the duplicates. I am using the below code but i would like to output all the duplicates into output based on the three keys.I am thinking SQL should be good option but I am not sure of using sql.   PROC SORT DATA=MH OUT=MH1 DUPOUT=MH_DUP NODUPKEY; BY SUBJECT MHTERM MHST; RUN;   /* CAN SOMEONEHELP IN CORRECTING THE BELOW CODE proc sql; create table dup as  select * from mh having count(subject,mhterm,mhts) >1; quit;   Thanks Rakesh ... View more

Dear All,   I have to find the difference between the two times in character format. Can some one help me on these...   09:15 17:40----Have to find difference between these two.Ideally i would like to conver numeric sas format and then do the subtraction. 09:40 16:50----Have to find difference between these two   Thanks in advance. Rakesh ... View more

Dear All,   I have dataset with ID as key variable and 10 variables A1-A10. I would like create 'flag' which will have all the Variables which have missing value.Flag should have variable names which are missing(Character or numeric). Below is example of the output.   EX:   ID       A1 A2 A3    A4      A5     A6       A7  A8  A9  A10          FLAG 001      .   1    .    TRT   TER   TEST                  X              A1,A3,,A7,A8,A10   Can someone help with above query. Thanks in Advance. ... View more

Dear All,   I want to export two sas dataset into one excel with one tab for each dataset. Can some one help me on this. I am using the following code.   PROC EXPORT DATA= WORK.ae OUTFILE= "c\ae.csv" DBMS=CSV REPLACE; PUTNAMES=Yes; RUN;   PROC EXPORT DATA= WORK.cm DBMS=CSV REPLACE; PUTNAMES=Yes; RUN;   I would need the datasets in the same excel. Also I would like to have collumn label instead of collumn name and bolded to any colur.   Thanks in advance ... View more

Dear All,   Can some one help me with below issue.   I comparing the around 100 datasets in the two libraries by using the Proc compare. 98% of datasets have similar attributes and are identical. when i am running proc compare by having 100 datasets in the 'Do LOOP'. I am getting huge report as there 98% of datasets have been compared..."I would like to see in the output only thoose datasets which have unequal values."I have used the option OUTNOEQUAL but it is meant for outputting to Datasets....   Thanks   Rakesh ... View more