Premium Essay

Sas 4

In:

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

Free Essay

On Line Social Sites

...respondents, 65 or 59 % are female and 45 or 41 % are male. They were at average age of 17.5 in female and 17.23 in male. On frequency of respondents in favorite SNS, number of hours usage, moments spend using SNS, priority of reasons in using SNS and number of friends on line, the respondents’ mean favorite site used is 93 respondents preferred Facebook as networking site, followed by 69 or 62 % who prefers other sites, 65 or 59 % prefers Youtube, 46 or 41 % prefer Twitter, while 44 or 40 % prefer Yahoo messenger. Out of 110 , there are 46 or 42 % who spend time with SNS in 30 to 1 hour, 44 or 44 % spent 2 to 3 hrs, while 13 or 11 % used 4 to 5 hrs, and only 7 or 6 % devoted 5 hours or more. In moments used in SNS, Out of 110 respondents , there are 16 or 14 % use SNS in vacant period, while only 2 or 2 %% do it during class, 4 or 3.6 % do SNS in before class and 88 or 80 % use SNS after their class. Out 110, there were different reasons why they use SNS, such as bumming around which ranked 1 , 84 or 76 % , 75 or 64 % ranked studying as 2, 73 or 63 % meet new friends on SNS, and 42 or 38 % both for UpdaIng with family and friends. Out of 110, there are 10 or 9 % who have 10 to 100 friends on line , 16 or 14.5 % have 101 to 200 friends,...

Words: 790 - Pages: 4

Free Essay

Acct 504 Case Study 2

...improvement and future success of this company moving into the public market. In order to properly perform an assessment of the LBJ Company, there first had to be some set of standards or regulations that outline the internal controls and proper procedures for companies and businesses to adhere to for financial reporting. As it turns out internal control is a key component of Foreign Corrupt Practices Act(FCPA) of 1977 and the Sarbanes-Oxley Act(SOX) of 2002 which required companies to follow this set of internal controls. This list of internal controls is as follows: 1). Conduct its business in an orderly and efficient manner, 2). Safeguard its assets and resources, 3). Deter and defect errors, theft, and fraud, 4). Ensure accuracy and completeness of accounting data, 5). Produce reliable and timely financial and management information, 6). Ensure adherence to its policies and plans.(O’Malley) From this point on all senior management officials will be held responsible for enforcing and ensuring that their company follows these regulations and...

Words: 939 - Pages: 4

Premium Essay

In Basket

...such as someone’s vacation hours and stocking merchandise for the store, those tasks should be delegated out to the assistant manager and to the store clerks. Being a supervisor means being in a role of leadership, logic, common sense, and decision making for yourself, the employees, and for the company. The “in Basket” debate and discussion gives us and our fellow classmates the opportunity to see if we can successfully delegate out certain tasks as a supervisor at a fictitious company. The discussion between me and fellow classmates was a great one and it appeared as though everyone agreed on everything accept for different incidents. The only two incidents where I came across disagreement were in regards to task number 3, and task number 4. These are the examples in which I will be using in this paper as far as disagreeing is concerned. Task number 3 is in regards to the mall hours changing for an upcoming holiday and that there is a request for store plans. In my own opinion and the opinion of all of my fellow classmates accept for one that I could find agreed that this task needed to be done by the Supervisor. The disagreeing student felt that it should be delegated to the Assistant Manager. This task should be done by the supervisor because it is not only a very important one...

Words: 848 - Pages: 4

Free Essay

12 Angry Men

