Free Essay

Procedure in Sas

In: Business and Management

Submitted By arunmsc
Words 3610
Pages 15
SAS Global Forum 2008

Reporting and Information Visualization

Paper 264-2008

PROC TABULATE® and the Neat Things You Can Do With It
Wendi L. Wright, CTB / McGraw-Hill, Harrisburg, PA

ABSTRACT
This paper starts with an introduction to PROC TABULATE®. It looks at the basic syntax, and then builds on this syntax by using examples on how to produce one-, two-, and three-dimensional tables using the
TABLE statement. Some of the examples cover how to choose statistics for the table, labeling variables and statistics, how to add totals and subtotals, working with percents and missing data, and how to clean up the table.
The presentation then shows several examples using the ODS STYLE= option in PROC TABULATE to customize tables and improve their attractiveness. This option is versatile and, depending on where the option is used, has the ability to justify cells or row and column headings, change colors for both the foreground and background of the table, modify borders, add a flyover text box in ODS HTML, or add GIF figures to the row or column headings.

INTRODUCTION
PROC TABULATE is a procedure that displays descriptive statistics in tabular format. It computes many statistics that other procedures compute, such as MEANS, FREQ, and REPORT and displays these statistics in a table format. TABULATE will produce tables in up to three dimensions and allows, within each dimension, multiple variables to be reported one after another hierarchically. There are also some very nice mechanisms that can be used to label and format the variables and the statistics produced.

BASIC SYNTAX
PROC TABULATE <options>;
CLASS variables < / options>;
VAR variables < / options>;
TABLE <page> ,
<row> , column < / options> ;
… other statements … ;
RUN;
Let’s take a look at the basic syntax of the PROC TABULATE Procedure. We will start with three of the statements that you can use in PROC TABULATE, CLASS, VAR, and TABLE. As you can see each of these statements, as well as the PROC TABULATE statement itself allows options to be added. For each of the statements, the options need to be preceded with a ‘/’.
Note two differences in the syntax from any other Procedure in SAS®. One, the variables in all three statements can not be separated by commas. And two, the commas in the table statement are treated in a special way and mean a change in dimension.

1

SAS Global Forum 2008

Reporting and Information Visualization

VAR STATEMENT
The VAR statement is used to list the variables you intend to use to create summary statistics on. As such, they must be numeric.

CLASS STATEMENT
Classification variables allow you to get statistics by category. You will get one column or row for each value of the CLASS variable. You will need make sure you use a categorical variable with a limited number of categories or you may end up producing more pages of output than you intended.
The syntax for the CLASS statement is similar to the VAR statement. You list the variables you want to use for grouping data followed by a ‘/’ and any options you want. The variables here can be either numeric or character (unlike the VAR statement which requires numeric). The statistics you can request for these variables are only counts and percents. The statistics will be produced for each LEVEL of the variable. This is almost like using a BY statement within the table.

TABLE STATEMENT
The Table statement consists of up to three dimension expressions and the table options. To identify different dimensions, use commas. The order of the dimensions is page, row, and column. If you only specify one dimension, then it is assumed to be column. If two are specified, row, then column. Options appear at the end after a ‘/’.
You can have multiple table statements in one PROC TABULATE. This will generate one table for each statement. All variables listed in the table statement must also be listed in either the VAR or CLASS statements. In the table expressions, there are many statistics that can be specified. Among them are row and column percents, counts, means, and percentiles.

CONSTRUCTING A TABLE STATEMENT – DIMENSION EXPRESSIONS
There are many elements you can use to construct a table expression. You start with the variables want to include in the table, but you can also specify the universal CLASS variable ALL which allows to get totals. You will also need to specify what statistics you want to put in the cells of the table. make your table ‘pretty’, you can also specify formats, labels, and ODS style specifications in expression. you you To the We begin by taking a closer look at constructing dimension expressions. Here is where PROC
TABULATE differs from all the other Procedures in the SAS programming language. The syntax used for
PROC TABULATE is very different.






A comma specifies to add a new dimension.
The asterisk is used to produce a cross tabulation of one variable with another (within the same dimension however, different from PROC FREQ).
A blank is used to represent concatenation (i.e. place this output element after the preceding variable listed).
Parenthesis will group elements and associate an operator with each element in the group
Angle brackets specify a denominator definition for use in percentage calculations.

2

SAS Global Forum 2008

Reporting and Information Visualization

CONTRUCTING A SINGLE DIMENSIONAL TABLE
The code below will produce a single dimension table. We have one VAR variable – income, and one
CLASS variable – gender. To request what statistic you would like to see, use a ‘*’ and add the name of the statistic next to the VAR variable you want to use for producing the statistics. As demonstrated below, you can group multiple statistics and variables with parentheses to get the results you want. We are also requesting that mean income be produced for each level of the class variable gender.
Notice that there are NO commas included in the TABLES statement. This indicates to SAS that this is to be a one dimensional table.
PROC TABULATE data=one;
CLASS GENDER;
VAR income;
TABLE income * (N Mean)
RUN;

