lesson 11.4.17 level 1--> order_type could not be found

[Thirumagal manivannan]

Hi,
lesson 11.4.17 level 1--> order_type could not be found.

code


*/formatting the ordertype values*/
proc format ;
value ordertypes
       1='retail'
       2='catalog'
       3='internet';
run;

/* creating mean */   
Title'Revenue from all Orders';  
proc means data=orion.order_fact;
run;
title;

/* creating SUM*/
proc means data=orion.order_fact sum;
var Total_retail_price;
run;

/* crating class type*/
proc means data=orion.order_fact sum;
var Total_retail_price;
class order_date order_type;
run;
/* creating formats for date*/

 proc means data=orion.order_fact sum;
var Total_retail_price;
class order_date order_type;
format order_date year4. Order_type ordertypes.;
run;

log for this program

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 42         ;
 43         
 44         
 45         */formatting the ordertype values*/
 46         proc format ;
 47         value ordertypes
            _____
            180
 ERROR 180-322: Statement is not valid or it is used out of proper order.
 
 48                1='retail'
 49                2='catalog'
 50                3='internet';
 
 51         run;
 52         
 53         /* creating mean */
 54         Title'Revenue from all Orders';
 55         proc means data=orion.order_fact;
 56         run;
 
 NOTE: There were 617 observations read from the data set ORION.ORDER_FACT.
 NOTE: The PROCEDURE MEANS printed page 47.
 NOTE: PROCEDURE MEANS used (Total process time):
       real time           0.52 seconds
       cpu time            0.53 seconds
       
 
 57         title;
 58         
 59         /* creating SUM*/
 60         proc means data=orion.order_fact sum;
 61         var Total_retail_price;
 62         run;
 
 NOTE: There were 617 observations read from the data set ORION.ORDER_FACT.
 NOTE: The PROCEDURE MEANS printed page 48.
 NOTE: PROCEDURE MEANS used (Total process time):
       real time           0.09 seconds
       cpu time            0.10 seconds
       
 
 63         
 64         /* crating class type*/
 65         proc means data=orion.order_fact sum;
 66         var Total_retail_price;
 67         class order_date order_type;
 68         run;
 
 NOTE: There were 617 observations read from the data set ORION.ORDER_FACT.
 NOTE: The PROCEDURE MEANS printed pages 49-69.
 NOTE: PROCEDURE MEANS used (Total process time):
       real time           3.96 seconds
       cpu time            4.24 seconds
       
 
 69         /* creating formats for date*/
 70         
 71          proc means data=orion.order_fact sum;
 72         var Total_retail_price;
 73         class order_date order_type;
 74         format order_date year4. Order_type ordertypes.;
 ERROR: The format ORDERTYPES was not found or could not be loaded.
 75         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE MEANS used (Total process time):
       real time           0.02 seconds
       cpu time            0.02 seconds
       
 76         ;
 77         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 87         ;

[Anova Groups]

check your first comment.