![]() ![]() NOTE: The data set WORK.DIFFS has 0 observations and 3 variables. NOTE: There were 31 observations read from the data set WORK.OUTCAT. NOTE: There were 31 observations read from the data set WORK.OUTEACH. proc compare noprint base=outEach compare=outCat out=diffs outnoequal If zero rows with differences (per noequal) then the out= data sets have identical counts. The observation with a missing value of the TABLES variable A is not included in the table, and the frequency of missing values is displayed below the table. The first table shows PROC FREQ’s default behavior for handling missing values. ![]() Reality check with COMPARE, I don't trust eyeballs. Figure 3.11 displays the frequency tables produced by this example. Tables crossing / list missing out=outCat Title "1 table - 1 column of concatenated crossings" data haveV / view=haveV Ĭrossing = catx(' * ', of s:) * concatenation of all the s variables Tables s1*s2*s3*s4*s5 / list missing out=outEach Īnd, compare to what happens when a data step view uses a variable list to compute a surrogate value corresponding to the discrete combinations reported above. Now, reconsider the original request discretely (no-shortcut) crossing all the s* variables: title "1 table - 5 columns of crossings" So for above, the out= table will have a column "s5", but contain counts corresponding to combinations for each s1 through s5.Īt each dimensional level you can use a variable list, as in level1 * (sublev:) * leaf. NOTE: If you specify out=, the column names in the output data set will be the last variable in the level. There is no shortcut syntax for specifying a variable list that crosses dimension. Sample data generator: %macro have(top=5) Īs you probably noticed table s: created one freq per s* variable.įor example: title "One table per variable" In long, yes - if you create a surrogate variable that is an equivalent crossing. See the section ODS Table Names for more information. ODS enables you to convert any of the output from PROC FREQ into a SAS data set. ![]() There is no shortcut syntax for specifying a variable list that crosses dimension. PROC FREQ uses the Output Delivery System (ODS), a SAS subsystem that provides capabilities for displaying and controlling the output from SAS procedures. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |