TAILIEUCHUNG - SAS/ETS 9.22 User's Guide 50

SAS/Ets User's Guide 50. Provides detailed reference material for using SAS/ETS software and guides you through the analysis and forecasting of features such as univariate and multivariate time series, cross-sectional time series, seasonal adjustments, multiequational nonlinear models, discrete choice models, limited dependent variable models, portfolio analysis, and generation of financial reports, with introductory and advanced examples for each procedure. You can also find complete information about two easy-to-use point-and-click applications: the Time Series Forecasting System, for automatic and interactive time series modeling and forecasting, and the Investment Analysis System, for time-value of money analysis of a variety of investments | 482 F Chapter 9 The COMPUTAB Procedure Details COMPUTAB Procedure Program Flow Example This example shows how the COMPUTAB procedure processes observations in the program working storage and the COMPUTAB data table CDT . Assume you have three years of figures for sales and cost of goods sold CGS and you want to determine total sales and cost of goods sold and calculate gross profit and the profit margin. data example input year sales cgs datalines 1988 83 52 1989 106 85 1990 120 114 proc computab data example columns c88 c89 c90 total rows sales cgs gprofit pctmarg calculate gross profit gprofit sales - cgs select a column c88 year 1988 c89 year 1989 c90 year 1990 calculate row totals for sales and cost of goods sold col total c88 c89 c90 calculate profit margin row pctmarg gprofit cgs 100 run Table shows the CDT before any observation is read in. All the columns and rows are defined with the values initialized to 0. Program Flow Example F 483 Table CDT before Any Input C88 C89 C90 TOTAL SALES 0 0 0 0 CGS 0 0 0 0 GPROFIT 0 0 0 0 PCTMARG 0 0 0 0 When the first input is read in year 1988 sales 83 and cgs 52 the input block puts the values for SALES and CGS in the C88 column since year 1988. Also the value for the gross profit for that year GPROFIT is calculated as indicated in the following statements gprofit sales-cgs c88 year 1988 c89 year 1989 c90 year 1990 Table shows the CDT after the first observation is input. Table CDT after First Observation Input C88 1 C88 C89 C90 TOTAL SALES 83 0 0 0 CGS 52 0 0 0 GPROFIT 31 0 0 0 PCTMARG 0 0 0 0 Similarly the second observation year 1989 sales 106 cgs 85 is put in the second column and the GPROFIT is calculated to be 21. The third observation year 1990 sales 120 cgs 114 is put in the third column and the GPROFIT is calculated to be 6. Table shows the CDT after all observations are input. Table CDT after All Observations Input C88 C89 C90 TOTAL SALES 83 106 120 0 CGS 52 85 114 0 GPROFIT 31 21 6 0 .

• Tài chính doanh nghiệp
• Hướng dẫn sử dụng SAS ETS
• các mô hình phân tích tài chính
• báo cáo tài chính
• phân tích đầu tư
• phân tích tính khả dụng các khoản đầu tư