INCOME * MEAN * GENDER;

ADDING STATISTICS
The code above requested two statistics, N and Mean. You can produce many other statistics. Below is a table of them. If you do not provide a statistic name, the default statistic produced will be ‘N’ for the
CLASS variables and ‘SUM’ for the VAR variables.
Descriptive Statistics
COLPCTN
PCTSUM
COLPCTSUM
MAX
ROWPCTN
MEAN
ROWPCTSUM
MIN
STDDEV / STD
N
STDERR
NMISS
SUM
PAGEPCTSUM
PCTN
VAR

Quantile Statistics
MEDIAN | P50
P1
Q3 | P75
P90
P95
P5
P10
P99
Q1 | P25
QRANGE

Hypothesis Testing
ProbT
T

3

SAS Global Forum 2008

Reporting and Information Visualization

TWO DIMENSIONAL TABLE
To create a two dimensional table, we need to add some additional detail to our TABLES statement. We specify first the row dimension, then the column dimension, separated by a comma. You can get very different table structures by changing where the statistic definitions are placed. They can be attached to either the VAR or the CLASS variable, but the numbers in the cells will ALWAYS be calculated using the
VAR variable(s).
Here we have the statistics attached to the columns.
PROC TABULATE data=one;
CLASS gender;
VAR income;
TABLE gender, income * (N Mean Max) ;
RUN;

If you move the statistic specification so that it is attached to the rows, the results look very different.
PROC TABULATE data=one;
CLASS gender;
VAR income;
TABLE gender * (N Mean Max) , income ;
RUN;

4

SAS Global Forum 2008

Reporting and Information Visualization

MORE THAN ONE CLASSIFICATION VARIABLE
You can specify multiple classification variables. They can be used in any of the dimensions and can be nested. In our example, we have three CLASS variables. Two of the CLASS variables are nested in the row dimension, Fulltime * Gender.
When you have multiple CLASS variables, I recommend using the option MISSING. By default, The
CLASS statement tells SAS to drop observations that have a missing value in even ONE of the variables.
If you specify the MISSING option in your CLASS statement, SAS does NOT remove that observation from all the tables and will consider the missing values as valid levels for the CLASS variable(s).

PROC TABULATE data=one;
CLASS gender fulltime educ / MISSING;
VAR income;
TABLE fulltime * gender ,
Income * educ * mean ;
RUN;

5

SAS Global Forum 2008

Reporting and Information Visualization

ADDING TOTALS AND SUBTOTALS
In order to get marginal statistics in your table, you use the ‘ALL’ keyword. You can use the keyword in multiple places and, depending on where you put the keyword, there will be different subtotals produced.
You can place the keyword on the row or the column dimensions or on both. In this example we are requesting subtotals for Gender and overall totals for both the row and the column dimensions.
PROC TABULATE data=one;
CLASS gender fulltime educ;
TABLE (fulltime ALL) * gender ALL, educ * N;
RUN;

A few additional code examples are here. These demonstrate that the ALL keyword can be used as many times as you wish.
PROC TABULATE data=one;
CLASS gender fulltime educ;
TABLE fulltime * (gender ALL) ,
(educ all)* N ;
RUN;
PROC TABULATE data=one;
CLASS gender fulltime educ;
TABLE (fulltime ALL) * (gender ALL) * ALL ,
(educ all)* N ;
RUN;

6

SAS Global Forum 2008

Reporting and Information Visualization

ADDING AND HIDING ROW AND COLUMN LABELS
There are two ways to add labels for your variables. The first is the simplest. Just add the text =‘label’ after the variable name to the TABLE dimension expression. This will work for both variables and statistics. The second way is to add a LABEL statement for variables and/or a KEYLABEL statement for statistics to your code. For example:
LABEL var=‘label’;
KEYLABEL stat=‘label’;
In order to hide variable or statistic labels, you leave the label specification blank (i.e. =‘ ‘ ).
The following example demonstrates the simpler way to add and hide labels.
PROC TABULATE data=one;
CLASS educ gender fulltime;
VAR income;
TABLE educ ,
Fulltime='Employment Status' * gender = ' income * mean = ' ' ;
RUN;

Alternatively, you can use this code to produce the table above:
PROC TABULATE data=one;
CLASS educ gender fulltime;
VAR income;
TABLE educ,
Fulltime * gender * income * mean ;
LABEL gender=' ' Fulltime='Employment Status';
KEYLABEL mean=' ';
RUN;

7

'

*

SAS Global Forum 2008

Reporting and Information Visualization

FILLING THE BIG WHITE BOX
To fill in the big white box in the upper left, use the BOX= option.
PROC TABULATE data=one;
CLASS gender fulltime;
VAR income;
TABLE fulltime = 'Employment Status',
Gender * income * mean
/ BOX='Mean Income' ;
RUN;