...Corridors of Transition between 12 Angry Men and 12 “I have always found that mercy bears richer fruits than strict justice”. Abraham Lincoln “The virtue of justice consists in moderation, as regulated by wisdom”. Aristotle ”Nobody gets justice. People only get good luck or bad luck”. Orson Welles Justice = mid-12c., "the exercise of authority in vindication of right by assigning reward or punishment;" also "quality of being fair and just," from Old French justice "justice, legal rights, jurisdiction" (11c.), from Latin iustitia "righteousness, equity," from iustus "upright, just" . The Old French word had widespread senses, including "uprightness, equity, vindication of right, court of justice, judge." The word began to be used in English c.1200 as a title for a judicial officer. Meaning "right order, equity" is late 14c. Justice of the peace first attested early 14c. In the Mercian hymns, Latin iustitia is glossed by Old English rehtwisnisse. To do justice to (someone or something) "render fully and fairly showing due appreciation" is from 1670s. This word, with such a strong connotation, influenced and formed the basis of many philosophical...

Words: 5039 - Pages: 21

Free Essay

Nt1210 Unit 1 Lab 1.1

...1____ | 0____ | | 4+ | 2 + | 0 = | 6 | 1.1.3 21↓ | 20↓ | | 2X | 1X | | 1____ | 1____ | | 2 + | 1 = | 3 | 1.1.4 24↓ | 23↓ | 22↓ | 21↓ | 20↓ | | 16X | 8X | 4X | 2X | 1X | | 1____ | 0____ | 0____ | 1____ | 0____ | | 16 + | 0 + | 0 + | 2 + | 0 = | 18 | 1.1.5 27↓ | 26↓ | 25↓ | 24↓ | 23↓ | 22↓ | 21↓ | 20↓ | | 128X | 64X | 32X | 16X | 8X | 4X | 2X | 1X | | 1____ | 1____ | 1____ | 0____ | 0____ | 0____ | 1____ | 0____ | | 128 + | 64 + | 32 + | 0 + | 0 + | 0 + | 2 + | 0 = | 226 | 1.1.6 156 | 28 | 28 | 28 | 12 | 4 | 0 | 0 | | 27↓ | 26↓ | 25↓ | 24↓ | 23↓ | 22↓ | 21↓ | 20↓ | | v | v | v | v | v | v | v | v | | 128x | 64x | 32x | 16x | 8x | 4x | 2x | 1x | | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 = | 10011100 | 128 + | 0 + | 0 + | 16 + | 8 + | 4 + | 0 + | 0 = | 156 | 1.1.7 255 | 127 | 63 | 31 | 15 | 7 | 3 | 1 | | 27↓ | 26↓ | 25↓ | 24↓ | 23↓ | 22↓ | 21↓ | 20↓ | | v | v | v | v | v | v | v | v | | 128x | 64x | 32x | 16x | 8x | 4x | 2x | 1x | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 11111111 | 128 + | 64 + | 21 + | 16 + | 8 + | 4 + | 2 + | 1 = | 255 | 1.1.8 200 | 72 | 8 | 8 | 8 | 0 | 0 | 0 | | 27↓ | 26↓ | 25↓ | 24↓ | 23↓ | 22↓ | 21↓ | 20↓ | | v | v | v | v | v | v | v | v | | 128x | 64x | 32x | 16x | 8x | 4x | 2x | 1x | | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 11001001 | 128 + | 64 + | 0 + | 0 + | 8 + | 0 + | 0 + | 1 = | 255 | 1.1.10 | 2^7 | 2^6 | 2^5 | 2^4 | 2^3 | 2^2 | 2^1 |...

Words: 552 - Pages: 3

Premium Essay

Profile of Working Students and It' S Implication on Academic Standing

...CHAPTER I INTRODUCTION Not all people are given the chance to have a quality education especially in the Philippines because it is now complicated. That’s why having the chance to study and choosing the course should not be compared to some thing like for an example buying a dress for a special occasion and when realization comes into your mind that you don’t want it, you’ll return it or maybe get your money back. No, this isn’t right, because in college life, you have to treat every second as an important detail of your life. You should not waste every moment in it. So choosing the course which you think fits your capabilities is very important. Studying a specific course in college is not only about paying the fees rather the most important things here are the time and effort spent. Money, time and effort are the most precious things in one’s life and once it is used or spent, it’s hard to gain again or worst you may never have it at all. So the time these are wasted for nothing, for sure the blame for this mistake will be felt truly. When looking at the profile of those students who are working and at the same time is studying, you would notice that they never dare wasting their time. For them, every second counts. Make an observation and you will find out that almost all of the working students are working too hard to finish their studies. For them, wasting their effort, time and money is such a big mistake. OBJECTIVES OF THE STUDY The objective of studying...

