Help using Base SAS procedures

SAS

Accepted Solution Solved
Reply
New Contributor Ra6
New Contributor
Posts: 4
Accepted Solution

SAS

Hi,

 
I used a dataset including sampling and covariate.  That time I followed the steps perfectly. But, the problem is, I have to use a different dataset now but all the steps will be same but I am getting error everytime. I am attaching here what I did before for convenience and the new dataset too. Now I have to work on new dataset using CRD factorial with two covariates (slash volume and average snow depth).
I am using SAS version 9.4. 
 
The previous code is: 

libname rafia '\\homedir.mtu.edu\home\Desktop\CRD';

data rahman;

Input Water$ FertTreat$ Plot Plant InitialHt Height;

datalines;

Hi    Control     1     1     5     12.7

Hi    Control     2     1     6.5   16.6

Hi    Control     3     1     5.5   15.7

Hi    Control     4     1     5.5   16.9

Hi    Control     5     1     5.1   14.2

Hi    Liquid      6     1     6.2   23.2

Hi    Liquid      7     1     3.4   20.9

Hi    Liquid      8     1     7.1   25

Hi    Liquid      9     1     8.3   24.6

Hi    Liquid      10    1     5.6   25.7

Hi    Pellet      11    1     3.7   20.1

Hi    Pellet      12    1     1.4   19.9

Hi    Pellet      13    1     3.6   20.8

Hi    Pellet      14    1     6.4   20.6

Hi    Pellet      15    1     5.6   23

Hi    SlowRele    16    1     6.9   21.7

Hi    SlowRele    17    1     5.8   19.8

Hi    SlowRele    18    1     4.8   18.4

Hi    SlowRele    19    1     10.1  19.3

Hi    SlowRele    20    1     3.9   21.9

Lo    Control     21    1     4.5   14.8

Lo    Control     22    1     6.8   16.5

Lo    Control     23    1     4.9   12.7

Lo    Control     24    1     3.6   13.4

Lo    Control     25    1     4.1   10.6

Lo    Liquid      26    1     7.4   27.7

Lo    Liquid      27    1     10    28.1

Lo    Liquid      27    1     9.8   27

Lo    Liquid      28    1     7.4   23.9

Lo    Liquid      30    1     7.1   29.1

Lo    Pellet      31    1     5.9   21.5

Lo    Pellet      32    1     9.6   20.5

Lo    Pellet      33    1     2.6   19.5

Lo    Pellet      34    1     5.3   18.9

Lo    Pellet      35    1     4.8   20

Lo    SlowRele    36    1     5.1   19.2

Lo    SlowRele    37    1     4.6   18.3

Lo    SlowRele    38    1     1.1   20.3

Lo    SlowRele    39    1     6.3   21.2

Lo    SlowRele    40    1     5.4   20.1

Hi    Control     1     2     5     13.1

Hi    Control     2     2     7     17.2

Hi    Control     3     2     5.6   16.6

Hi    Control     4     2     5.9   17.4

Hi    Control     5     2     5.2   14.4

Hi    Liquid      6     2     6.6   24.7

Hi    Liquid      7     2     3.5   22.7

Hi    Liquid      8     2     7.5   25.5

Hi    Liquid      9     2     8.6   26.3

Hi    Liquid      10    2     5.6   27

Hi    Pellet      11    2     3.9   22

Hi    Pellet      12    2     1.8   21.5

Hi    Pellet      13    2     4     22.1

Hi    Pellet      14    2     6.8   22.1

Hi    Pellet      15    2     6     24.9

Hi    SlowRele    16    2     7.2   22.4

Hi    SlowRele    17    2     5.8   21.6

Hi    SlowRele    18    2     5.2   18.7

Hi    SlowRele    19    2     10.4  19.8

Hi    SlowRele    20    2     4.3   22

Lo    Control     21    2     5     15.2

Lo    Control     22    2     6.8   17.1

Lo    Control     23    2     5.1   13.2

Lo    Control     24    2     4.1   14.6

Lo    Control     25    2     4.2   12

Lo    Liquid      26    2     7.8   29.6

Lo    Liquid      27    2     10.2  28.6

Lo    Liquid      27    2     9.9   28.2

Lo    Liquid      28    2     7.5   24.8

Lo    Liquid      30    2     7.3   30.2

Lo    Pellet      31    2     6.2   22.5

Lo    Pellet      32    2     9.8   21.2

Lo    Pellet      33    2     2.7   20.6

Lo    Pellet      34    2     5.6   19.9

Lo    Pellet      35    2     5     20.5

Lo    SlowRele    36    2     5.4   20.8

Lo    SlowRele    37    2     4.6   18.6

Lo    SlowRele    38    2     1.1   21.9

Lo    SlowRele    39    2     6.5   22.5

Lo    SlowRele    40    2     5.9   20.2

;

proc print;

run;

 

%INCLUDE '\\homedir.mtu.edu\home\Desktop\CRD';

%MMAOV (rahman,height, CLASS= plot FertTreat water, FIXED = FertTreat|water initialHt,RANDOM=plot(FertTreat*water) );