THREE DIMENSIONAL TABLES
Three dimensional tables are easy to produce, just add another section BEFORE the row and column expressions in the table statement. PROC TABULATE will now interpret the dimension statements in this order, first page, then the row, then the columns.
Three dimensional tables have a nice way to fill in the upper left area. Instead of the label of the page dimension appearing above the table, you can use the BOX=_page_ option to place that label inside the big white box. Only a part of the output is included here.
PROC TABULATE data=one;
CLASS gender fulltime educ;
VAR income;
TABLE educ='Education', fulltime = 'Employment Status',
Gender * income * mean
/ BOX=_PAGE_ ;
RUN;
This will produce a separate table for each level of education with the value of the variable education in the big white box.

8

SAS Global Forum 2008

Reporting and Information Visualization

PRODUCING CELL PERCENTS
One of the nice things about PROC TABULATE is that it will allows you to put both percents and summary statistics in the same table. You can get percentages on both numeric and character since the percents are just based on counts. The VAR statement is not needed unless you want to add other summary statistics besides count and percents. Just use the CLASS statement. Several types of percents can be requested or you can construct your own percentages by specifying the denominator you wish to use. The use of a complex denominator will not be covered here. We will only cover the three percents that are most commonly used:
PCTN - percent of total.
ROWPCTN – percent across row (use row total as denominator).
COLPCTN – percent across column (use column total as denominator).
This example shows the use of ROWPCTN. Note that the percents will add up to 100% (taking into account rounding errors) across each row. COLPCTN works similarly – the columns will add up to 100%.
PROC TABULATE data=one;
CLASS ethnic educ;
TABLE ethnic * ROWPCTN,
Educ ;
RUN;

ADDING FORMATS TO THE STATISTICS AND REMOVING HORIZONTAL SEPARATORS
Let’s take a look at two simple options to improve the table’s look. The first option allows you to specify formats for the numbers in the cells of the table using the *F=fmt. expression. The second option is the
NOSEPS option which removes the horizontal dividers between the row values from your table.
PROC TABULATE data=one NOSEPS;
CLASS educ gender fulltime / missing;
VAR income;
TABLE educ=' ' * (fulltime=' ' ALL), gender=' ' * Income=' ' * ( N*F=6.
RUN;

9

MEAN*F=Dollar8. );

SAS Global Forum 2008

Reporting and Information Visualization

MORE OPTIONS TO CLEAN UP ROW HEADERS
Two more options to improve the look of your table are INDENT= which is very nice for subsetting row subheaders and RTS= which specifies how wide you want the row header field to be. Note, the RTS= count includes the | bar dividers at the beginning and the end of the row header fields, so include these in your count.
PROC TABULATE data=one NOSEPS;
CLASS educ gender fulltime / missing;
VAR income;
TABLE educ=' ' * (fulltime=' ' ALL), gender=' ' * Income=' ' * ( N*F=6. MEAN*F=Dollar8. )
/ BOX='Income' INDENT=3 RTS=12;
RUN;

10

SAS Global Forum 2008

Reporting and Information Visualization

ODS STYLE ELEMENTS
ODS Style elements can also be used to change the look of a table. A few are listed below. These elements all work with HTML, PDF, RTF, PS and PCL destinations. Other elements are listed in the
“SAS 9.1 Output Delivery System: User’s Guide” that you can find at http://support.sas.com/documentation/onlinedoc/91pdf/ .
Foreground/Background=
BorderWidth=
Just/Vjust=
Font_Face/Font_Weight/Font_Size=
Rules=
CellWidth/CellHeight=
Cellpadding/CellSpacing=
OutputWidth=

modify color specify thickness of borders specify horizontal and vertical justification change font characteristics specify horizontal and vertical rule dividers change size of table cells specify white space and thickness of spacing around cell specify width of table

WHERE DO YOU PUT THE STYLE ELEMENTS?
Depending on where you place the style options, many different results can be achieved. If you place the style options on the PROC TABULATE statement, for example, you will affect all the table cells. See below for a list of some of the different places where you can put the style options and what portion of the table they will affect.
Note that for the CLASS, CLASSLEV, VAR, and KEYWORD statements, the style options can also be specified in the dimension expression in the Table statement.
Style Place In
PROC TABULATE S=[ …]
CLASS varname / S=[ …]
CLASSLEV varname / S=[ …]
VAR varname / S=[ …]
KEYWORD stat / S=[ …]
TABLE page,row,col / S=[ …]
BOX={label=’ ‘ S=[ …] }

Part of Table Affected data cells heading for variable varname class values for variable varname heading for variable varname heading for named stat table borders, rules, cell spacing table Box

CHANGING THE FOREGROUND (TEXT) OR BACKGROUND COLOR
Here is an example showing how to change the color in various parts of the table. Notice that we are applying a black foreground (text) to all cells in the table. For the gender variable we are assigning a background of yellow to the values only (not to the column header) using the CLASSLEV statement. For the mean statistic label we are using a foreground of white and a background of purple.