Words: 4091 - Pages: 17

Free Essay

Nt1210 Lab

...| 1 | Exercise 1.1.2 The mapping of 1102 will have 1, 1, and 0 in the lower bit values and 4, 2, and 0 in the bottom bits, for a sum of 6. 1 | 1 | 0 | 4 | 2 | 0 | Exercise1.1.3 The mapping of 112 will have a leading 0 to fit the mapping, which does not affect the results. The lower bits will have leading 0s and then 1 and 1 in the rightmost bits. This results in all 0s at the bottom, with 2 and 1 in the rightmost bits, for a sum of 3. 0 | 0 | 1 | 1 | 0 | 0 | 2 | 1 | Exercise 1.1.4 The placeholder 24 = 16 is necessary for this mapping because it is five digits. The result is 16 + 2 = 18 16 | 8 | 4 | 2 | 1 | 1 | 0 |...

Words: 349 - Pages: 2

Free Essay

Jan Carlzon

...Harvard Business School 8-489-046 Rev. May 31, 2001 Jan Carlzon In June 1974, at the age of 32, I sat down behind the desk in the president’s office of Vingresor, a subsidiary of the Scandinavian Airlines System that assembles and sells vacation package tours. I’d been selected president after only six years of working life. I had authority over 1,400 employees, many of them roughly the same age as I. My qualifications were no better than anyone else’s, and there was no obvious reason for making me president. I was afraid—afraid that I wouldn’t be accepted and afraid that I would fail. I had taken over at Vingresor during troubled times. The 1973-1974 oil crisis had escalated air travel prices so much that passengers shied away from charter trips. It was our job to make Vingresor profitable again. We didn’t have many options. The main functions of a tour operator like Vingresor are to contract for flights and hotels and set up a service section at the travel resort that organizes excursions and activities. Then all these pieces are packaged together for the customer to purchase. The operator’s profit is to a great extent a question of cost: the more money invested throughout the various stages of assembling the package, the smaller the profit margin and the greater the chances of losing money. The less invested, the less the risk. In a sagging market, most product-oriented executives would have cut back on service. But this would only bring in less revenue, creating an...

Words: 15635 - Pages: 63

Premium Essay

Sas Company Ltd

...Case about SAS institute ins. 1. One critic calls SAS "a big brother approach to managing people." Is the company too paternalistic? Can a company be too paternalistic? I do believe that SAS's approach to managing people is the result of an accurate analysis performed by the management staff. Therefore, when the management discusses improving employee retention rates, the initial topic is often higher salaries and bonuses. That is partly valid, because money is a key element; as SAS can attest, retention efforts can be very effective if they focus on more ways to spend the money than just increasing salary levels. With its strategy to boost employee retention, the company has created a culture and programs that encourage and drive employee loyalty. According to Pfeffer (2001), "Your profits come from loyal customers who do business with you for reasons other than just price. Customer loyalty is a consequence of loyalty from employees who produce great products and offer great service. In the short run, with enough venture money and enough product demand, any business model may appear feasible. In the long run, those companies that actually run their businesses efficiently and produce sustainable results will be the ones you keep reading about." ( 18). I do not think that this is a "big brother approach" at all; at the end, it is just a way to achieve a better business result. The top management prefers to spend money on the employees rather than spending money on recruiters...

Words: 915 - Pages: 4

Free Essay

Appendix G

