A00-215 Exam Question 101
You have a dataset named 'Employee_Data' containing employee information. You want to create a new dataset named 'High_Salary_Employees' containing only employees with a salary greater than $100,000 and working in the 'IT' department. Which code snippet correctly uses the OUTPUT statement to achieve this?
A00-215 Exam Question 102
You have a dataset 'CUSTOMERS' with a variable 'CITY containing city names and a variable ZIP CODE'. You want to create a sorted dataset 'CUSTOMERS SORTED' where the city names are sorted alphabetically, but within each city, the ZIP codes are sorted in descending order. How would you achieve this?
A00-215 Exam Question 103
You are tasked with creating a report that displays sales data in a specific format for a client. The report needs to be exported as a PDF file with a custom logo and footer. Which ODS statements would you use to achieve this? ' 'NOTE:'' The data is stored in a SAS dataset called 'SalesData'.
A00-215 Exam Question 104
You are importing a large CSV file with millions of rows. Due to memory limitations, you want to import the data in chunks. How can you use PROC IMPORT to efficiently import the file in chunks?
A00-215 Exam Question 105
You are tasked with analyzing a SAS dataset named 'CustomerData' located on a remote server with the path '/home/data/customer_data'. The dataset is accessible via the SAS client using the 'SAS DATA' library. Which LIBNAME statement should you use to properly access the dataset?