11

SAS Global Forum 2008

Reporting and Information Visualization

ODS RTF file='c:\myfile.rtf';
PROC TABULATE data=one f=10.2 S=[foreground=black];
CLASS gender;
CLASSLEV gender / S=[background=yellow];
VAR income;
TABLE gender=' ' all={label='Tot'}, mean={s=[foreground=white background=purple]} * income
/
box={label='Income'};
Run;
ODS RTF close;

ADDING JUSTIFICATION
This example shows how to add justification to three sections of the table. We are going to center all the cells inside the table, right justify the total ‘Tot’ row label, and Bottom Right justify the text inside the upper left box.
You can use ODS Style options to add many things to the table. Here is an example that adds color and justification. We are setting the foreground (print type) to be black and all the cells should be centered.
Note the use of the new CLASSLEV statement that we have not seen before.
ODS RTF file='c:\myfile.rtf';
PROC TABULATE data=one f=10.2 S=[foreground=black just=c];
CLASS gender;
CLASSLEV gender / S=[background=yellow];
VAR income;
TABLE gender=' ' all={label='Tot' s=[just=R]}, mean={s=[foreground=white background=purple]} * income
/
box={label='Income' s=[VJust=B Just=R]};
Run;
ODS RTF close;

12

SAS Global Forum 2008

Reporting and Information Visualization

CHANGING CELL WIDTH
This example shows how to change the cell width of both the row headers and the columns of the table.
ODS RTF file='c:\myfile.rtf';
PROC TABULATE data=one f=10.2 S=[foreground=black just=c cellwidth=200];
CLASS gender / S=[cellwidth=250];
CLASSLEV gender / S=[background=yellow];
VAR income;
TABLE gender=' ' all={label='Tot' s=[just=R]}, mean={s=[foreground=white background=purple]} * income
/
box={label='Income' s=[VJust=B Just=R]};
Run;
ODS RTF close;

REMOVING THE LINES IN THE TABLE AND ADJUSTING CELL SPACING
With the addition of the rules, cellspacing and cellpadding options we can remove all lines from the table.
ODS RTF file='c:\myfile.rtf';
PROC TABULATE data=one f=10.2 S=[foreground=black cellwidth=200 just=c];
CLASS gender;
CLASSLEV gender / S=[background=yellow];
VAR income;
TABLE gender=' ' all={label='Tot' s=[just=R]}, mean={s=[foreground=white background=purple]} * income
/
s=[rules=none cellspacing=0 cellpadding=10] box={label='Income' s=[VJust=B Just=R]};
Run;
ODS RTF close;

13

SAS Global Forum 2008

Reporting and Information Visualization

ADDING A FLYOVER TEXT BOX USING ODS AND PROC FORMAT
You can use formats with styles to do a number of tricks. One thing you can do is to add a flyover text box to your row or column header cells. The result can not be demonstrated here, but what happens is when you hold your curser over the column header when you view the table in a Web Browser, a little text box will open underneath that shows the text you have in your format.
PROC FORMAT;
VALUE $ethnic
'W'='White - Non-Hispanic'
'H'='Hispanic American'
'I'='American Indian'
'A'='Asian'
'B'='African American'
' '='Missing'
;
ODS HTML file='c:\myfile.HTML';
PROC TABULATE data=one;
CLASS ethnic gender;
CLASSLEV ethnic / s=[flyover=$ethnic.];
VAR income;
TABLE gender, ethnic * income;
RUN;
ODS HTML CLOSE;

USING PROC FORMAT AND ODS TO ADD PICTURES TO YOUR TABLE
Another trick is to add a figure to the row or column header cell. Note that in this example, the gif files needed to be in the same directory that the HTML file was in.

PROC FORMAT;
VALUE $gendGif
'M'='bluebutterfly.gif'
'F'='pinkbutterfly.gif';
RUN;
ODS HTML file='c:\myfile.HTML';
PROC TABULATE data=one;
CLASS GENDER;
CLASSLEV gender / S=[VJust=T postimage=$gendGif. Cellwidth=80];
VAR income;
TABLE income * (N Mean)
INCOME * MEAN * GENDER;
RUN;
ODS HTML CLOSE;

14

SAS Global Forum 2008

Reporting and Information Visualization

ADDING COLORS TO CELLS BASED ON VALUES IN THE CELLS
The next trick I am going to mention is how to use a format to highlight different cells with different colors based on the final value in the cell. title ‘Highlighting Cell Values with Colors’;
ODS HTML FILE='c:\myfile.html';
PROC FORMAT;
VALUE watchit
0 - 20000 = 'Green'
20001 - 40000 = 'Orange'
40001 - 50000 = 'Blue'
50001 - 60000 = 'Purple'
60001 - high = 'Red' ;
RUN;
PROC TABULATE data=one S=[foreground=watchit.] ;
CLASS gender ethnic / MISSING;
VAR income;
TABLE gender ALL,
Income * (ethnic ALL) * Mean;
RUN;
ODS HTML CLOSE;