Accepted Solutions
Solution
2 weeks ago
Super User
Posts: 13,583

Re: SAS

And what  is the error you are getting?

 

You also might try

options mprint symbolgen;

%MMAOV (rahman,height, CLASS= plot FertTreat water, FIXED = FertTreat|water initialHt,RANDOM=plot(FertTreat*water) );

options nomprint nosymbolgen;

to get an idea of the code actually created by your macro and the error message(s) should be closer to the code portion causing the issue.

 

View solution in original post


All Replies
Solution
2 weeks ago
Super User
Posts: 13,583

Re: SAS

And what  is the error you are getting?

 

You also might try

options mprint symbolgen;

%MMAOV (rahman,height, CLASS= plot FertTreat water, FIXED = FertTreat|water initialHt,RANDOM=plot(FertTreat*water) );

options nomprint nosymbolgen;

to get an idea of the code actually created by your macro and the error message(s) should be closer to the code portion causing the issue.

 

New Contributor Ra6
New Contributor
Posts: 4

Re: SAS

[ Edited ]

Hi,

 

Thank you for the reply. Actually, I am facing problem with the data of new excel file that I have already attached with the previous message. I tried several time to run the file in SAS, as one variable has 3 sub division that's why I could not put the table in SAS. I am again attaching here the excel file. This one is the new dataset, I will have to work on it.

Super User
Posts: 23,771

Re: SAS

You never specify the file to be read. You have an INPUT statement but no INFILE statements. 

New Contributor Ra6
New Contributor
Posts: 4

Re: SAS

Here is the code according to the attached excel file that I tried to run but I am getting error every time. How can I solve the problem?

 

libname rafia 'C:\Users\rafiar\Documents\My SAS Files';

data rahman;
Input Plot $ Sample $ Zero_to_Five_cm $ Five_to_Ten_cm $ Ten_to_Twenty_cm $ Slash_Volume $ Average_Snow_Depth;

datalines;

