这是SAS adv考试官方模拟题中的一道题目,我不太知道这个要怎么下手,是否需要用到题目里提到的“dictionary table”知识?特来求助大神。
以下是题目:
Open a new programming window to create SQL10.sas in cert\programs.
Write a SAS program that will:
Use SAS dictionary tables, run a PROC SQL query to create a macro variable named COL_LIST which contains a comma separated list of the columns contained in the CERT.AIR10 data set. If needed, use the DESCRIBE TABLE statement to display the column attributes of the dictionary.columns table.
Run your program and troubleshoot as necessary. When you are finished with the project, answer the next question.
有没有哪位大神给个思路指导,万分感谢!!!