15

SAS Global Forum 2008

Reporting and Information Visualization

ADDING COLORS TO ROW/COLUMN HEADERS BASED ON THEIR VALUES
The last trick is how to change the background color of the row headers based on the value of the class variable. title ‘Highlighting Row Headers with Colors’;
ODS HTML FILE='c:\myfile.html';
PROC FORMAT;
VALUE $gendbac
'M'='blue'
'F'='pink';
VALUE $gendfor
'M'='white'
'F'='black';
RUN;
PROC TABULATE data=one;
CLASS gender;
CLASSLEV gender / S=[background=$gendbac. Foreground=$gendfor. Cellwidth=80];
VAR income;
TABLE gender ALL,
Income * (N Mean Std);
RUN;
ODS HTML CLOSE;

16

SAS Global Forum 2008

Reporting and Information Visualization

CONCLUSION
Proc Tabulate can greatly increase your ability to produce informative, beautiful, and professional looking tables. This paper covered many of the ways to produce a great table, but the options described here are by no means exhaustive of what you can do with PROC TABULATE.
There are several very good resources that you can use to learn more about PROC TABULATE. Among them are:
PROC TABULATE by Example, by Lauren Haworth
SAS Guide to Report Writing: Examples, by Michele M. Burlew
SAS Guide to TABULATE Processing

AUTHOR CONTACT
Your comments and questions are valued and welcome. Contact the author at:
Wendi L. Wright
1351 Fishing Creek Valley Rd.
Harrisburg, PA 17112
Phone: (717) 513-0027
E-mail: wendi_wright@ctb.com
SAS and all other SAS Institute Inc. products or service names are registered trademarks or trademarks of SAS Institute, Inc. in the USA and other countries. ® indicates USA registration.
Other brand and product names are trademarks of their respective companies.

17

Similar Documents

Free Essay

Sas Procedures

...SAS Global Forum 2009 Pharma, Life Sciences and Healthcare Paper 174-2009 Clinical Trial Reporting Using SAS/GRAPH® SG Procedures Susan Schwartz, SAS Institute Inc., Cary, NC ABSTRACT Graphics are a powerful way to display clinical trial data. By their very nature, clinical trials generate a large amount of information, and a concise visual presentation of the results is essential. Information about the patient population, drug dosages, clinical responses, and adverse events must be clear. Clinical laboratory results need to be presented within the context of acceptable limits, and subtle changes over time must be highlighted. This presentation will show, by example, how such graphs can easily be created using the SAS/GRAPH® SG procedures. The techniques that will be emphasized in this presentation include: • • • • • • Creation of a dose response plot by overlaying multiple plots in one graph Construction of a hematology panel using treatment regimen and visit numbers as the classification variables Presentation of a matrix of liver function tests (LFTs) for at-risk patients Aggregation of data into on-the-fly classification variables using user-defined formats Getting the axis you want using built-in best fit algorithms Generation of publication-ready graphs in color and in black and white INTRODUCTION The new SAS/GRAPH procedures—SGPLOT, SGPANEL, and SGSCATTER—provide new tools for viewing and reporting data collected during clinical trials. The SG procedures are an extension...

Words: 7726 - Pages: 31

Free Essay

Sas Certification Sample Test 50

...SAS 认证考试样题 1.A raw data file is listed below. 1---+----10---+----20---+--son Frank 01/31/89 daughter June 12-25-87 brother Samuel 01/17/51 The following program is submitted using this file as input: data work.family; infile 'file-specification'; run; Which INPUT statement correctly reads the values for the variable Birthdate as SAS date values? a. input b. input c. input d. input relation relation relation relation $ $ $ $ first_name first_name first_name first_name $ $ $ $ birthdate birthdate birthdate birthdate date9.; mmddyy8.; : date9.; : mmddyy8.; Correct answer: d An informat is used to translate the calendar date to a SAS date value. The date values are in the form of two-digit values for month-day-year, so the MMDDYY8. informat must be used. When using an informat with list input, the colon-format modifier is required to correctly associate the informat with the variable name. You can learn about • • informats in Reading Date and Time Values the colon-format modifier in Reading Free-Format Data. 2.A raw data file is listed below. 1---+----10---+----20---+--Jose,47,210 Sue,,108 The following SAS program is submitted using the raw data file above as input: data employeestats; input name $ age weight; run; The following output is desired: name age weight Jose 47 210 Sue . 108 Which of the following INFILE statements completes the program and accesses the data correctly? a. infile 'file-specification' pad; b. infile 'file-specification'...

Words: 4408 - Pages: 18

Premium Essay

The Effect of Sas No. 99 on Auditor’s Responsibility to Detect Fraud

