You can try arrays to convert those many variables from character to numeric. Please check the sample code considering the variables with names var1 - var1000. data want;      set have;      array chars(*) $ var1-var1000;      array nums(*) num1-num1000;      do i = 1 to dim(chars);      nums(i)=input(chars(i),best.);      end;      drop var:; run; Thanks, Jagadish ... View more

Hi Nandini, Please find below the code which i worked on a sample data, this is as per your requirement. except the first record, remaining records will be flagged accordingly. i have compared the ae start and even the ae end of the next records with the ae start and ae end of the first records. Because if the ae end date of the next record is between the ae start and ae end of the first records, it means that the ae was overlapping with the first record. i believe this was not considered in your code above. Please try and let me know if this is what you were expecting data aes; informat ae_start date9. ae_stop date9.; input @1 subject $3. @5 ae_start date9. @15 ae_stop date9. @25 adverse_event $15.; format     ae_start  ae_stop date9.; datalines; 101 01JAN2004 02JAN2004 Headache 101 02JAN2004 03FEB2004 Back Pain 102 03NOV2003 10DEC2003 Rash 102 10NOV2003 10JAN2004 Abdominal Pain 102 04APR2004 04APR2004 Constipation ; run; proc sort data=aes;     by     subject  ae_start  ae_stop; run; data want;     set aes;     by     subject  ae_start  ae_stop;     retain old_aest old_aeend;     if first.subject then do;     old_aest=ae_start;     old_aeend= ae_stop;     end;     if not first.subject then do;     if     (old_aest<=ae_start <= old_aeend) or (old_aest<=ae_stop <= old_aeend) then flag='Yes';     else flag='No';     end;     format     old_aest old_aeend date9.; run; proc print; run; Thanks, Jagadish ... View more

the above macro is working, however since the index function is unable to find the text "deva" including the quotes in "devara" it is not displaying anything in the log. Please try the below code and check the log you will find not exists in the log. %macro one; %if %index("devara", "deva")  %then %put exists; %else %put not exists; %mend; %one; ... View more

Could you please let me know the difference between the ae#1 term and ae#2 term? This will help me to provide a helpful suggestion. ... View more

Please try libname test v6 'D:\District level data\DHS-India\NFHS 1992-93\All-India\HH   ! raw' ; just give the folder path, not the file path. Also only the folder path should be in quotes not the libname statement Thanks jagadish ... View more

Hi Nandini, Please refer to the link (sas programming in pharmaceutical industry.pdf) http://www.planta.cn/forum/files_planta/sas_programming_in_the_pharmaceutical_industry_119.pdf please refer page 106, topics Performing Many-to-Many Comparisons/Joins and Program 4.8 Performing a Many-to-Many Join with PROC SQL. This will provide you with the required information pertaining to your question. Thanks, Jagadish ... View more

Yes Jerry, thanks for your response. i want to achieve this by arrays. Because i tried with transpose and got the desired output, even without the use of var statement. proc transpose data=have out=trans; run; Thanks, jagadish ... View more

Please try data want;     set have;     if prxmatch('m/b.s\b|bachelor\b/oi',Biography)>0 and prxmatch('m/finance|economic|account|admin/oi',Biography)>0 then UnderGrad=1;     else if prxmatch('m/b.s\b|bachelor\b/oi',Biography)>0 and prxmatch('m/finance|economic|account|admin/oi',Biography)=0 then UnderGrad=2;     else UnderGrad=3;     if prxmatch('m/m.b.a\b|master\b/oi',Biography)>0 and prxmatch('m/finance|economic|account|admin/oi',Biography)>0 then Grad=1;     else if prxmatch('m/m.b.a\b|master\b/oi',Biography)>0 and prxmatch('m/finance|economic|account|admin/oi',Biography)=0 then Grad=2;     else Grad=3;         if prxmatch('m/cpa\b|accounting\b|accountant\b/oi',Biography)>0  then cpa=1;     else cpa=0; run; Thanks, jagadish ... View more