... |Salary Range in Dollars |Base Tax in Dollars |Percentage of Excess | |1 |0.00-1,499.99 |0.00 |15 % | |2 |1,500.00-2,999.99 |225.00 |16 % | |3 |3,000.00-4,999.99 |465.00 |18 % | |4 |5,000.00-7,999.99 |825.00 |20 % | |5 |8,000.00-14,999.99 |1425.00 |25 % | Ok number 3 if the excess is over $3,000.00 then that would be 16% of $236.00; therefore the total tax would be $236.00 +36.00 which would be $272.00 Number 4 if the excess is 5,000 then that would be 18% of $232.5; therefore the total tax would be $232.5 + 32.5, or $265.00. Number 5 if the excess is over 8,000 then that would be 25% of $570.00 therefore the total tax would be $570.00 + $120.00, or $690.00. Number 1 if the excess is $0.00 then that would be 15% of $0.00 therefore, the total tax would be $0.00 + $0.00 which would nothing $0.00 I understand but I am confused on the number and how to get the, I know this cannot be right but I am trying to follow procedure and hoe...

Words: 309 - Pages: 2

Free Essay

Guess Your Card

...explain to me that in this game each of us in turn will blindly draw three cards from a partial deck of cards. This deck has had all cards above 9 removed, and for this game’s purposes aces are only equal to 1. Without looking at my cards I am to place them facing out on my forehead so the other players can clearly see the cards. Each of the other players is to do the same. The object of the game is to guess which cards you have on your own head using logic to solve the problem. Players draw question cards that reveal information about player cards, and the first to guess their cards based on the information revealed wins the game. My brother Andy has the cards 1, 5, and 7 showing on his forehead. His wife Belle has 5, 4, and 7. My girlfriend Carol has the cards 2, 4, and 6. Andy is selected to draw the first question card, and it asks if he sees two or more players who’s cards sum to the same value. Andy answers affirmatively. With this information I know that I must have cards that equal either 12 or 16. I know this because Belle’s cards sum to 16 and Carol’s cards sum to 12. Since Andy sees two of us with cars of the same value I am able to confirm that my sum must match either Belle’s or Carol’s. At this point none of us are able to conclude anything else about our cards, so Belle draws the next question card. Belle’s question reads “Of the five odd numbers [1, 3, 5, 7, and 9] how many different odd numbers do you see?” Belle answers that she sees all five the odd numbers. I...

Words: 652 - Pages: 3

Free Essay

Hahaha

...6:48 pm - Prudence: Plz use English all the time thank you 3 Oct 6:51 pm - Prudence: IMG-20141003-WA0010.jpg (file attached) 3 Oct 6:51 pm - Prudence: First meeting 3 Oct 6:51 pm - Prudence: From 1800 to 1851 3 Oct 6:55 pm - Scope Luee: l 3 Oct 6:55 pm - Scope Luee: Sori we don't know !! 3 Oct 7:01 pm - Scope Amy: Okay 3 Oct 7:01 pm - Scope Amy: Oops 3 Oct 7:01 pm - Scope Amy: Sorry 3 Oct 7:03 pm - Prudence: Its okay 3 Oct 7:03 pm - Prudence: Next meeting: tomorrow after school 3 Oct 7:03 pm - Prudence: Do u guys ok? 3 Oct 7:10 pm - Scope Ray:  3 Oct 7:11 pm - Scope Michelle:  3 Oct 7:11 pm - Scope Jason:  3 Oct 8:19 pm - Scope Luee: Okok 3 Oct 8:19 pm - Scope Amy: 4 Oct 4:31 pm - Prudence: IMG-20141004-WA0035.jpg (file attached) 4 Oct 4:31 pm - Prudence: Second meeting 11 Oct 3:26 pm - Scope Michelle: IMG-20141011-WA0007.jpg (file attached) 11 Oct 9:23 pm - Scope Jason: 可唔可以sd番今日傾過既野嚟睇? 13 Oct 11:31 am - Scope Luee: IMG-20141016-WA0001.jpg (file attached) 13 Oct 11:31 am - Scope Luee: IMG-20141016-WA0000.jpg (file attached) 13 Oct 11:31 am - Scope Luee: Sori我唔知係我電話 13 Oct 11:32 am - Scope Jason: Thx 13 Oct 11:32 am - Prudence: Thx 13 Oct 11:40 am - Scope Ray: Thx 14 Oct 12:54 am - Scope Luee: 各位有無email 我fd有份pm嘅project借左黎參考 腥俾你地睇下 14 Oct 12:55 am - Scope Michelle:  chung1994abcd@yahoo.com.hk 唔該晒 14 Oct 1:00 am - Scope Ray: raylau512@gmail.com 14 Oct 1:01 am - Scope Luee: 仲有每個項目解釋大約一至兩句is ok 原來果一大段係成個project description ...

