Creating Extensive shift tables, KANSAS CITY AREA SAS创建表广泛转移，堪萨斯市地区的SAS.pptVIP

Creating Extensive Shift Tables OR How I Learned to Type 1,388,571 wpm! Kelley Weston The goal: Create a format that would consist of all the possible combinations of several values. The usual way of accomplishing this: Typing all the combinations into a format. When there are only 4 or 5 possible values in 2 positions, this is no problem. The problem: We are starting with 7 values, in each of 4 positions. This results in 7 * 7 * 7 * 7 = 2401 combinations. The problems include: time ensuring that all possible combinations are accounted for, with no repetitions or omissions accuracy What I need to create: The solution:  Let SAS? create the combinations AND the meanings for them. The method: Create a data set with the individual values and meanings. This will only consist of a very few records. In our case, we had 7 values. Let SAS create all the combinations and put them into a data set. We will cross the dataset with itself 3 times to create the 4 positions. Remember the Cartesian product? Post-process the dataset to account for baseline and missing values. Create the datasets from which we will create the permanent formats. Write out the permanent formats. Step 1 step 2a step 2b step 2c step 3 step 4a step 4b step 5 Step 1 data work.temp; length x $1 y $7; x = T; y = Trace; output; x = 1; y = 1+; output; x = 2; y = 2+; output; x = O; y = Other; output; x = M; y = Missing; output; x = -; y = -; output; x = N; y = None; output; run; outline Step 2a proc sql; create table work.temp as select x, y from work.temp order by x; outline Step 2b create table work.temp2 as select (a.x !! b.x) as x, (a.y !! to !! b.y) as y from work.temp as a, work.temp as b; outline Step 2c create table work.temp3 as select (a.x !! b.x) as x