Sas 4

In: Computers and Technology

Submitted By comilaron
Words 4761
Pages 20
Chapter 6 Reading Excel Worksheets
0.1 0.2 Introduction.............................................................................. Error! Bookmark not defined. A Section Title .......................................................................... Error! Bookmark not defined.
Demonstration: .............................. Error! Bookmark not defined. Exercises .................................................................................. Error! Bookmark not defined.

0.3 0.4

Chapter Summary ................................................................... Error! Bookmark not defined. Solutions .................................................................................. Error! Bookmark 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…...

Similar Documents

Sa Sa

...search-advertising sales on its site for the first five years and sell advertisement on some of the Microsoft’s websites under the deal. * The deal enables Yahoo to boost its income from operations by US$500 million annually and realize US$200 million in savings. * Yahoo’s dip in net income could be eased. * Bing (a new search engine by Microsoft and was positioned as a credible alternative to Google Search) would be roll out globally to Yahoo’s websites which would assuredly benefit users. | * Alibaba thought the agreement resulted in Yahoo’s loss of its own search engine technology. * David Wei thought Microsoft was a financial investor with no business synergy and technologyHence, Alibaba regard the agreement as perplexing. | 4. Yahoo sold its entire direct shareholding of Alibaba (1.14%) for US$147 million a week after Ma selling less than 5% of his holdings in Alibaba.com for US$34 billion in 2009 | * Alibaba.com’s share price recovered rapidly in 2009. * The value of Yahoo’s shareholding of Alibaba increased substantially. | * Yahoo informed Alibaba of its action through a low-level executive at Alibaba’s anniversary celebration. * Alibaba was informed by Yahoo about its act only a week before. * The transaction sparked a 10.5% decrease in Alibaba.com’s share price that day and more than 100 million shares were traded as compared to an average daily volume of 16 million over the previous 30 days. | 5. Yahoo issued a company......

Words: 3363 - Pages: 14

Sas-Project

...SAS also known as “Statistical Analysis System” institute was founded in 1976. It all started at North Carolina State University (NCSU) as a project to analyze agricultural research, but the need for statistical analysis skyrocketed and thus SAS was founded. Two NCSU faculty members headed the project, Jim Goodnight and Jim Barr each one playing a major role in the development of SAS. With the help of Jane Helwig, a documentation writer, and John Sall, a computer programmer, the SAS core team was formed. These four people are given credit for co-founding the company. The company had their first user conference in 1976 to determine if the company could stand independently. They had more than 300 people attend this conference. With their customer clientele already growing and reaching nearly 100, they were sure that this company could be a success. Late in 1976, the co-founders left NCSU and formed the company in an office building across from the University. In 1976, they had small rooms filled with computers lined wall to wall. Base SAS, the first program created by the company, was stored on a punch card consisting of 300,000 lines of code. By 1977, SAS was awarded the first outstanding software recognition award and was placed on the Data pro Software honor roll. By 1978, SAS had 21 employees and over 600 customer sites. In 1976, SAS’s main concern was the customer; therefore, they issued a survey called the SASware Ballot, which still exists today. With this ballot......

Words: 283 - Pages: 2

Sas 112

...MEMORANDUM TO: Accounting Staff FROM: Junior Accountant DATE: September 23, 2013 SUBJECT: Replacement of SAS 112 with SAS 115 The American Institute of CPAs (AICPA) Statement on Auditing Standards (SAS) Number 115 supersedes SAS Number 112. Going forward, auditors are to use rule SAS 115 when performing internal control audits. The rules have some similarities. However, the key differences in the rules are the definitions for control deficiency, significant deficiency, and material weaknesses. The change in rules also creates more opportunities for accounting firms to offer services. Similarities between SAS 112 and SAS 115: Similarities exist between SAS 115 and SAS 112. The rules require auditors to look at deficiencies found during an audit. The auditor must continue to identify the deficiencies found as significant deficiencies or material weaknesses.1 SAS 112 and SAS 115 require auditors to determine if internal controls can prevent and detect errors. Management receives written communication of the findings, as before. Both rules require management to become more aware of the weaknesses in the organizational internal controls. The differences in rules SAS 112 and SAS 115 are as significant as the similarities. Differences between SAS 112 and SAS 115: The differences between SAS 112 and SAS 115 are subtle but important. The major difference between the two rules is the definition of control deficiency, significant deficiency, and material......