Words: 1232 - Pages: 5

Free Essay

Presentation of Data

...a Country/ State should strive for Globalization if they could afford it: All thirty- two (32) persons replied with – Yes No persons replied with – No Ways in which Technology can contribute to Sectors of Society | Quantitative Response of Persons | Transport | 0 | Agriculture | 0 | Health | 0 | Infrastructure | 0 | All | 30 | Agriculture, Health & Infrastructure | 1 | Health & Infrastructure | 1 | Impact of Technology Table 2. Showing the response of persons in terms of Ways in which Technology can contribute to Sectors of Society Fig 4. Showing the Responses to the Advantages of Globalization by persons Ways in which Globalization can be a Disadvantage | Quantitative Response of Persons | Corruption between countries | 19 | Increased Unemployment | 5 | Exploitation of a country’s Natural Resources | 4 | Decrease in Manual Labour | 2 | No Response | 2 | Disadvantages of Globalization Table 3. Showing...

Words: 809 - Pages: 4

Free Essay

Time Management

...Month | Asian Fund | R1 | Atlas Fund | R2 | KSE 100 | Rm | Jan06 | 4.5 | | 7.75 | | 6747 | | Feb06 | 4.95 | 0.1 | 7.75 | 0 | 8260 | 25.64407 | Mar06 | 7 | 0.414141 | 8.1 | 0.0451613 | 7770 | -8.30508 | Apr06 | 6 | -0.14286 | 8 | -0.012346 | 7105 | -11.2712 | May06 | 6 | 0 | 8.8 | 0.1 | 6858 | -4.18644 | Jun06 | 4.7 | -0.21667 | 9.2 | 0.0454545 | 7450 | 10.0339 | Jul06 | 5.8 | 0.234043 | 9.5 | 0.0326087 | 7179 | -4.59322 | Aug06 | 3.5 | -0.39655 | 7.45 | -0.215789 | 7797 | 10.47458 | Sep06 | 5 | 0.428571 | 8 | 0.0738255 | 8226 | 7.271186 | Oct06 | 5.4 | 0.08 | 8.25 | 0.03125 | 8247 | 0.355932 | Nov06 | 4.55 | -0.15741 | 9.1 | 0.1030303 | 9026 | 13.20339 | Dec06 | 6.5 | 0.428571 | 8.4 | -0.076923 | 9557 | 9 | Jan07 | 6 | -0.07692 | 9.1 | 0.0833333 | 10524 | 16.38983 | Feb07 | 5.75 | -0.04167 | 8.95 | -0.016484 | 11456 | 15.79661 | Mar07 | 6.15 | 0.069565 | 9.1 | 0.0167598 | 11486 | 0.508475 | Apr07 | 5.5 | -0.10569 | 9.2 | 0.010989 | 11342 | -2.44068 | May07 | 4.7 | -0.14545 | 8.5 | -0.076087 | 9801 | -26.1186 | Jun07 | 6.27 | 0.334043 | 8.91 | 0.0482353 | 9989 | 3.186441 | Jul07 | 6.27 | 0 | 7.5 | -0.158249 | 10498 | 8.627119 | Aug07 | 6.27 | 0 | 6.3 | -0.16 | 10064 | -7.35593 | Sep07 | 6.27 | 0 | 5.55 | -0.119048 | 10064 | 0 | Oct07 | 6.17 | -0.01595 | 6 | 0.0810811 | 11328 | 21.42373 | Nov07 | 6.17 | 0 | 6 | 0 | 10619 | -12.0169 | Dec07 | 6.17 | 0 | 5 | -0.166667 | 10040 | -9.81356 | Jan08 | 6.17 | 0 | 2.2 | -0.56 | 11272...

