Question: 2. Controlling Case-Sensitivity in a Macro Copy the program shown below into the Editor window. proc means data=orion staff sum mean; var Salary; class

2. Controlling Case-Sensitivity in a Macro Copy the program shown below into the Editor window. proc means data=orion staff sum mean; var Salary; class Job Title; www. where Job Title contains "Sales"; title "Summary Statistics for the Sales Group"; run; a. Convert the program into a macro named SUMSTATS. Replace occurrences of Sales with a macro variable reference. Modify the SUMSTATS macro so that the macro variable and the data set variable in the WHERE statement are not case-sensitive. Compile and execute the macro using sales as the value for the macro variable. b. Alter the macro variable reference in the TITLE statement to display the value in proper case.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Gold Chain was to manufacture 1 comma 000 chain saws next month. Its accountant has provided the following analysis of the total manufacturing costs. Modifying Variable with underline Modifying...

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

What are some potential drawbacks or challenges of relying heavily on information technology for supply chain management? How can organizations mitigate these risks?

Prove that: [A (B C)] + [B (C A)] + [C (A B)] = 0. Under what conditions does A (B C) = (A B) C?

The units of an item available for sale during the year were as follows: There are 32 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the...

11. IPOs (S14.2) Find the prospectus for a recent IPO. How do the issue costs compare with a. Those of the Marvin issue? b. Those shown in Table 14.3? Can you suggest reasons for the differences?

=+c) The impact of what two major events can you see in the plot of residuals against Time?

Multiple Choice Questions 1. James Corporation owns 80 percent of Carl Corporations common stock. During October, Carl sold merchandise to James for $250,000. At December 31, 40 percent of this...

Write a function called double_str that takes a string argument and returns a new string that has all of the same characters as the argument, except each one is repeated twice. For example:...

Morrow Corporation had only one job in process during May - Job X 3 2 Z - and had no finished goods inventory on May 1 . Job 3 2 Z was started in April and finished during May, Data concerning that...

Southern Amusements Corporation had the following stockholders' equity on November 30: On December 30, Southern purchased 200 shares of treasury stock at $15 per share. Southern Amusements...

What is meant by "satisfying the customer" as a manager in a healthcare industry

CASE E Calculate Roger Blaine's minimum federal Tax Payable for 2020. Indicate any carry forwards available to him and his dependents and the carry forward provisions. Ignore any amounts Roger might...

Runde & Flanagan (2010) present their Four Rules for Conflict Management (Fig. 6.1, p. 221) and Schermerhorn (2011) outlines the Four Leadership Contexts and three types of Planned Change Strategies....

Post-closing Trial Balance of Premium Fabrics Private Limited for the year ended December 31, 2021 and 2022 are as follows: 2022 2021 Equities and Liabilities Issued and paid-up capital 5,000,000...

should be incremented in steps of 1 rour freeram should also thiplay the masaen lvastias viseseat whed the in and fvalues are equal) y=x42(xz) should be incremented in steps of 1 rour freeram should...

Let X be a random variable taking on values a1, a2, . . . , pr with probabilities p1, p2, . . . , pr and with E(X) = μ. Define the spread of X as follows: This, like the standard deviation, is a...

=+North Dakota 130.49 Missouri 91.93 Mississippi 40.22 Kentucky 85.21 Michigan 154.75 Maine 150.12 Massachusetts 200.99 New York 193.48 West Virginia 82.94 Virginia 97.98 Georgia 91.31

=+3.63 Many nutritional experts have expressed concern about the high levels of sodium in prepared foods. The following data on sodium content (in milligrams) per frozen meal appeared in the article...

=+3.59 Each observation in the following data set is the number of housing units (homes or condominiums) sold during November 1992 in a region corresponding to a particular Orange County,...