/* ======================================== This next step creates a SAS dataset of your data specified in the "datalines" ======================================== */ data have; input CARRIER $2.; datalines; B1 B1 B1 B1 A9 A9 OO OO OO OO OO ;RUN; /* ======================================== This next step Uses "PROC SQL" to summarize your data specified in the "datalines and also saves the result in a SAS dataset called CARRIER_SUMMARY" ======================================== */ PROC SQL PRINT; CREATE TABLE CARRIER_SUMMARY AS SELECT DISTINCT CARRIER,COUNT(*) AS FLIGHT_COUNT FROM HAVE GROUP BY CARRIER; QUIT; /* ======================================== This step just prints the summary created ======================================== */ PROC PRINT DATA=CARRIER_SUMMARY NOOBS;   Hope these added comments in the code help.   I've attached the SAS Log for your reference here: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 /* 57 ======================================== 58 This next step creates a SAS dataset of 59 your data specified in the "datalines" 60 ======================================== 61 */ 62 63 data have; 64 input CARRIER $2.; 65 datalines; NOTE: The data set WORK.HAVE has 11 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.05 seconds 77 ;RUN; 78 /* 79 ======================================== 80 This next step Uses "PROC SQL" to summarize 81 your data specified in the "datalines and 82 also saves the result in a SAS dataset 83 called CARRIER_SUMMARY" 84 ======================================== 85 */ 86 PROC SQL PRINT; 87 CREATE TABLE CARRIER_SUMMARY AS 88 SELECT DISTINCT CARRIER,COUNT(*) AS FLIGHT_COUNT FROM HAVE GROUP BY CARRIER; NOTE: Table WORK.CARRIER_SUMMARY created, with 3 rows and 2 columns. 89 QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 90 /* 91 ======================================== 92 This step just prints the summary created 93 ======================================== 94 */ 95 PROC PRINT DATA=CARRIER_SUMMARY NOOBS; 96 97 98 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 110 The code produced the following output. Hope this helps...!!! Good Luck to you DingDing.   CARRIER FLIGHT_COUNT A9 2 B1 4 OO 5 ... View more