data dat1; input x; cards; 1 3 4 6 7 8 ; run; data dat2; input y; cards; 1 4 3 6 7 5 ; run;   How to get the data include all combination of x and y?   that is: x y 1 1 1 4 1 3 1 6 1 7 1 5 3 1 3 4 3 3 3 6 3 7 3 5....   thanks. ... View more

I run below SAS code. How can I got the predicted value dataset?       data work.fitness;    input Age Weight Oxygen RunTime RestPulse RunPulse MaxPulse @@;    datalines; 44 89.47 44.609 11.37 62 178 182   40 75.07 45.313 10.07 62 185 185 44 85.84 54.297  8.65 45 156 168   42 68.15 59.571  8.17 40 166 172 38 89.02 49.874  9.22 55 178 180   47 77.45 44.811 11.63 58 176 176 40 75.98 45.681 11.95 70 176 180   43 81.19 49.091 10.85 64 162 170 44 81.42 39.442 13.08 63 174 176   38 81.87 60.055  8.63 48 170 186 44 73.03 50.541 10.13 45 168 168   45 87.66 37.388 14.03 56 186 192 45 66.45 44.754 11.12 51 176 176   47 79.15 47.273 10.60 47 162 164 54 83.12 51.855 10.33 50 166 170   49 81.42 49.156  8.95 44 180 185 51 69.63 40.836 10.95 57 168 172   51 77.91 46.672 10.00 48 162 168 48 91.63 46.774 10.25 48 162 164   49 73.37 50.388 10.08 67 168 168 57 73.37 39.407 12.63 58 174 176   54 79.38 46.080 11.17 62 156 165 52 76.32 45.441  9.63 48 164 166   50 70.87 54.625  8.92 48 146 155 51 67.25 45.118 11.08 48 172 172   54 91.63 39.203 12.88 44 168 172 51 73.71 45.790 10.47 59 186 188   57 59.08 50.545  9.93 49 148 155 49 76.32 48.673  9.40 56 186 188   48 61.24 47.920 11.50 52 170 176 52 82.78 47.467 10.50 53 170 172 ; run;   proc reg data=work.fitness;    model Oxygen = Runtime Age Weight / r cli clm; run;   ... View more

I am using Proc report to generate a report. the obs=644776. I have error messages:   ERROR: The SAS System stopped processing this step because of insufficient memory. NOTE: There were 644776 observations read from the data set WORK.TEMP. NOTE: PROCEDURE REPORT used (Total process time):       real time           2:27.35       user cpu time       2:09.94       system cpu time     17.51 seconds       memory              8707369.07k       OS Memory           10485596.00k       Timestamp           16/12/2020 03:05:28 PM       Step Count                        25  Switch Count  41       Page Faults                       2       Page Reclaims                     6874226       Page Swaps                        0       Voluntary Context Switches        1321       Involuntary Context Switches      577       Block Input Operations            40       Block Output Operations           63184   What can I do?   Th ods select all; ods results off; options missing="0"; ods excel file="/d/results1512.xlsx" options (embedded_titles = 'no' embedded_footnotes='no' title_footnote_nobreak='off'              sheet_interval="table" sheet_name="RTO"); title ""; proc report data=temp; columns foe GNF17 GF17;  define foe/ display "field of education" format=$grp. ; define GNF17/ "2017 Non" format=comma7.; define GF17/ "2017 yes" format=comma7.;   run; ... View more

I have   A:   Name score1 a1 80 a2 70 a3 60   B: name score2 a1 70 a3 60 a4 50   What I want to get is:   name score1 score2 a1 80 70 a2 70 . a3 60 60 a4 . 50   but if I use full join what I get is: name score1 score2 a1 80 70 a2 70 . a3 60 60 . . 50   how to solve this issue?     ... View more

A is:                  course1  course 2 course3 course4 school1:  3   2   4   1 school2: 2 1 0 3 school3: 4 6 3 2   B is  school1 course1  3 school1 course2 2 school1 course2 4 school1 course2 1 school2 course2 2 school2 course2 1 school2 course2 0 school2 course2 3 school3 course2 4 school3 course2 6 school3 course2 3 school3 course2 2 ... View more