1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 /** Import an XLSX file. **/ 75 76 proc import file='D:\Acadamic\MS plant breeding\4th semestor\Dr Hettiarachchi\trial2.xlsx' 77 out=try1 78 dbms=excel replace ; ERROR: DBMS type EXCEL not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 195.12k OS Memory 33444.00k Timestamp 06/03/2021 06:08:03 PM Step Count 61 Switch Count 0 Page Faults 0 Page Reclaims 22 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 79 run ; 80 proc prinqual data=try1 out=try2 n=4 replace mdpref; ERROR: File WORK.TRY1.DATA does not exist. 81 transform identity (avr dfl) ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 82 monotone (rc cc); ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 83 id genotype ; ERROR: No data set open to look up variables. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TRY2 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.TRY2 was not replaced because this step was stopped. NOTE: PROCEDURE PRINQUAL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 349.09k OS Memory 33444.00k Timestamp 06/03/2021 06:08:03 PM Step Count 62 Switch Count 0 Page Faults 0 Page Reclaims 14 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 16 84 Data try3; 85 set try1; ERROR: File WORK.TRY1.DATA does not exist. 86 keep genotype block; WARNING: The variable genotype in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable block in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TRY3 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.TRY3 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 536.34k OS Memory 33700.00k Timestamp 06/03/2021 06:08:03 PM Step Count 63 Switch Count 0 Page Faults 0 Page Reclaims 65 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 87 proc sort; 88 by genotype; ERROR: Variable GENOTYPE not found. 89 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 442.03k OS Memory 33960.00k Timestamp 06/03/2021 06:08:03 PM Step Count 64 Switch Count 0 Page Faults 0 Page Reclaims 50 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 90 Data try4; 91 if (_type_="SCORE")then output try4; 92 set try2; NOTE: Variable _type_ is uninitialized. NOTE: There were 0 observations read from the data set WORK.TRY2. NOTE: The data set WORK.TRY4 has 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 839.75k OS Memory 33960.00k Timestamp 06/03/2021 06:08:03 PM Step Count 65 Switch Count 2 Page Faults 0 Page Reclaims 111 Page Swaps 0 Voluntary Context Switches 10 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 93 proc sort; 94 by genotype; ERROR: Variable GENOTYPE not found. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 434.90k OS Memory 33960.00k Timestamp 06/03/2021 06:08:03 PM Step Count 66 Switch Count 0 Page Faults 0 Page Reclaims 49 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 95 data try5; 96 merge try3 try4; 97 by genotype; 98 run; ERROR: BY variable genotype is not on input data set WORK.TRY3. ERROR: BY variable genotype is not on input data set WORK.TRY4. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TRY5 may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.TRY5 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1076.34k OS Memory 34220.00k Timestamp 06/03/2021 06:08:03 PM Step Count 67 Switch Count 0 Page Faults 0 Page Reclaims 95 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 99 DATA try6; 100 set try5; 101 if(genotype>599) then new=0; 102 else new=1; 103 if(new) then genoc=999; 104 else genoc=genotype; 105 RUN; NOTE: Variable genotype is uninitialized. NOTE: There were 0 observations read from the data set WORK.TRY5. NOTE: The data set WORK.TRY6 has 0 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 950.87k OS Memory 34220.00k Timestamp 06/03/2021 06:08:03 PM Step Count 68 Switch Count 2 Page Faults 0 Page Reclaims 124 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 106 107 PROC GLM data=try6 outstat=stat2; 108 ods output ParameterEstimates=Parms1; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. ERROR: Variable AVR not found. ERROR: Variable DFL not found. ERROR: Variable RC not found. ERROR: Variable CC not found. NOTE: The previous statement has been deleted. ERROR: Variable block not found. NOTE: The previous statement has been deleted. 109 CLASS block genotype genoc; 110 MODEL avrdfl rc cc = block genoc genotype*new/solution; 111 random block; 112 113 RUN; 114 115 /** **/ NOTE: The data set WORK.STAT2 has 0 observations and 0 variables. WARNING: Data set WORK.STAT2 was not replaced because new file is incomplete. NOTE: PROCEDURE GLM used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 461.12k OS Memory 33960.00k Timestamp 06/03/2021 06:08:03 PM Step Count 69 Switch Count 1 Page Faults 0 Page Reclaims 48 Page Swaps 0 Voluntary Context Switches 6 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 WARNING: Output 'ParameterEstimates' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. WARNING: The current ODS SELECT/EXCLUDE/OUTPUT statement was cleared because the end of a procedure step was detected. Probable causes for this include the non-termination of an interactive procedure (type quit; to end the procedure) and a run group with no output. 116 Data avr(rename= Estimate=avr) dfl(rename= Estimate=dfl) 117 rc(rename= Estimate=rc) cc(rename= Estimate=cc) ; 118 set parms1; ERROR: File WORK.PARMS1.DATA does not exist. 119 if (Dependent="avr")then output avr; 120 if (Dependent="dfl")then output dfl; 121 if (Dependent="rc")then output rc; 122 if (Dependent="cc")then output cc; 123 124 keep parameter estimate ; 125 run; WARNING: The variable Estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable parameter in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable parameter in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable parameter in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Estimate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable parameter in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable estimate in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.AVR may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.AVR was not replaced because this step was stopped. WARNING: The data set WORK.DFL may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DFL was not replaced because this step was stopped. WARNING: The data set WORK.RC may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.RC was not replaced because this step was stopped. WARNING: The data set WORK.CC may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.CC was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 1062.93k OS Memory 34468.00k Timestamp 06/03/2021 06:08:03 PM Step Count 70 Switch Count 0 Page Faults 0 Page Reclaims 87 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 32 126 127 proc sort Data= avr; 128 by parameter; ERROR: Variable PARAMETER not found. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 332.90k OS Memory 34468.00k Timestamp 06/03/2021 06:08:03 PM Step Count 71 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 129 proc sort Data= dfl; 130 by parameter; ERROR: Variable PARAMETER not found. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 337.56k OS Memory 34468.00k Timestamp 06/03/2021 06:08:03 PM Step Count 72 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 131 proc sort Data= rc; 132 by parameter; ERROR: Variable PARAMETER not found. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 330.43k OS Memory 34468.00k Timestamp 06/03/2021 06:08:03 PM Step Count 73 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 133 proc sort Data= cc; 134 by parameter; ERROR: Variable PARAMETER not found. 135 NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 344.68k OS Memory 34468.00k Timestamp 06/03/2021 06:08:03 PM Step Count 74 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 136 data means1; 137 merge avr dfl rc cc ; 138 by Parameter; 139 run; ERROR: BY variable Parameter is not on input data set WORK.AVR. ERROR: BY variable Parameter is not on input data set WORK.DFL. ERROR: BY variable Parameter is not on input data set WORK.RC. ERROR: BY variable Parameter is not on input data set WORK.CC. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.MEANS1 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.MEANS1 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1444.84k OS Memory 35236.00k Timestamp 06/03/2021 06:08:03 PM Step Count 75 Switch Count 0 Page Faults 0 Page Reclaims 102 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 16 140 141 /** CLUSTER ANALYSIS **/ 142 143 Data means1 (rename= parameter=genotype);set means1 (firstobs=8); WARNING: FIRSTOBS option > number of observations in WORK.MEANS1. 144 WARNING: The variable parameter in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 0 observations read from the data set WORK.MEANS1. NOTE: The data set WORK.MEANS1 has 0 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 744.53k OS Memory 34980.00k Timestamp 06/03/2021 06:08:03 PM Step Count 76 Switch Count 2 Page Faults 0 Page Reclaims 26 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 160 145 proc distance data=means1 out=tomDist1 method=Euclid; 146 var interval(avr dfl rc cc / std=std ); ERROR: Variable AVR not found. ERROR: Variable DFL not found. ERROR: Variable RC not found. ERROR: Variable CC not found. 147 id genotype; ERROR: Variable GENOTYPE not found. 148 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TOMDIST1 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.TOMDIST1 was not replaced because this step was stopped. NOTE: PROCEDURE DISTANCE used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 355.21k OS Memory 34980.00k Timestamp 06/03/2021 06:08:03 PM Step Count 77 Switch Count 0 Page Faults 0 Page Reclaims 14 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 149 150 proc cluster data=tomDist1 method=average outtree=tomTree noprint; 151 id genotype; ERROR: Variable GENOTYPE not found. 152 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TOMTREE may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.TOMTREE was not replaced because this step was stopped. NOTE: PROCEDURE CLUSTER used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 362.09k OS Memory 34980.00k Timestamp 06/03/2021 06:08:03 PM Step Count 78 Switch Count 0 Page Faults 0 Page Reclaims 14 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 153 axis2 order=(0 to 1.5 by 0.1); 154 proc tree data=tomTree haxis=axis1; 155 id genotype; ERROR: Variable GENOTYPE not found. 156 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE TREE used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 408.53k OS Memory 34980.00k Timestamp 06/03/2021 06:08:03 PM Step Count 79 Switch Count 0 Page Faults 0 Page Reclaims 14 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 157 158 /** SCREE PLOT **/ 159 160 proc factor data=means1 nfactors=4 scree; 161 ods select Eigenvalues ScreePlot; ERROR: Variable AVR not found. ERROR: Variable DFL not found. ERROR: Variable RC not found. ERROR: Variable CC not found. 162 var avr dfl rc cc ; 163 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FACTOR used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 614.56k OS Memory 35240.00k Timestamp 06/03/2021 06:08:03 PM Step Count 80 Switch Count 1 Page Faults 0 Page Reclaims 50 Page Swaps 0 Voluntary Context Switches 6 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 WARNING: Output 'ScreePlot' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. WARNING: Output 'Eigenvalues' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. 164 165 /** PRINCIPAL COMPONENET ANALYSIS **/ 166 167 proc prinqual data=means1 out=data3 n=4 replace mdpref; 168 transform identity(avr dfl rc cc ); ERROR: Variable AVR not found. ERROR: Variable DFL not found. ERROR: Variable RC not found. ERROR: Variable CC not found. 169 id genotype ; ERROR: Variable GENOTYPE not found. 170 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATA3 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DATA3 was not replaced because this step was stopped. NOTE: PROCEDURE PRINQUAL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 352.90k OS Memory 34980.00k Timestamp 06/03/2021 06:08:03 PM Step Count 81 Switch Count 0 Page Faults 0 Page Reclaims 14 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 171 172 /** SCATTER PLOT USING %PLOTIT MACRO **/ 173 174 %plotit(data=data3, datatype=mdpref2 2, 175 symlen=3, vechead= , symsize=1.2); ERROR: Multiple non-listing destinations with multiple styles are open. Destination Style OUTPUT HTML5(WEB) HTMLBlue RTF(WEB) Rtf PDF(WEB) Pearl ERROR: The PLOTIT macro ended abnormally. 176 run; 177 178 179 180 /** EXTRACTING VARIANCE COVARIANCE MATRIX **/ 181 182 Data st2; 183 set Stat2; 184 if _type_="SS1" then delete; 185 186 if _name_= "avr" then output; 187 if _name_= "dfl" then output; 188 if _name_= "rc" then output; 189 if _name_= "cc" then output; 190 191 192 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 204 I Hai Tom, These data were taken from a augmented randomized block design( treatments (individuals in a F2 population) are not randomized but check varieties( SA and Rosana) are randomized). Now I want to find the block effect based on the performances of the check varieties and adjust the treatment values. Then I wanted to do a principle component analysis, correlation analysis and cluster analysis.  ... View more

