Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi can I get some help with my practice test could I get the solution code to compare with my answers /* Q1. Create a

Hi can I get some help with my practice test could I get the solution code to compare with my answers

/* Q1. Create a new folder (name - Test3) on the SAS server. Create a library with the name test3 pointing to the folder Test3. Upload any XLSX file in folder Test3. Use proc import to import the data in the test3 library as a dataset. */

/* Q2. Write SAS program to find all cars (use sashelp.cars) with cylinders 4 & horsepower more than 200. Print the output dataset using proc print. */

/* Q3. Write SAS program (use sashelp.cars) to create an array from MPG_City & MPG_Highway. Use the Array & of operator to calculate avg mpg in a new column. Print the output dataset using proc print. */

/* Q4. Write a SAS program to create a new column that gives you the length of model name (use sashelp.cars). If the length of model name for any car is more than 10 characters, then trim it down to first 10 characters. Print the output dataset using proc print. */

/* Q5. Write a SAS program to create a new column (name - discount) that gives you the difference between MSRP & Invoice (use sashelp.cars). Calculate percentage discount (100*discount/msrp), round it off to 1 decimal place. If the discount percentage is more then 10 then filter such rows in a dataset with only model, make, msrp, invoice, discount percentage. Print the output dataset using proc print. */

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

How should information systems projects be selected and managed?

Answered: 1 week ago