Words: 1974 - Pages: 8

Sas Airlines

...Table of Contents I. | Project Question | Page 3 | II. | Description of Variables | Page 3 | III. | Procedure | Page 4 | IV. | Results | Page 6 | V. | Additional Results | Page 7 | VI. | Business Implications | Page 10 | VII. | Project Implications | Page 10 | VIII. | References | Page 12 | IX. | Appendix | Page 12 | I. Project Question For our data analysis, our group decided to gather information pertaining to airlines and the different factors that go into calculating their revenue. To support our conclusions, we collected and evaluated 1,283 observations across 30 airlines, over a 12-year period beginning in 2000. We used this information to analyze the effects of a variety of independent variables on our dependent variable of revenue (both domestic and international). The independent variables we examined included number of flights, baggage fee revenue, fuel costs, amount of fuel consumption, and the dollar amount spent on advertising. These variables were divided into both domestic and international amounts. To complement our findings and evaluate data on a more disaggregated level, we separated the airlines into major and minor airlines. We placed all of the data we collected into Excel and then imputed all of the Excel information into SAS in order to run our analysis. II. Description of Variables All of the variables we analyzed, except for advertising spending, were found utilizing the RITA database provided by the Department of......

Words: 3762 - Pages: 16

Sas 112

...SAS 112 and SAS 115 Explanation to Key Clients Tara Stanley, Kenya Irving and Cynthia Etzel COM/530 Communications for Accountants August 25, 2014 Gloria Davis MEMORANDUM TO: Clients of ACE Accounting FROM: Kim Jones, Junior Accountant DATE: August 25, 2014 SUBJECT: Statement of Accounting Standards SAS 112 and SAS 115 Auditing Changes In response to the recent changes to the auditing processes, our company felt the need to clarify the changes and how they will affect your company. The SAS 112 and SAS 115 enforce changes to the auditing process for private companies, governments and non-profit organizations. These changes bring the audit process in line with current processes already in place for publicly held companies. The changes went into effect for audits of financial statements ending on or after December 15, 2006 and December 15, 2009 respectively. The significant changes apply to the definitions of internal control deficiencies, significant deficiencies and material weaknesses. The SAS 112 defines internal control deficiencies as “a design or operation of a control that does not allow management or employees to prevent or detect misstatements on a timely basis” (American Institute of CPAs, 2006). The SAS 115 further defines internal control deficiencies by adding the word correct to the definition. Under the SAS 112, auditors are required to note whether or not the internal controls could detect and prevent errors. ......

Words: 466 - Pages: 2

Sa-Sa

...Sa-Sa has several methods to segment their customers. The primary method is to classify customers as tourists or residents. Customers can fall into a third category of Mainland residents after the join-venture with Ebeca. With no tariffs on beauty products in Hong Kong, tourists are a major customer base for the perfume and cosmetics industry. The largest chunk of tourists come from mainland China, followed by Taiwan and then by South East Asia. The customers prefer imported products from Europe, USA and Japan as the products reflect quality and prestige. The customers can then be further profiled by their demographics and buying behavior. The three customer segments are Real Spenders, Best Overall Value Seekers, and Convenience seekers. The real spenders are in their 20s and 30s and are high-income earning professionals, managers or business owners. They spend the highest on skincare products, cosmetics, and fragrances/health supplements. They don’t spend as much on hair care products as they might be going to professional stylists and getting their products from the salon. This segment has the highest number of purchases at Sa-Sa. They might be ones more likely to buy the in-house products leading to greater profit margins for Sa-Sa. One way Sa-Sa can compete is to sell more luxury products to the real spender segment and generate higher profits. Convenience seekers are usually above 40 years of age and include housewives, blue-collar and part-time workers. They have......

Words: 846 - Pages: 4

Sas Insitute

...Erica Graham 1  Erica Graham   Prof. Poznanska  International Business  Final Paper  3/6/2015    Introduction:      SAS Institute Inc is by far the world largest private software company. It is known for  two things, it was the first company to make software for analyzing data, and how it treats its  employees. “SAS Institute is probably the most important software company that you’ve never  heard of.” (Fishmen) Yet a majority of the people in the United States and overseas uses SAS  technology every day without knowing where and how it came into being. SAS is considered to  be the sanest company in America, with the lowest turnover rates for employees across the  world. “The company experiences annual turnover in the range of 2­3% compared to an industry  average of 22%.” (Crowley)   This is due to the way that SAS operates, putting its workers and their job satisfaction  above everything else.  SAS institute is also one of the very few companies to take a  sustainability approach to business, one in which it holds the value of people above all else.  “SAS has found that by being an especially benevolent and respected organization, they  consistently produce the most optimal workplace performance.” (Crowley)   Reason for International Expansion:  Erica Graham 2  In 1966 there was no company called SAS, but the foundation for this fast growing  multinational company was laid. In 1966 the need for computerized statistics programs was ......

