Mark is correct, you would want to use the Nodup here, as I re-read the the post.  I originally assumed (looking at the example data set) that the Number was the same for each individual Name; however, it sounds like that may not be the case.  Instead of eliminating duplicate Names with the Nodupkey, the Nodup will eliminate duplicate rows that have the same values in both the Name and Number field.  The same with select distinct *, instead of select distinct Name in the SQL procedure.  In case there are multiple Numbers for individual Names, otherwise my code will give you the first Number of each Name, and not all possible combinations of Names and Numbers.  Hope that makes sense! ... View more

Yes, Mike has explained it perfectly. Mostly, I think it's a matter of style preferences, the two pieces of code will be pretty much identical in terms of performance. Although it's not required in this instance, I strongly recommend you review the SAS documentation on how the following structure works: SET X;   BY VARY; IF FIRST.VARY ...; IF LAST.VARY ...; It is a very useful construct in solving a number of problems, and (I think) fairly unique to SAS. Best,   Tom ... View more

In cases where you have predictors in the model, specify the AGGREGATE= option to obtain these statistics.  See this usage note:    http://support.sas.com/kb/22/630.html ... View more

Also order of definition in the value section of proc format statements makes a difference in output. Please see an example below. /* a further example with multilabel formats */ /* the indents are just to show the desired levels */ /* I think that the order the statements occur in */ /* format may have an affect based on the options */ /* in Proc Tabulate. The spaces in the label are */ /* actually character 255 (Alt+255 on numeric pad) */ /* Motor and Water are in that order to show that */ /* the output order is sorted in the manner we want*/ /* not by the text of the responses */ /* (at least one case below ) */ proc format library=work; value accidentl (multilabel notsorted) 1-5 = 'Accidents' 1-3 = ' Transport accidents' 1 = '   Motor vehicle accidents' 2 = '   Water, air, and space' 3 = '   Other land transport accidents' 4-5 = ' Nontransport accidents' 5 = '   Fishing' ; value accidentr (multilabel notsorted) 1-5 = 'Accidents' 1-3 = ' Transport accidents' 4-5 = ' Nontransport accidents' 1 = '   Motor vehicle accidents' 2 = '   Water, air, and space' 3 = '   Other land transport accidents' 5 = '   Fishing' ; value mf 1 = "Male" 2 = "Female" ; run; /* populate a dataset to display */ /* This specifically does NOT generate any data for FISHING above*/ /* to display the behavior of the options below in those cases. */ data junk; do i=1 to 50; type = round(4*ranuni(1234)+.5); sex = round(2*ranuni(3455)+.5); output; end; run; /* Notice that before we get here the data is NOT sorted */ /* in any manner!!!! */ proc tabulate data=junk order=data; class type / mlf PRELOADFMT; class sex; table type=' ', all='Total'*n=' '*f=comma9. sex=' '*n=' '*f=comma8. /rts=35 printmiss misstext='0'; format type accidentl. sex mf.; title 'Option Order=Data Preloadfmt Printmiss Misstext=0 format accidentl'; run; proc tabulate data=junk order=data; class type / mlf PRELOADFMT; class sex; table type=' ', all='Total'*n=' '*f=comma9. sex=' '*n=' '*f=comma8. /rts=35 printmiss misstext='0'; format type accidentr. sex mf.; title 'Option Order=Data Preloadfmt Printmiss Misstext=0 format accidentr'; run; title; ... View more