Thank you very much Sir.. ... View more

It is working and Thank you very much Sajid..I spent a couple of days trying to figure it out. ... View more

Thank you for your reply and here is my SAS programme as a SAS document. DATA onerep; INPUT plot Entry Name$ Block AFW; datalines; 1 306 SA 1 43.2 2 1 P1 1 41 3 2 P2 1 46 4 3 P3 1 40 5 4 P4 1 49 6 5 P5 1 49 7 6 P6 1 47 8 7 P7 1 47 9 8 P8 1 52 10 9 P9 1 41 11 10 P10 1 46 12 11 P11 1 34 13 12 P12 1 40 14 13 P13 1 47 15 14 P14 1 45 17 15 P15 1 46 18 16 P16 1 42 19 17 P17 1 52 20 18 P18 1 43 21 19 P19 1 46 22 20 P20 1 35 23 21 P21 1 41 24 22 P22 1 50 25 23 P23 1 49 26 24 P24 1 50 27 25 P25 1 45 28 26 P26 1 41 29 27 P27 1 45 30 28 P28 1 39 31 29 P29 1 46 32 30 P30 1 42 33 31 P31 1 45 34 32 P32 1 50 35 33 P33 1 50 36 34 P34 1 60 37 35 P35 1 49 38 36 P36 1 52 39 37 P37 1 46 40 307 Rosana 1 44.8 41 38 P38 1 45 42 39 P39 1 44 43 40 P40 1 41 44 41 P41 1 41 45 42 P42 1 47 46 43 P43 1 44 47 44 P44 1 40 49 306 SA 2 47.8 50 45 P45 2 40 51 46 P46 2 48 52 47 P47 2 44 53 48 P48 2 47 54 49 P49 2 43 55 50 P50 2 53 56 51 P51 2 50 57 52 P52 2 41 58 53 P53 2 44 59 54 P54 2 41 60 55 P55 2 44 61 56 P56 2 47 62 57 P57 2 52 63 58 P58 2 44 64 59 P59 2 49 65 60 P60 2 57 67 61 P61 2 41 68 62 P62 2 53 69 63 P63 2 41 70 64 P64 2 53 71 65 P65 2 56 72 66 P66 2 60 73 67 P67 2 43 74 68 P68 2 41 75 69 P69 2 54 76 70 P70 2 45 77 71 P71 2 43 78 72 P72 2 58 79 73 P73 2 45 80 74 P74 2 61 81 75 P75 2 52 82 76 P76 2 42 83 307 Rosana 2 43.75 84 77 P77 2 50 85 78 P78 2 51 86 79 P79 2 51 87 80 P80 2 50 88 81 P81 2 64 89 82 P82 2 56 90 83 P83 2 64 91 84 P84 2 61 92 85 P85 2 57 93 86 P86 2 43 94 87 P87 2 38 95 88 P88 2 47 96 89 P89 2 54 97 90 P90 2 52 98 91 P91 2 52 99 92 P92 2 49 100 93 P93 2 53 101 94 P94 2 45 102 95 P95 2 50 104 306 SA 3 48.25 105 96 P96 3 47 106 97 P97 3 46 107 98 P98 3 44 108 99 P99 3 45 109 100 P100 3 45 110 101 P101 3 47 111 102 P102 3 45 112 103 P103 3 49 113 104 P104 3 47 114 105 P105 3 43 115 106 P106 3 50 116 107 P107 3 52 117 108 P108 3 45 118 109 P109 3 50 120 110 P110 3 35 121 111 P111 3 50 122 112 P112 3 48 123 113 P113 3 45 124 114 P114 3 53 125 115 P115 3 47 126 116 P116 3 40 127 117 P117 3 53 128 118 P118 3 44 129 119 P119 3 48 130 120 P120 3 41 131 121 P121 3 43 132 122 P122 3 46 133 123 P123 3 45 134 124 P124 3 40 135 125 P125 3 46 136 126 P126 3 37 137 127 P127 3 47 138 128 P128 3 42 139 307 Rosana 3 45 140 129 P129 3 43 141 130 P130 3 47 142 131 P131 3 42 143 132 P132 3 48 144 133 P133 3 48 145 134 P134 3 45 146 135 P135 3 39 147 136 P136 3 47 148 137 P137 3 50 149 138 P138 3 49 150 139 P139 3 41 151 140 P140 3 41 152 141 P141 3 62 153 142 P142 3 46 154 143 P143 3 52 155 144 P144 3 39 156 145 P145 3 35 157 146 P146 3 53 ; PROC PRINT; RUN;/*prepare the dataset to run a mixed model analysis with new entries random*/ DATA arcbd; set onerep; if(entry>305) then new=0; else new=1; if(new) then entryc=999; else entryc=entry; RUN; PROC GLM data=arcbd; TITLE 'ANOVA for mixed model using GLM'; CLASS block entry entryc; MODEL AFW=block entryc entry*new/solution; RANDOM block/test; LSMEANS entryc/stderr; RUN; ... View more

Thank you for your reply and here is my SAS programme as a .SAS document. ... View more

Thank you Reeza for your reply. I used '--' just to show the continuity of my data set for you. Could you please explain me how to convert the variables in to numeric variables?  ... View more