Words: 1761 - Pages: 8

Sas 99

...SAS 99 AND ITS CHALLENGES TO THE ACCOUNTING PROFESSION Submitted by: Ronneil I. Capones Consideration of Fraud in a Financial Statement Audit, also known as Statement on Auditing Standard 99 was issued in November 2002. It is a revision to improve the deficiencies of SAS 82 with regards to audit process and quality (Marczewski and Akers, 2005, p. 38). The revision of SAS 82 was started prior to the huge accounting scandals that shook public confidence in the reliability of audits. Nevertheless, it gave the accounting profession more focus on tackling the issues of fraud detection on audits Three key fraud risk factors are classified and described in SAS 99; incentive/pressure to perpetrate fraud, opportunity to carry out the fraud, and attitude/ability to rationalize the fraudulent action. Incentives or pressure to perpetrate fraud may arise from the threat of losing profitability as a result of failures in the industry, declining product demand, frequent negative cash flows from operations, threat of losing job because of pressure from management to meet analysts’ expectations are a few examples (Casabona and Grego, 2003, p. 17). Opportunities to carry out fraud are characterized by the following conditions; abundance of transactions with related parties not within the normal course of business, unusual complex transactions coupled with subjective judgments, ineffective monitoring by management, board of directors, and audit committee (Casabona and Grego, 2003, p.17)...

Words: 687 - Pages: 3

Banghay Aralain Sa Edukasyon Sa Pagpapakatao

...Ayala, Nikkochea A. BEED-II-A Principles and Methods of Teaching Banghay Aralin sa Edukasyon sa PAgpapakatao I. LAYUNIN Nakikilala na ang sarili ay natatangi at naiiba sa ibang mga bata. Pinahahalagahan at nabibigyang pansin ang sariling katangian. Naibabahagi sa iba ang sariling kakayahan at talento na maaaring ipagmalaki. II. PAKSANG-ARALIN A. Paksa: Ako ay Natatangi B. Sanggunian: Curriculum Guide in Edukasyon sa Pagpapakatao Grade I C. Kagamitan: Larawan, Actuvuty Sheet III. PAMAMARAAN GAWAING GURO | GAWAING BATA | A. Panimulang Gawain | | Pag-awit ng may kilos ng “Kung Ikaw ay Masaya” | Kung ikaw ay masaya pumalakpak ka Kung ikaw ay masaya pumalakpak ka Kung ikaw ay masaya, buhay mo ay sisigla Kung ikaw ay masaya pumalakpak ka | | | 1. Balik-aral: | | | | Sino ang nakakaalala ng napag-aralan natin kahapon at bakit ito ay mahalaga? | -Ang napag-aralan po natin kahapon ay gawaing makabubuti sa ating kalusugan at mahalaga poi to upang maging malakas at malusog po an gating katawan. | Magaling, bigyan natin siya ng “YES” klap. | -1,2,31,2,3 | | | 2. Pagganyak | | | | Magbigay ng halimbawa ng nais o gusto ninyong mangyari o gawin sa araw ng walng pasok sa paaralan. | MaglaroMagsayawKumantaMagbasa | | | B. Panlinang na Gawain | | 1. Paglalahad: | | Pumili ng isang bata na maaaring......

Words: 741 - Pages: 3

Procedure in Sas

...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......

Words: 3610 - Pages: 15

Strategy Sas

...Alexander Kanani Roland Kassemeier Petteri Kivelä Lennart Kuhrt Francesco Licitra Supervisor: Björn Trägårdh 2 Table of Contents 1. Introduction ........................................................................................................................................ 3 2. Conceptual overview .......................................................................................................................... 3 3. Methodology ....................................................................................................................................... 3 4. Findings ............................................................................................................................................... 4 4.1 Who are we? ................................................................................................................................. 4 4.2. Upframing .................................................................................................................................... 5 4.2.1 Value Constellation ................................................................................................................ 5 4.2.2 Alternative value constellations............................................................................................. 5 4.2.3 Competitors ........................................................................................................................... 6 4.2.4......