1 1 1.323 1.896 1.410 0 12
1 2 1.019 1.518 1.260 0.0127 12
1 3 1.057 1.103 1.583 0.002 12
1 4 1.218 1.631 1.236 0.00712 12
1 5 0.990 1.294 0.982 0 12
1 6 1.081 1.348 1.098 0.0096 12
1 7 1.166 1.273 1.470 0.0081 12
1 8 1.017 1.150 1.251 0.0026 12
1 9 1.293 1.558 1.127 0.004 12
1 10 1.087 1.433 1.159 0 12
1 11 1.027 1.394 1.376 0.01 12
1 12 1.120 1.570 1.501 0 12
2 1 1.050 1.134 1.022 0 12
2 2 1.322 1.553 1.555 0 12
2 3 1.147 1.350 1.424 0 12
2 4 0.851 1.411 1.272 0 12
2 5 0.868 1.262 1.040 0 12
2 6 0.881 1.245 1.156 0 12
2 7 1.069 1.047 1.047 0 12
2 8 0.987 1.703 1.481 0 12
2 9 1.154 1.346 1.181 0 12
2 10 1.076 1.255 1.184 0 12
2 11 1.062 1.286 1.165 0.0078 12
2 12 1.194 1.320 1.627 0 12
3 1 0.966 1.062 0.938 0 15
3 2 1.001 1.085 0.940 0.027 15
3 3 1.217 1.136 1.133 0 15
3 4 0.800 1.193 1.259 0.0088 15
3 5 1.203 1.460 1.280 0.0096 15
3 6 1.162 1.485 1.276 0.0364 15
3 7 1.104 1.457 1.204 0.0042 15
3 8 1.297 1.301 1.578 0.0024 15
3 9 1.332 1.337 1.375 0.0488 15
3 10 0.560 1.434 1.069 0 15
3 11 1.017 1.154 1.258 0.0024 15
3 12 0.925 0.922 1.094 0 15
4 1 1.200 1.399 1.089 0 3
4 2 1.228 1.692 1.227 0 3
4 3 1.058 1.410 1.166 0 3
4 4 1.235 1.006 0.979 0 3
4 5 1.589 1.485 1.283 0 3
4 6 0.948 1.292 1.291 0 3
4 7 1.067 0.947 1.190 0 3
4 8 1.019 1.157 1.236 0 3
4 9 1.344 1.340 1.522 0 3
4 10 0.900 1.580 1.289 0 3
4 11 1.463 1.589 1.560 0 3
4 12 0.073 1.210 1.182 0 3
5 1 1.117 1.317 0.986 0.153 1
5 2 1.006 1.338 1.050 0 1
5 3 0.958 1.008 1.029 0.044 1
5 4 0.893 0.992 0.939 0.0096 1
5 5 0.978 0.899 0.861 0.0056 1
5 6 0.936 1.101 1.240 0.012 1
5 7 0.879 0.818 0.926 0.014 1
5 8 1.103 1.301 1.141 0.038 1
5 9 0.582 1.013 1.046 0.0052 1
5 10 1.167 1.301 0.965 0.0132 1
5 11 0.895 0.874 1.015 0.0028 1
5 12 1.196 1.202 1.076 0.0135 1
6 1 0.982 1.452 2.161 0 8
6 2 1.149 1.349 1.430 0 8
6 3 1.193 2.184 1.569 0 8
6 4 1.296 2.065 1.373 0 8
6 5 0.921 1.178 1.373 0 8
6 6 1.589 1.795 1.750 0 8
6 7 0.862 1.169 1.518 0 8
6 8 1.315 1.559 1.494 0 8
6 9 1.176 1.206 1.537 0 8
6 10 1.444 1.737 1.658 0 8
6 11 1.462 2.359 0.898 0 8
6 12 1.396 1.585 1.680 0 8
7 1 1.174 1.005 1.251 0 3
7 2 1.107 1.621 1.517 0 3
7 3 1.028 1.160 1.028 0 3
7 4 1.293 1.310 1.115 0 3
7 5 0.944 1.181 0.896 0 3
7 6 1.329 1.790 1.067 0 3
7 7 0.932 1.283 0.912 0 3
7 8 1.052 0.932 1.258 0 3
7 9 0.682 0.850 1.277 0 3
7 10 1.054 1.095 1.052 0 3
7 11 1.100 1.102 1.193 0 3
7 12 1.074 1.114 1.173 0 3
8 1 0.984 1.129 1.089 0 3
8 2 1.113 1.136 1.036 0 3
8 3 0.866 1.484 1.113 0 3
8 4 1.027 1.385 1.347 0 3
8 5 0.743 1.005 1.355 0 3
8 6 1.144 1.397 1.317 0 3
8 7 0.831 1.350 1.198 0 3
8 8 0.889 1.184 0.936 0 3
8 9 0.954 1.566 1.161 0 3
8 10 0.789 1.254 1.045 0 3
8 11 1.199 1.396 1.072 0 3
8 12 0.895 1.398 1.317 0 3
9 1 1.472 1.683 1.520 0.0328 8
9 2 1.052 1.406 1.311 0.0288 8
9 3 1.341 1.404 1.382 0.0286 8
9 4 1.114 0.116 1.350 0.0066 8
9 5 1.211 1.294 1.280 0.0116 8
9 6 1.126 1.052 1.488 0 8
9 7 1.204 1.262 0.873 0.021 8
9 8 1.218 1.223 1.155 0.0216 8
9 9 1.265 1.346 1.248 0.0022 8
9 10 1.218 1.105 1.180 0 8
9 11 1.080 1.361 1.532 0.0036 8
9 12 1.000 1.111 1.233 0 8
10 1 1.054 1.554 1.666 0 9
10 2 1.721 1.351 1.623 0.009 9
10 3 1.364 1.624 1.746 0.0042 9
10 4 0.955 1.153 1.348 0 9
10 5 1.150 1.817 1.467 0.01 9
10 6 1.820 1.666 1.545 0.0024 9
10 7 1.021 1.558 1.673 0.0108 9
10 8 0.650 1.131 1.304 0.0145 9
10 9 1.580 1.400 1.544 0 9
10 10 1.047 1.988 1.481 0 9
10 11 1.270 1.784 1.693 0.0042 9
10 12 0.808 1.088 1.895 0.0112 9
11 1 0.851 1.295 1.905 0.0102 15
11 2 1.535 1.269 1.279 0.012 15
11 3 1.346 1.680 1.697 0.018 15
11 4 1.084 1.546 1.907 0.0175 15
11 5 0.869 1.229 1.387 0.0351 15
11 6 1.865 0.964 1.309 0.0144 15
11 7 1.312 1.257 1.463 0.0028 15
11 8 1.091 1.169 1.191 0.0037 15
11 9 1.403 1.394 1.635 0.0032 15
11 10 0.735 1.031 1.283 0 15
11 11 0.953 1.005 1.669 0 15
11 12 0.704 0.963 1.277 0.0052 15
12 1 0.896 1.427 1.678 0.0342 16
12 2 0.969 1.900 1.806 0.0096 16
12 3 0.607 1.090 1.397 0.0026 16
12 4 1.804 1.645 1.609 0.0253 16
12 5 0.683 1.315 1.525 0.048 16
12 6 1.154 2.762 1.619 0 16
12 7 0.778 1.495 1.830 0.008 16
12 8 0.790 1.153 1.747 0.076 16
12 9 1.393 1.995 2.008 0 16
12 10 0.787 0.804 0.417 0.0084 16
12 11 0.865 0.831 1.023 0.0132 16
12 12 0.887 2.708 1.178 0.0261 16
13 1 1.087 1.462 1.034 0.0115 19
13 2 0.954 1.275 1.036 0.0096 19
13 3 1.002 1.430 1.234 0.016 19
13 4 1.491 1.175 1.295 0.0075 19
13 5 1.131 1.299 1.074 0.0357 19
13 6 0.991 0.969 1.022 0.0062 19
13 7 1.004 1.205 1.109 0.0301 19
13 8 1.201 1.058 1.029 0.014 19
13 9 1.073 0.981 1.038 0.0132 19
13 10 1.086 1.304 1.236 0.076 19
13 11 0.995 1.084 1.386 0.0144 19
13 12 0.715 0.791 1.081 0.0115 19
14 1 1.353 1.694 1.419 0 14
14 2 0.912 1.241 1.180 0 14
14 3 0.945 1.381 1.418 0.005 14
14 4 0.771 1.340 1.270 0.001 14
14 5 0.842 1.120 1.341 0.01 14
14 6 0.864 0.952 0.991 0 14
14 7 1.132 1.981 1.099 0 14
14 8 1.027 1.376 1.100 0.046 14
14 9 0.992 1.529 0.869 0 14
14 10 1.030 1.430 2.150 0.0014 14
14 11 0.983 1.607 0.834 0.016 14
14 12 1.093 3.007 0.531 0.004 14
15 1 0.779 1.457 1.329 0 12.5
15 2 1.500 1.058 2.075 0 12.5
15 3 1.006 1.282 1.668 0 12.5
15 4 0.542 0.758 1.461 0 12.5
15 5 1.296 0.786 1.216 0 12.5
15 6 0.916 1.125 1.097 0 12.5
15 7 0.857 1.105 1.333 0 12.5
15 8 0.923 1.014 1.035 0 12.5
15 9 1.003 0.942 1.021 0 12.5
15 10 0.905 1.064 1.047 0 12.5
15 11 0.904 0.988 1.291 0 12.5
15 12 1.167 1.315 1.385 0 12.5
16 1 1.125 3.074 0.557 0.0052 8.5
16 2 0.923 1.035 1.114 0.06 8.5
16 3 0.865 1.262 1.315 0.0308 8.5
16 4 1.540 1.049 0.803 0 8.5
16 5 1.037 2.497 1.948 0.03 8.5
16 6 1.332 2.287 1.951 0 8.5
16 7 1.320 1.506 1.721 0.003 8.5
16 8 1.143 1.401 1.314 0.018 8.5
16 9 1.336 1.464 1.541 0.0161 8.5
16 10 1.141 1.319 1.083 0 8.5
16 11 0.904 1.279 1.077 0.04275 8.5
16 12 0.906 1.175 1.167 0.0108 8.5
17 1 0.827 0.950 1.440 0.0759 15
17 2 1.054 1.078 1.171 0.0672 15
17 3 0.883 1.070 0.961 0.0867 15
17 4 0.863 1.110 1.209 0.035 15
17 5 1.012 0.893 1.043 0.051 15
17 6 0.829 1.047 1.704 0.1288 15
17 7 0.842 2.687 1.570 0.0126 15
17 8 1.116 1.246 1.121 0.0064 15
17 9 1.069 1.115 1.296 0.0513 15
17 10 0.968 1.009 1.455 0.066 15
17 11 1.222 1.400 1.364 0.043 15
17 12 1.069 1.547 1.530 0.0342 15
18 1 0.805 1.502 1.701 0.016 15
18 2 1.075 1.643 1.568 0.018 15
18 3 0.959 1.325 1.275 0.0171 15
18 4 1.110 1.475 1.502 0.008 15
18 5 0.721 1.027 1.662 0.015 15
18 6 0.979 1.998 1.390 0.017 15
18 7 1.276 1.736 1.416 0.0123 15
18 8 1.166 1.376 1.462 0.0012 15
18 9 1.163 1.546 1.718 0.008 15
18 10 1.391 1.756 1.820 0.0028 15
18 11 1.372 1.252 1.932 0 15
18 12 1.128 1.684 1.891 0 15
Rand 1 1.093 1.088 1.211 0 0
Rand 2 0.887 0.974 1.092 0 0
Rand 3 1.071 1.220 1.579 0 0
Rand 4 0.828 1.237 1.349 0 0
Rand 5 1.083 1.461 1.498 0 0
Rand 6 0.714 0.885 1.260 0 0
Rand 7 0.795 1.304 1.201 0 0
Rand 8 0.445 1.604 1.328 0 0
Rand 9 0.807 0.721 1.128 0 0
Rand 10 1.141 1.196 1.152 0 0
Rand 11 0.797 1.106 1.102 0 0
Rand 12 1.130 1.480 1.158 0 0
Rand 13 1.162 1.711 1.168 0 0
Rand 14 0.652 0.929 1.228 0 0
Rand 15 0.923 1.162 1.399 0 0
Rand 16 0.796 1.292 1.080 0 0
Rand 17 0.847 1.080 0.745 0 0
Rand 18 1.025 1.112 2.670 0 0
Rand 19 1.060 1.425 1.219 0 0
Rand 20 0.753 0.860 1.571 0 0
Rand 21 1.290 1.146 1.146 0 0
Rand 22 0.932 1.638 1.695 0 0
Rand 23 0.956 0.975 0.867 0 0
Rand 24 0.828 1.377 1.131 0 0
Rand 25 1.003 1.753 1.527 0 0
Rand 26 0.819 1.057 1.374 0 0
Rand 27 0.949 1.220 0.891 0 0
Rand 28 0.708 1.770 1.330 0 0
Rand 29 0.877 1.109 1.402 0 0
Rand 30 1.006 1.946 1.522 0 0
Rand 31 0.827 2.489 1.396 0 0

