All good.  Thank you so much for your help. ... View more

Thank you.  This looks great - thank you. I compared the estimates to the estimates of the Proc GLM and they were the same. (In the code below, Should the testvalue=4 in the lsmestimate line?)     ... View more

I use a dot when I refer to a macro variable. ... View more

PP stands for Per-Protocol analysis population. 🙂 ... View more

Thanks Paige, I understand the hesitation.  The program is pretty convoluted with macros embedded inside.  I actually figured out how to get the macro for the populations to work - I added two ampersands i.e.  if &&pop.="Y";  to each place within the program. This seems to work well now.  I am not completely sure why or how this works - but will figure that out. Thanks for your input. ... View more

Thank you for your suggestion. By groups wouldn’t work because of the structure of the datasets. There are variables to identify which observations (ie subjects) belong to which populations. Ie ITT=Y/N, PP=Y/N. The code is basically %let pop= ITT data a; Set b; If &pop.=“Y”; Run; This repeats a few times in the program bringing in and merging different datasets where the condition &pop.=“Y” is used. There are also some macros within the code. With a summary table at the end. I Want to produce the same summary table For the different analysis populations. I hope this clarifies the issue a bit ... View more

Thank you for your response. I agree that comparing variables of like type is better. This was not really doable for this particular situation. ... View more

Thank you - this seems to work. ... View more

Thanks,  That doesn't quite work with my dataset.  For example: data aa; input name $ Base $ Compare $ ; cards; x 123,456 123456 y 987654 987,654 date 16MAY2024 16/05/2024 match yes yes ; run;   The first two observations are working with the all_digits format.  But the dates are different.  The dates are values in the base and compare variables.    (you are correct the format of the date is day month year). ... View more

Thanks. The all_digits function with the compress works. Now I have to figure out how to deal with comparing the different date formats: i.e."16MAY2024" and "16/05/2024" when both of these are text values. Any ideas? ... View more

They are character because I transpose the output of the proc compare.  There are all different types of data that I am comparing - dates, numbers, text etc.  That is why the variables Base and Compare have both numbers (including sometimes dates) as well as text. I actually did see that when I did an ODS excel output, all the numbers with commas were read into excel without the commas.  This means that I can theoretically now write an "if" condition in excel to take these out (since now they are the same). But I would much rather do this up front in SAS.  Any suggestions? ... View more