Words: 5586 - Pages: 23

Sas Hr

...SAS * Employment security The company culture and working environment lend itself to a warm friendly place to work. Along with this the corporate strategy of making software that customers want ensures that new products are in line with consumer needs. These things create a very stable work environment where people enjoy coming to work. SAS experiences only a 4% turnover rate a year far lower than the industry average due to the work environment they create. This atmosphere allows for a great deal of security and makes employees enjoy coming to work and as a result their work is higher quality. * Selective hiring The hiring practices at SAS are a major reason for its success. SAS goes about recruiting people based a great deal on how they fit within the corporate culture. Due to the fact that the company headquarters is located in the south much of the recruiting is targeted at people who want to live in the south. Along with this the turnover rate for the company is extremely low because the employees like working for the company. This selection process allows SAS to get skilled employees that enjoy their work environment and don’t want to work somewhere else. * Self managed teams When it comes to management strategy SAS has a simplistic approach built on trust and responsibility. The company follows a motto of “give people the tools they need to do their job and get out of the way.”The training of employees allows the company to mentor and coach employees......

Words: 641 - Pages: 3

A Hospitality Event for Sa Sa Anniversary Dinner

...Hospitality Event for Sa Sa Anniversary Dinner Emily Yiu Executive Summary Sa Sa International Holdings Limited ("Sa Sa") is a leading cosmetics retailing group in Asia since 1978. Being one of the largest sole agents in cosmetics in Hong Kong, Sa Sa represents over 100 international beauty brands in Asia. The business includes Hong Kong & Macau, Mainland China, Singapore, Malaysia and Taiwan Region. This year is the 35th anniversary of Sa Sa International. We are going to hold a spectacular gala event on 28th April at The Mira Hong Kong. The name of the party is “Manifest Beauty of Life” highlighted the mission of Sa Sa to help people to make their life beautiful. As the biggest sole agents in cosmetics in Hong Kong, we must attach importance to the anniversary dinner. We wish we can bring a hospitality experience through our anniversary to gratitude our honorable guests. Background and Situation Analysis The grand gala party will be held on 28th April at the ballroom of the Mira Hong Kong. The party will have a cocktail time start at 6:30p.m and the dinner will start at 8p.pm. It will attend around 600 people and they are our business partner representatives, key account and agents, some senior employees and a number of most important customers. All the attendees are our distinguished guest. So we wish we can share our happiness to them make them to have a memorable night. Moreover, we would to invite the ambassador of Sa Sa, Kate......

Words: 2689 - Pages: 11

Sa Lines

...Submitted by: Jiyeon | CT00000000 | TABLE OF CONTENTS 1. INTRODUCTION 2 2. COMPANY BACKGROUND 3 3. PESTEL ANALYSIS 4 3.1 Political 4 3.2 Economic 4 3.3 Social 5 3.4 Technological 5 3.5 Environment 5 3.6 Legal 6 4. PORTER’S FIVE FORCES ANALYSIS 7 4.1 Threat of New Entry 7 4.2 Threat of Substitution 7 4.3 Buyer Power 7 4.4 Supplier Power 8 4.5 Competitive Rivalry 9 5. STRATEGIC RECOMMENDATIONS 10 5.1 Managing Technology Advancements 10 5.2 Maintain Cost Advantage 10 5.3 Geographical Expansion 10 5.4 Product Diversification 11 6. CONCLUSION 12 7. REFERENCES 14 1. INTRODUCTION The focus company in this report is Southwest Airlines (SA), a major low cost carrier in the United States (US). The aim of this report is to examine the current market environment and competitive power of Southwest Airlines. In order to have a substantial overview of its environment, two analyses, the PESTEL analysis and Porter’s Five Forces analysis, will be used to evaluate SA. With the findings, strategic recommendations will be made for the problems that the airline is facing or may encounter in the near future. 2. COMPANY BACKGROUND Southwest Airlines is a budget airline established in 1967 by Rollin King and Herb Kelleher and had its first flight in 1971. Headquartered in Dallas, Texas, SA is an important airline in the US. Today, in its 44th year of passenger service, Southwest Airlines has become the biggest low......

Words: 3086 - Pages: 13

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......

Words: 7726 - Pages: 31