Thanks for help.   I ran your code.   The Hex. format for 'SCREENING' in my data(compare)=53435245454E494E47 The Hex. format for 'SCREENING' in vendor data(base)=53435245454E494E47200A2020202020202020202020202020202020202020202020202020202020   What I have to before comparing the datasets. Please .Thanks ... View more

My code;  data one; length EPOCH1 $40; merge two (in=a) three; by id; if a; if dtn ge sdate and dtn le edate then EPOCH1='SCREENING'; if EPOCH1 ^= '' then EPOCH=strip(EPOCH1); run; ... View more

I ran the following;   if 'SCREENING' = 'SCREENING' then put 'TRUE'; else put 'FALSE';   The log shows all TRUE. So there are no leading spaces. If any other possibility please help. Thanks.  ... View more

Dear,   I tried to find answer for this question. I could not.    There are other IF statement for EPOCH. Why only EPOCH='SCREENING' is having the spaces and not matching. Does any body have any answer. I used compress and strip functions. It is still showing same results. Please help. Thanks. ... View more

Dear,   I ran Proc compare on my data sets. I am attaching the documnet that I am explaning.    For the EPOCH values, both in compare dataset and base dataset the values "SCREENING' are same. But the values are not matching and proc compare results  shows that compare values for EPOCH='SCREENING' are written on left side and bottom instead of right side.   My code;  data one; length EPOCH $40; merge two (in=a) three; by id; if a; if dtn ge sdate and dtn le edate then EPOCH='SCREENING'; run; ... View more

Great. Thank you ... View more

Once again Thank you very much. But that did not help me for my output. The following what i been trying.   I been trying to derive date1 from date and date3 variables   If date is complete then date1=date (observation1); if only year and month provided in date variable then compare date variable month to date2 variable month. If monthes are equal then date1=date2(observation3); else date1=first day of month(observation2).   if only year provided, then compare with date variable year to date2 variable year. If years are equal then date1=date2(observation5); else date1=first day of year(observation4). please help. Thank you.       date(Character)    date1                                    date2(numeric) 2015-06-03         2015-06-03                        2015-02-03 2015-06             2015-06-01                          2015-05-04 2015-05             2015-05-04                         2015-05-04 2015                 2015-01-01                           2014-04-04 2015                  2015-02-01                         2015-02-01 ... View more

Thanks for the help. If I have to convert 2016-06(CHARARCTER) to numeric form 2016-06 what is the informat I have to use.   date1=informat(DATE,?);    I have been looking in SAS material. I could not find it. How to convert. Thanks. ... View more

Thank you very much ... View more