Question: Compete using PROC SQL statement in SAS please Level 2 2. Using PROC SQL Options and Displaying Dictionary Table Information Produce a report that includes
Compete using PROC SQL statement in SAS please


Level 2 2. Using PROC SQL Options and Displaying Dictionary Table Information Produce a report that includes memname (table name), memlabel (table description), and a count of the number of columns in each table, by querying dictionary.Dictionaries Display only one row per table name. Use the FLOW- option to wrap columns between 6- 35 characters. Title the report Dictionary Tables a. Partial PROC SQL Output Dictionary Tables Member Name Data Set Label Columns CATALOGS CHECK CONSTRAINTS COLUMNS CONSTRAINT COLUMN USAGE Catalogs and catalog-specific information Check constraints Columns from every table Constraint column usage 4 List the table name (memname), number of rows (nobs), number of columns (nvar), file size (filesize), length of the widest column (maxvar), and length of the widest column label (maxlabel) by querying dictionary.Tables. Limit the list to tables in the orion library (1ibname-"ORION") and exclude views (memtype ne 'VIEW') from your report. Order the report by table name. Give the columns labels as indicated by the sample output. Name the report Orion Library Tables. If you wrote additional tables to the orion library, your output might differ from the sample PROC SQL output. b. PROC SQL Output Orion Library Tables File Widest Widest Label Table Rows Columns Size Column CUSTOMER EMPLOYEE_ADDRESSES EMPLOYEE DONATIONS EMPLOYEE ORGANIZATION 12 424 124 424 49152 86016 36864 49152 Level 2 2. Using PROC SQL Options and Displaying Dictionary Table Information Produce a report that includes memname (table name), memlabel (table description), and a count of the number of columns in each table, by querying dictionary.Dictionaries Display only one row per table name. Use the FLOW- option to wrap columns between 6- 35 characters. Title the report Dictionary Tables a. Partial PROC SQL Output Dictionary Tables Member Name Data Set Label Columns CATALOGS CHECK CONSTRAINTS COLUMNS CONSTRAINT COLUMN USAGE Catalogs and catalog-specific information Check constraints Columns from every table Constraint column usage 4 List the table name (memname), number of rows (nobs), number of columns (nvar), file size (filesize), length of the widest column (maxvar), and length of the widest column label (maxlabel) by querying dictionary.Tables. Limit the list to tables in the orion library (1ibname-"ORION") and exclude views (memtype ne 'VIEW') from your report. Order the report by table name. Give the columns labels as indicated by the sample output. Name the report Orion Library Tables. If you wrote additional tables to the orion library, your output might differ from the sample PROC SQL output. b. PROC SQL Output Orion Library Tables File Widest Widest Label Table Rows Columns Size Column CUSTOMER EMPLOYEE_ADDRESSES EMPLOYEE DONATIONS EMPLOYEE ORGANIZATION 12 424 124 424 49152 86016 36864 49152
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