Words: 837 - Pages: 4

Free Essay

The Little Sas Book

...第一章 SAS 软件入门 1.1 SAS 语言 许多软件要么是菜单驱动,要么是命令驱动(输入命令——看结果) 。SAS 两者都不是,在 SAS 中,你用一个叫做 SAS 程序的一系列指令语句,这些程序可以表达出你想做的事情,并 用 SAS 语言写下来。SAS 有菜单驱动栏,比如 SAS 企业向导模块,它使 SAS 看起来像一个点 击的软件, 但这些模块仍然使用 SAS 语言为你写程序。 如果你试图用 SAS 写下你自己的程序, 那就要具备一定的灵活性。 SAS 程序 一个 SAS 程序就是一个按顺序执行的语句序列,一个语句给 SAS 下达信息和指 令, 且必须要正确的安放。 一个常用来与 SAS 程序做类比的例子是去银行取款, 你进入银行、 排队、轮到你,那么你会对柜台谁你想做的事,叙述语句可能会是这样: I would like to make a withdrawal. My account number is 0937. I would like$200. Give me five 20s and two 50s. 注意第一句话说了你想做的事情, 之后把相关信息传递给柜台并帮你完成要求。 这里信息传 递的顺序不重要,重要的是在你的叙述中,首先要说明你要做什么。你不能先说: “Give me five 20s and two 50s.”这会使柜台小姐一头雾水。此外,你必须确保后面的语句都围绕第一 句展开。 SAS 语句 像任何语言一样,SAS 语句的编写也需要遵守一些语法规则。幸运的是,相比英 语来说,SAS 语句的规则不仅少,而且简单。 最重要的规则是: 每一个 SAS 语句都由一个分号结尾 听起来很简单, 但即使最富有经验的 SAS 程序员也会偶然忘记分号。 如果你能记住这个规则, 再来看看另外两个规则吧。 SAS 程序布局 让每一条语句看起来整洁、用缩进来表现语句的各个部分,这是很有用的, 但不是必须的:  SAS 语句不区分大小写。  一条语句可以持续到第二行(只要不把一个单词分开) 。  几条语句可以用一行。 1  可以在任何一列中开始一条语句 注释 可以在你的程序中插入一些注释,让它更容易明白。即使你插入一些你喜欢的食物品 名也不会对程序有所影响, 因为 SAS 不读取注释。 但不要忘记注释是为了让某人更轻松的学 习你的程序,并明白你为什么这么做。 *Read animals’weights from file; DATA animals; INFILE’c:\MyRawData\Zoo.dat’; INPUT Lions Tigers; PROC PRINT DATA=animals; /*Print the results*/ RUN; 有两种注释方法,一种是*号和;号;一种是用/* */表示,注意第二种注释方法不能放在第 一列 错误 SAS 程序通常将执行的错误标注为醒目的红色字母,你可能忘了分号,拼错了字母, 按错了键盘, 一个小错误会使得整个程序无法运行。 当你看到红色部分多余黑色部分的时候, 不要灰心。 1.2 SAS 数据集 在你进行分析、撰写报告、对你的数据进行任何处理之前,SAS 必须能够处理你的数据,你 的数据必须是一种叫 SAS 数据集的特殊形式。 因为 SAS 非常灵活, 能够读取任何形式的数据, ...

Words: 6620 - Pages: 27