...The Effect of SAS No. 99 on Auditor’s Responsibility to Detect Fraud The Auditing Standards Board (ASB) issued the Statement of Auditing Standard (SAS) 99 known as Consideration of Fraud in a Financial Statement Audit in November 2002. SAS 99 supersedes SAS 82 in response to its inadequacies, which were brought to light after the major accounting scandals including those at Enron, Worldcom, Adelphia and Tyco. It became effective for all financial statement audits on or after December 15, 2002 with the intention of rebuilding the confidence of investors into major public companies and reestablishing audited financial statements as a reliable component of corporate America. Once the standard came into effect, it was important to measure auditors’ reactions to the effectiveness of SAS 99. The overall conclusion is that SAS 99 has a positive effect on the auditors’ responsibility to detect fraud in financial statements as it not only focuses on the detection of fraud, but also takes on a more proactive approach to the prevention and deterrence of fraud. With the issuance of SAS 99, auditor responsibility has increased and improved the perceptions on auditor responsibility to third parties. The standard emphasizes professional skepticism and reminds auditors to no longer rely on client representations by keeping a questionable mindset. As quoted by Ramos, “SAS no. 99 reminds auditors they need to overcome some natural tendencies—such as overreliance on client representations—and...

Words: 2557 - Pages: 11

Premium Essay

Sas 4

...not defined. Solutions to Exercises .............................................................. Error! Bookmark not defined. Solutions to Student Activities (Polls/Quizzes) .......................... Error! Bookmark not defined. 6-2 Chapter 6 Reading Excel Worksheets 6.1 Using Excel Data as Input 6-3 6.1 Using Excel Data as Input Objectives   Use the DATA step to create a SAS data set from an Excel worksheet. Use the SAS/ACCESS LIBNAME statement to read from an Excel worksheet as though it were a SAS data set. 3 Business Scenario An existing data source contains information on Orion Star sales employees from Australia and the United States. A new SAS data set needs to be created that contains a subset of this existing data source. This new SAS data set must contain the following:  only the employees from Australia who are Sales Representatives  the employee's first name, last name, salary, job title, and hired date  labels and formats in the descriptor portion 4 6-4 Chapter 6 Reading Excel Worksheets Business Scenario Reading SAS Data Sets Reading Excel Worksheets Reading Delimited Raw Data Files 5...

Words: 4761 - Pages: 20

Free Essay

Carl Neil the Great Priest Scientist

...KulangsaTransportasyon IsangPagsasaliksikngSuliranin Ng Barangay MgaMananaliksik: De los Reyes, Rhea A. Enriquez, Carl Neil A. Samane, John Eric V. Saraña, Aramina A. Guro: Ginoong Reynaldo Temblor Dumaguete City High School Calindagan, Dumaguete City SY 2014-2015 II. Problem Statement Ano ang solusyon sa kakulangan ng transportasyon sa Barangay Bajumpandan? III. Hypothesis A. Paghimay ng mga element na iuugnay: Ang schedule ng pagbiyahe at dami ng unit ng pampasaherong easyride o multicab sa Barangay Bajumpandan. B. Hinuha: Kapag darami ang schedule at dami ng pampasaherong multicab patungong Bajumpandan, mas magiging madali ang transportasyon sa Barangay Bajumpandan. IV. Methodology Experimental Design: The research was through interview and giving survey forms to some barangay Bajumpandan citizens. Sampling Design: Only Bajumpandan citizens, barangay officials, Route F and G (Route to Bajumpandan) multicab drivers or visitors to Bajumpandan can be interviewed or given the survey form. Materials: The survey form Ballpen Paper General Procedure: A. The researchers interviewed 10 citizens of barangay Bajumpandan regarding their suggestions and comments about the transportation services and systems in barangay Bajumpandan, specifically the multi-cabs. B. The researchers also gave them survey forms to answer. C. They also asked 2 barangay officials...

Words: 1035 - Pages: 5

Free Essay

The Little Sas Book

...The Little SAS Book a T H I ® p R D r E i D I m T I e O r N Lora D. Delwiche and Susan J. Slaughter The correct bibliographic citation for this manual is as follows: Delwiche, Lora D. and Slaughter, Susan J., 2003. The Little SASâ Book: A Primer, Third Edition. Cary, NC: SAS Institute Inc. The Little SASâ Book: A Primer, Third Edition Copyright © 2003, SAS Institute Inc., Cary, NC, USA ISBN 1-59047-333-7 All rights reserved. Produced in the United States of America. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc. U.S. Government Restricted Rights Notice: Use, duplication, or disclosure of this software and related documentation by the U.S. government is subject to the Agreement with SAS Institute and the restrictions set forth in FAR 52.227-19, Commercial Computer Software-Restricted Rights (June 1987). SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513. 1st printing, November 2003 SAS Publishing provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential. For more information about our e-books, e-learning products, CDs, and hardcopy books, visit the SAS Publishing Web site at support.sas.com/pubs or call 1-800-727-3228. SAS and all other SAS Institute Inc. product or service...