;

proc print;
run;
%INCLUDE ''\\homedir.mtu.edu\home\My SAS Files'';
%MMAOV (rahman, Slash_Volume Average_Snow_Depth, CLASS= plot Zero_to_Five_cm Five_to_Ten_cm Ten_to_Twenty_cm,
FIXED= Zero_to_Five_cm Five_to_Ten_cm Ten_to_Twenty_cm slash_volume average_snow_depth, RANDOM= plot sample Zero_to_Five_cm Five_to_Ten_cm Ten_to_Twenty_cm
;

 

Super User
Posts: 23,771

Re: SAS

 

What step gives you the error? 

What are you expecting the %INCLUDE to do? If the error is in that step we can't help you with this because we can't see that code?

Try including /SOURCE after the %INCLUDE to make sure all the information is printed to the log. 

 

Try adding some comments to your code to indicate what you think each step does. This helps us try and understand your logic and helps you when coding. 


@Ra6 wrote:

Here is the code according to the attached excel file that I tried to run but I am getting error every time. How can I solve the problem?

 

libname rafia 'C:\Users\rafiar\Documents\My SAS Files';

data rahman;
Input Plot $ Sample $ Zero_to_Five_cm $ Five_to_Ten_cm $ Ten_to_Twenty_cm $ Slash_Volume $ Average_Snow_Depth;

datalines;

1 1 1.323 1.896 1.410 0 12
1 2 1.019 1.518 1.260 0.0127 12
1 3 1.057 1.103 1.583 0.002 12
1 4 1.218 1.631 1.236 0.00712 12
1 5 0.990 1.294 0.982 0 12
1 6 1.081 1.348 1.098 0.0096 12
1 7 1.166 1.273 1.470 0.0081 12
1 8 1.017 1.150 1.251 0.0026 12
1 9 1.293 1.558 1.127 0.004 12
1 10 1.087 1.433 1.159 0 12
1 11 1.027 1.394 1.376 0.01 12
1 12 1.120 1.570 1.501 0 12
2 1 1.050 1.134 1.022 0 12
2 2 1.322 1.553 1.555 0 12
2 3 1.147 1.350 1.424 0 12
2 4 0.851 1.411 1.272 0 12
2 5 0.868 1.262 1.040 0 12
2 6 0.881 1.245 1.156 0 12
2 7 1.069 1.047 1.047 0 12
2 8 0.987 1.703 1.481 0 12
2 9 1.154 1.346 1.181 0 12
2 10 1.076 1.255 1.184 0 12
2 11 1.062 1.286 1.165 0.0078 12
2 12 1.194 1.320 1.627 0 12
3 1 0.966 1.062 0.938 0 15
3 2 1.001 1.085 0.940 0.027 15
3 3 1.217 1.136 1.133 0 15
3 4 0.800 1.193 1.259 0.0088 15
3 5 1.203 1.460 1.280 0.0096 15
3 6 1.162 1.485 1.276 0.0364 15
3 7 1.104 1.457 1.204 0.0042 15
3 8 1.297 1.301 1.578 0.0024 15
3 9 1.332 1.337 1.375 0.0488 15
3 10 0.560 1.434 1.069 0 15
3 11 1.017 1.154 1.258 0.0024 15
3 12 0.925 0.922 1.094 0 15
4 1 1.200 1.399 1.089 0 3
4 2 1.228 1.692 1.227 0 3
4 3 1.058 1.410 1.166 0 3
4 4 1.235 1.006 0.979 0 3
4 5 1.589 1.485 1.283 0 3
4 6 0.948 1.292 1.291 0 3
4 7 1.067 0.947 1.190 0 3
4 8 1.019 1.157 1.236 0 3
4 9 1.344 1.340 1.522 0 3
4 10 0.900 1.580 1.289 0 3
4 11 1.463 1.589 1.560 0 3
4 12 0.073 1.210 1.182 0 3
5 1 1.117 1.317 0.986 0.153 1
5 2 1.006 1.338 1.050 0 1
5 3 0.958 1.008 1.029 0.044 1
5 4 0.893 0.992 0.939 0.0096 1
5 5 0.978 0.899 0.861 0.0056 1
5 6 0.936 1.101 1.240 0.012 1
5 7 0.879 0.818 0.926 0.014 1
5 8 1.103 1.301 1.141 0.038 1
5 9 0.582 1.013 1.046 0.0052 1
5 10 1.167 1.301 0.965 0.0132 1
5 11 0.895 0.874 1.015 0.0028 1
5 12 1.196 1.202 1.076 0.0135 1
6 1 0.982 1.452 2.161 0 8
6 2 1.149 1.349 1.430 0 8
6 3 1.193 2.184 1.569 0 8
6 4 1.296 2.065 1.373 0 8
6 5 0.921 1.178 1.373 0 8
6 6 1.589 1.795 1.750 0 8
6 7 0.862 1.169 1.518 0 8
6 8 1.315 1.559 1.494 0 8
6 9 1.176 1.206 1.537 0 8
6 10 1.444 1.737 1.658 0 8
6 11 1.462 2.359 0.898 0 8
6 12 1.396 1.585 1.680 0 8
7 1 1.174 1.005 1.251 0 3
7 2 1.107 1.621 1.517 0 3
7 3 1.028 1.160 1.028 0 3
7 4 1.293 1.310 1.115 0 3
7 5 0.944 1.181 0.896 0 3
7 6 1.329 1.790 1.067 0 3
7 7 0.932 1.283 0.912 0 3
7 8 1.052 0.932 1.258 0 3
7 9 0.682 0.850 1.277 0 3
7 10 1.054 1.095 1.052 0 3
7 11 1.100 1.102 1.193 0 3
7 12 1.074 1.114 1.173 0 3
8 1 0.984 1.129 1.089 0 3
8 2 1.113 1.136 1.036 0 3
8 3 0.866 1.484 1.113 0 3
8 4 1.027 1.385 1.347 0 3
8 5 0.743 1.005 1.355 0 3
8 6 1.144 1.397 1.317 0 3
8 7 0.831 1.350 1.198 0 3
8 8 0.889 1.184 0.936 0 3
8 9 0.954 1.566 1.161 0 3
8 10 0.789 1.254 1.045 0 3
8 11 1.199 1.396 1.072 0 3
8 12 0.895 1.398 1.317 0 3
9 1 1.472 1.683 1.520 0.0328 8
9 2 1.052 1.406 1.311 0.0288 8
9 3 1.341 1.404 1.382 0.0286 8
9 4 1.114 0.116 1.350 0.0066 8
9 5 1.211 1.294 1.280 0.0116 8
9 6 1.126 1.052 1.488 0 8
9 7 1.204 1.262 0.873 0.021 8
9 8 1.218 1.223 1.155 0.0216 8
9 9 1.265 1.346 1.248 0.0022 8
9 10 1.218 1.105 1.180 0 8
9 11 1.080 1.361 1.532 0.0036 8
9 12 1.000 1.111 1.233 0 8
10 1 1.054 1.554 1.666 0 9
10 2 1.721 1.351 1.623 0.009 9
10 3 1.364 1.624 1.746 0.0042 9
10 4 0.955 1.153 1.348 0 9
10 5 1.150 1.817 1.467 0.01 9
10 6 1.820 1.666 1.545 0.0024 9
10 7 1.021 1.558 1.673 0.0108 9
10 8 0.650 1.131 1.304 0.0145 9
10 9 1.580 1.400 1.544 0 9
10 10 1.047 1.988 1.481 0 9
10 11 1.270 1.784 1.693 0.0042 9
10 12 0.808 1.088 1.895 0.0112 9
11 1 0.851 1.295 1.905 0.0102 15
11 2 1.535 1.269 1.279 0.012 15
11 3 1.346 1.680 1.697 0.018 15
11 4 1.084 1.546 1.907 0.0175 15
11 5 0.869 1.229 1.387 0.0351 15
11 6 1.865 0.964 1.309 0.0144 15
11 7 1.312 1.257 1.463 0.0028 15
11 8 1.091 1.169 1.191 0.0037 15
11 9 1.403 1.394 1.635 0.0032 15
11 10 0.735 1.031 1.283 0 15
11 11 0.953 1.005 1.669 0 15
11 12 0.704 0.963 1.277 0.0052 15
12 1 0.896 1.427 1.678 0.0342 16
12 2 0.969 1.900 1.806 0.0096 16
12 3 0.607 1.090 1.397 0.0026 16
12 4 1.804 1.645 1.609 0.0253 16
12 5 0.683 1.315 1.525 0.048 16
12 6 1.154 2.762 1.619 0 16
12 7 0.778 1.495 1.830 0.008 16
12 8 0.790 1.153 1.747 0.076 16
12 9 1.393 1.995 2.008 0 16
12 10 0.787 0.804 0.417 0.0084 16
12 11 0.865 0.831 1.023 0.0132 16
12 12 0.887 2.708 1.178 0.0261 16
13 1 1.087 1.462 1.034 0.0115 19
13 2 0.954 1.275 1.036 0.0096 19
13 3 1.002 1.430 1.234 0.016 19
13 4 1.491 1.175 1.295 0.0075 19
13 5 1.131 1.299 1.074 0.0357 19
13 6 0.991 0.969 1.022 0.0062 19
13 7 1.004 1.205 1.109 0.0301 19
13 8 1.201 1.058 1.029 0.014 19
13 9 1.073 0.981 1.038 0.0132 19
13 10 1.086 1.304 1.236 0.076 19
13 11 0.995 1.084 1.386 0.0144 19
13 12 0.715 0.791 1.081 0.0115 19
14 1 1.353 1.694 1.419 0 14
14 2 0.912 1.241 1.180 0 14
14 3 0.945 1.381 1.418 0.005 14
14 4 0.771 1.340 1.270 0.001 14
14 5 0.842 1.120 1.341 0.01 14
14 6 0.864 0.952 0.991 0 14
14 7 1.132 1.981 1.099 0 14
14 8 1.027 1.376 1.100 0.046 14
14 9 0.992 1.529 0.869 0 14
14 10 1.030 1.430 2.150 0.0014 14
14 11 0.983 1.607 0.834 0.016 14
14 12 1.093 3.007 0.531 0.004 14
15 1 0.779 1.457 1.329 0 12.5
15 2 1.500 1.058 2.075 0 12.5
15 3 1.006 1.282 1.668 0 12.5
15 4 0.542 0.758 1.461 0 12.5
15 5 1.296 0.786 1.216 0 12.5
15 6 0.916 1.125 1.097 0 12.5
15 7 0.857 1.105 1.333 0 12.5
15 8 0.923 1.014 1.035 0 12.5
15 9 1.003 0.942 1.021 0 12.5
15 10 0.905 1.064 1.047 0 12.5
15 11 0.904 0.988 1.291 0 12.5
15 12 1.167 1.315 1.385 0 12.5
16 1 1.125 3.074 0.557 0.0052 8.5
16 2 0.923 1.035 1.114 0.06 8.5
16 3 0.865 1.262 1.315 0.0308 8.5
16 4 1.540 1.049 0.803 0 8.5
16 5 1.037 2.497 1.948 0.03 8.5
16 6 1.332 2.287 1.951 0 8.5
16 7 1.320 1.506 1.721 0.003 8.5
16 8 1.143 1.401 1.314 0.018 8.5
16 9 1.336 1.464 1.541 0.0161 8.5
16 10 1.141 1.319 1.083 0 8.5
16 11 0.904 1.279 1.077 0.04275 8.5
16 12 0.906 1.175 1.167 0.0108 8.5
17 1 0.827 0.950 1.440 0.0759 15
17 2 1.054 1.078 1.171 0.0672 15
17 3 0.883 1.070 0.961 0.0867 15
17 4 0.863 1.110 1.209 0.035 15
17 5 1.012 0.893 1.043 0.051 15
17 6 0.829 1.047 1.704 0.1288 15
17 7 0.842 2.687 1.570 0.0126 15
17 8 1.116 1.246 1.121 0.0064 15
17 9 1.069 1.115 1.296 0.0513 15
17 10 0.968 1.009 1.455 0.066 15
17 11 1.222 1.400 1.364 0.043 15
17 12 1.069 1.547 1.530 0.0342 15
18 1 0.805 1.502 1.701 0.016 15
18 2 1.075 1.643 1.568 0.018 15
18 3 0.959 1.325 1.275 0.0171 15
18 4 1.110 1.475 1.502 0.008 15
18 5 0.721 1.027 1.662 0.015 15
18 6 0.979 1.998 1.390 0.017 15
18 7 1.276 1.736 1.416 0.0123 15
18 8 1.166 1.376 1.462 0.0012 15
18 9 1.163 1.546 1.718 0.008 15
18 10 1.391 1.756 1.820 0.0028 15
18 11 1.372 1.252 1.932 0 15
18 12 1.128 1.684 1.891 0 15
Rand 1 1.093 1.088 1.211 0 0
Rand 2 0.887 0.974 1.092 0 0
Rand 3 1.071 1.220 1.579 0 0
Rand 4 0.828 1.237 1.349 0 0
Rand 5 1.083 1.461 1.498 0 0
Rand 6 0.714 0.885 1.260 0 0
Rand 7 0.795 1.304 1.201 0 0
Rand 8 0.445 1.604 1.328 0 0
Rand 9 0.807 0.721 1.128 0 0
Rand 10 1.141 1.196 1.152 0 0
Rand 11 0.797 1.106 1.102 0 0
Rand 12 1.130 1.480 1.158 0 0
Rand 13 1.162 1.711 1.168 0 0
Rand 14 0.652 0.929 1.228 0 0
Rand 15 0.923 1.162 1.399 0 0
Rand 16 0.796 1.292 1.080 0 0
Rand 17 0.847 1.080 0.745 0 0
Rand 18 1.025 1.112 2.670 0 0
Rand 19 1.060 1.425 1.219 0 0
Rand 20 0.753 0.860 1.571 0 0
Rand 21 1.290 1.146 1.146 0 0
Rand 22 0.932 1.638 1.695 0 0
Rand 23 0.956 0.975 0.867 0 0
Rand 24 0.828 1.377 1.131 0 0
Rand 25 1.003 1.753 1.527 0 0
Rand 26 0.819 1.057 1.374 0 0
Rand 27 0.949 1.220 0.891 0 0
Rand 28 0.708 1.770 1.330 0 0
Rand 29 0.877 1.109 1.402 0 0
Rand 30 1.006 1.946 1.522 0 0
Rand 31 0.827 2.489 1.396 0 0

;

proc print;
run;
%INCLUDE ''\\homedir.mtu.edu\home\My SAS Files'';
%MMAOV (rahman, Slash_Volume Average_Snow_Depth, CLASS= plot Zero_to_Five_cm Five_to_Ten_cm Ten_to_Twenty_cm,
FIXED= Zero_to_Five_cm Five_to_Ten_cm Ten_to_Twenty_cm slash_volume average_snow_depth, RANDOM= plot sample Zero_to_Five_cm Five_to_Ten_cm Ten_to_Twenty_cm
;

 


 

New Contributor Ra6
New Contributor
Posts: 4

Re: SAS

Hi, Thanks for the reply. We will have to compare the variables.  I am posting here an example and the solution for your convenience. Here is only one covariate with CRD factorial but we will have to work with two covariates according to my dataset.  

 

Example:

Input Water$ FertTreat$ Plot Plant InitialHt Height;

datalines;

Hi    Control     1     1     5     12.7

Hi    Control     2     1     6.5   16.6

Hi    Control     3     1     5.5   15.7

Hi    Control     4     1     5.5   16.9

Hi    Control     5     1     5.1   14.2

Hi    Liquid      6     1     6.2   23.2

Hi    Liquid      7     1     3.4   20.9

Hi    Liquid      8     1     7.1   25

Hi    Liquid      9     1     8.3   24.6

Hi    Liquid      10    1     5.6   25.7

Hi    Pellet      11    1     3.7   20.1

Hi    Pellet      12    1     1.4   19.9

Hi    Pellet      13    1     3.6   20.8

Hi    Pellet      14    1     6.4   20.6

Hi    Pellet      15    1     5.6   23

Hi    SlowRele    16    1     6.9   21.7

Hi    SlowRele    17    1     5.8   19.8

Hi    SlowRele    18    1     4.8   18.4

Hi    SlowRele    19    1     10.1  19.3

Hi    SlowRele    20    1     3.9   21.9

Lo    Control     21    1     4.5   14.8

Lo    Control     22    1     6.8   16.5

Lo    Control     23    1     4.9   12.7

Lo    Control     24    1     3.6   13.4

Lo    Control     25    1     4.1   10.6

Lo    Liquid      26    1     7.4   27.7

Lo    Liquid      27    1     10    28.1

Lo    Liquid      27    1     9.8   27

Lo    Liquid      28    1     7.4   23.9

Lo    Liquid      30    1     7.1   29.1

Lo    Pellet      31    1     5.9   21.5

Lo    Pellet      32    1     9.6   20.5

Lo    Pellet      33    1     2.6   19.5

Lo    Pellet      34    1     5.3   18.9

Lo    Pellet      35    1     4.8   20

Lo    SlowRele    36    1     5.1   19.2

Lo    SlowRele    37    1     4.6   18.3

Lo    SlowRele    38    1     1.1   20.3

Lo    SlowRele    39    1     6.3   21.2

Lo    SlowRele    40    1     5.4   20.1

Hi    Control     1     2     5     13.1

Hi    Control     2     2     7     17.2

Hi    Control     3     2     5.6   16.6

Hi    Control     4     2     5.9   17.4

Hi    Control     5     2     5.2   14.4

Hi    Liquid      6     2     6.6   24.7

Hi    Liquid      7     2     3.5   22.7

Hi    Liquid      8     2     7.5   25.5

Hi    Liquid      9     2     8.6   26.3

Hi    Liquid      10    2     5.6   27

Hi    Pellet      11    2     3.9   22

Hi    Pellet      12    2     1.8   21.5

Hi    Pellet      13    2     4     22.1

Hi    Pellet      14    2     6.8   22.1

Hi    Pellet      15    2     6     24.9

Hi    SlowRele    16    2     7.2   22.4

Hi    SlowRele    17    2     5.8   21.6

Hi    SlowRele    18    2     5.2   18.7

Hi    SlowRele    19    2     10.4  19.8

Hi    SlowRele    20    2     4.3   22

Lo    Control     21    2     5     15.2

Lo    Control     22    2     6.8   17.1

Lo    Control     23    2     5.1   13.2

Lo    Control     24    2     4.1   14.6

Lo    Control     25    2     4.2   12

Lo    Liquid      26    2     7.8   29.6

Lo    Liquid      27    2     10.2  28.6

Lo    Liquid      27    2     9.9   28.2

Lo    Liquid      28    2     7.5   24.8

Lo    Liquid      30    2     7.3   30.2

Lo    Pellet      31    2     6.2   22.5

Lo    Pellet      32    2     9.8   21.2

Lo    Pellet      33    2     2.7   20.6

Lo    Pellet      34    2     5.6   19.9

Lo    Pellet      35    2     5     20.5

Lo    SlowRele    36    2     5.4   20.8

Lo    SlowRele    37    2     4.6   18.6

Lo    SlowRele    38    2     1.1   21.9

Lo    SlowRele    39    2     6.5   22.5

Lo    SlowRele    40    2     5.9   20.2

;

proc print;

run;

 

%INCLUDE '\\homedir.mtu.edu\home\Desktop\CRD';

%MMAOV (rahman,height, CLASS= plot FertTreat water, FIXED = FertTreat|water initialHt,RANDOM=plot(FertTreat*water) );

 

Solution: C:\Users\Rafia\Documents\Soil Data\SAS 2018\SAS Output_htm#IDX35.mht

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 169 views
  • 0 likes
  • 3 in conversation