Words: 70608 - Pages: 283

Premium Essay

Press Release

...Memorandum To: Head of Financial and Internal Control From: Group Learning Team A Date: 10/13/2014 Re: Challenges Communicating Accounting Changes The issuance of SAS No. 112 in 2006 and SAS No. 115 in 2009 by the AICPA created the need to communicate significant audit procedure changes to our clients, as well as to our own firm accountants. SAS No. 115 supersedes SAS No. 112. Due to SAS No. 115, significant changes need to take place in order to comply with the new accounting principles. Specifically, internal company controls have become a major focus of the standard audit procedures. Each of the three groups experienced certain challenges regarding the requirements of the new directive. Specifically: 1- Firm Accountants - The new audit requirements has compelled our audit staff to redesign our traditional procedures on issues outside the financial statements. Our staff maintains a high competency regarding the financial statements themselves, but the requirement to review company financial controls and procedures has significantly changes and requires us to reinforce our staff training as many of the younger staff are confused. The younger staff has little experience with how companies run operationally, and they are now being required to judge the quality of these operations. A series of training regarding best practice financial controls is recommended to bolster the staff's ability to complete the audits per the new directive. 2- Clients - The new...

Words: 442 - Pages: 2

Premium Essay

Gaas

...Generally Accepted Auditing Standards 43 AU Section 150 Generally Accepted Auditing Standards (Supersedes SAS No. 1, section 150.) Source: SAS No. 95; SAS No. 98; SAS No. 102; SAS No. 105; SAS No. 113. Effective for audits of financial statements for periods beginning on or after December 15, 2001, unless otherwise indicated. .01 An independent auditor plans, conducts, and reports the results of an audit in accordance with generally accepted auditing standards. Auditing standards provide a measure of audit quality and the objectives to be achieved in an audit. Auditing procedures differ from auditing standards. Auditing procedures are acts that the auditor performs during the course of an audit to comply with auditing standards. Auditing Standards .02 The general, field work, and reporting standards (the 10 standards) approved and adopted by the membership of the AICPA, as amended by the AICPA Auditing Standards Board (ASB), are as follows: General Standards 1. The auditor must have adequate technical training and proficiency to perform the audit. 2. 3. The auditor must maintain independence in mental attitude in all matters relating to the audit. The auditor must exercise due professional care in the performance of the audit and the preparation of the report. Standards of Field Work 1. The auditor must adequately plan the work and must properly supervise any assistants. 2. The auditor must obtain a sufficient understanding of the entity and its environment, including...

Words: 1607 - Pages: 7

Free Essay

Project 1

... |1501 W. Shure Dr. | | | |Arlington Heights IL 60004 | | | | | | |Re: |IEEE 802.16 Working Group Letter Ballot Recirc #26a | |Abstract |This contribution identifies several problems with the currently existing procedures...

Words: 4252 - Pages: 18

Premium Essay

Audit Assignmenr

... There are different audits available for the processes at Kudler Fine Foods; including attestation, findings and recommendations, SAS 70, and SAS 94. The auditor will need to decide which audit is most appropriate for the Accounting Information System and the Retail Enterprise Management System incorporated into Kudler’s Systems. During an attestation audit, the auditor will provide assurance for a specified topic or issue for which the client is responsible. An assertion is made based on specified criteria, and the results are provided in a report. The findings and recommendations audit is used when, “implementing systems, security review, database application review, IT infrastructure and improvements needed engagement, project management, and IT internal audit services” (Hunton, Bryant, & Bagranoff, 2004, p. 217). This type of report does not include the auditor’s opinion, but any information pertaining to the work performed is included. The SAS 70 audit includes information pertaining to a company’s internal controls and is used when services, such as payroll are outsourced to an ADP. An ADP provides payroll services to companies at a lower rate than it would cost if the company were to handle this in-house. An SAS 70 audit is used when companies want to assure that they have implemented the appropriate internal controls. The SAS 94 audit is the most widely used audit and can involve one or all of the six steps involved when conducting this type of report. “The...

Words: 968 - Pages: 4

Premium Essay

Audi Risk Model

...errors ... clientcontrolled   Detection Risk (DRI_ risk that auditor's procedures will fail to detect errors ... auditorcontrolled   AR IR * CR * OR   Audit risk = inherent risk * control risk * detection risk   Audit risk: always set priority at a low level (.0 1, 05, 10)   Inherent risk: controlled by client ... function of type of business, degree of liquidity, complexity   Control risk: controlled by client ... relates to effectiveness of client's control system in preventing, detecting, and correcting errors.   Detection risk: controlled by auditor ... function of nature, timing, and extent of audit procedures applied ... allowable or acceptable   Solution Set:   (1) Detection risk = audit risk / (inherent risk * control risk) (2) Detection risk low ... the more evidence you have to collect (3) Detection risk high ... the less evidence you have to collect   Audit Risk: risk that auditor issues unqualified opinion when statements are materially misstated, audit risk and detection risk exactly related. IR/CR and detection risk inversely related.   Mgmt Assertions: (1) existence or occurrence (2) completeness (3) rights and obligations (4) valuation (5) presentation and disclosure *auditor's judgment about risks are based on assertions *assertions translated to account balances, then create audit objectives and procedures   Inherent Risk Factors: (1) nature of activities...

Words: 436 - Pages: 2

Premium Essay

Practice

...these values. Choose your own variable names. Be sure that the value for Gender is stored in 1 byte and that the four test scores are numeric. b. Include an assignment statement computing the average of the four test scores. c. Write the appropriate PROC PRINT statements to list the contents of this data set. 2. You are given a CSV file called political.csv containing state, political party, and age. a. Write a SAS program to create a temporary SAS data set called Vote. Use the variable names State, Party, and Age. Age should be stored as a numeric variable; State and Party should be stored as character variables. b. Include a procedure to list the observations in this data set. c. Include a procedure to compute frequencies for Party. 3. You are given a text file where dollar signs were used as delimiters. To indicate missing values, two dollars signs were entered. Values in this file represent last name, employee number, and annual salary. d. Using this data file as input, create a temporary SAS data set called Company with the variables LastName (character), EmpNo (character), and Salary (numeric). e. Write the appropriate PROC PRINT statements to list the contents of this data set. 4. Repeat Problem 2 using a FILENAME statement to create a fileref instead of using the file name on the INFILE statements. 5. You want to create a test data set that uses a DATALINES statement to read in values for X and Y. ...

Words: 841 - Pages: 4

Premium Essay

A Game

...characteristics, different company’s capabilities and resources, and changing economic environment. However, in achieving a successful strategy-executing process, every organization must complete 10 basic managerial tasks in term of staffing, resources and competencies, organizational structure, resource allocation, procedures and policies, practices improvement, information and operating system, incentives, corporate culture and leadership. How well the firm completes these tasks determines the success of the strategy, which is presented in form of strategic and financial objective accomplishment, employees and customer satisfaction as well as other stakeholders’ interest. Therefore, in order to evaluate and grade the strategy execution process of Southwest Airlines, we will analyze the extent to which the firm fulfills the tasks needed. The comprehensive analysis is covered in the following part of the paper. 1. Staff the organization with managers and employees capable of executing the strategy well. (1 point) We will break the issue into two facets including management team building and employees recruiting, hiring and training. In term of management, Southwest Airlines (SA) seems to have a strong competitive advantage over its rivals. It means that it possesses a truly strong and excellent management team with the leadership of prominent CEOs and COOs including Herb Kelleher (CEO, 1981-2001), James Parker (CEO, 2001-2004), Colleen Barrett (CFO, 2001-2008) and Gary C.Kelly (CEO...

Words: 2536 - Pages: 11

Premium Essay

Apple Computer

...audit programs. Course Objectives After completion of this course, students are expected to be able to: 1. Understand why there is a demand for auditing and assurance services 2. Differentiate between auditing and accounting 3. Understand the relationship among auditing, attestation, and assurance services 4. Know the different types of auditors and their types of services 5. Understand the issues currently affecting the profession 6. Understand generally accepted auditing standard and their relationship to standard auditing 7. Understand the relationship among financial statements, management assertions, and audit objective 8. Demonstrate to develop audit procedures to achieve audit objectives 9. Apply various sampling methods in audit procedures 10. Learn the major phases of the...

Words: 1730 - Pages: 7

Premium Essay

Whwifhwie

...A Handbook of Statistical Analyses using SAS SECOND EDITION Geoff Der Statistician MRC Social and Public Health Sciences Unit University of Glasgow Glasgow, Scotland and Brian S. Everitt Professor of Statistics in Behavioural Science Institute of Psychiatry University of London London, U.K. CHAPMAN & HALL/CRC Boca Raton London New York Washington, D.C. Library of Congress Cataloging-in-Publication Data Catalog record is available from the Library of Congress This book contains information obtained from authentic and highly regarded sources. Reprinted material is quoted with permission, and sources are indicated. A wide variety of references are listed. Reasonable efforts have been made to publish reliable data and information, but the author and the publisher cannot assume responsibility for the validity of all materials or for the consequences of their use. Neither this book nor any part may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, microfilming, and recording, or by any information storage or retrieval system, without prior permission in writing from the publisher. The consent of CRC Press LLC does not extend to copying for general distribution, for promotion, for creating new works, or for resale. Specific permission must be obtained in writing from CRC Press LLC for such copying. Direct all inquiries to CRC Press LLC, 2000 N.W. Corporate Blvd., Boca Raton, Florida 33431. Trademark Notice:...

Words: 38316 - Pages: 154