Sas-Crackman-practice-sas认证70题详解.pdf

Sas-Crackman-practice-sas认证70题详解.pdf -...

This preview shows page 1 - 5 out of 143 pages.

答案、中文讲解、原题皆来自 Sas Crackman practice Contents 1) first.variable last.variable 1 The following example is better: 2 Equivalent coding: 3 2 Read raw data @ missover dsm dlm 7 Infile dsd 7 Infile dlm 9 Infile missover 10 Input @ 10 3 Libname dataset excel ‘’ 11 4 Function MDY character versus numeric variable 13 5 Infile obs 13 6 Keep statement and keep option 13 7 ODS excel file 13 8 first.variable last variable 13 9 The value is not in the range proc format value 13 10 Character variable being automatically converted to the numeric variable 13 11 The output of the proc means 13 12 libname dataset ‘Dallas.xls’; 13 13 Two ways to define arrays 13 Data datasetname /debug; 13 15. _error_ will be automatically dropped 13 16 Day() function 13 17 If then statement. Two statements after then 13 19 WHERE= data set option do not perform any automatic conversion in comparisons 13 20 subsetting if 13 21 Proc contents work.all; 13 22 libname prog2 'C:\Users\dude\Desktop\prog2'; 13 24 infile DSD 13 25 firstobs 13
Image of page 1

Subscribe to view the full document.

答案、中文讲解、原题皆来自 26 Proc sort 13 27 Proc sort by descending 13 28 Merge and rename 13 29 Trailing @ 13 30 Execution error 13 31 Missing data at the end of the row 13 32 Sum statement 13 33 character format is case-sensitive 13 34 proc format will generate a file stored in the catalog. 13 35 (tough) Write to multiple data sets 13 36 Informat mmddyy10. 13 38 First.variable 13 39 Array defines new character variables 13 40 do while vs. do until 13 41 CATX function 13 42 Find function. ‘I’ and ‘T’ as modifiers and 5 as the starting position. 13 43 Put function gives you character; input gives you numbers 13 TRANWRD function 13 input function 13 Put function 13 CHAR Function 13 Syntax 13 Arguments 13 44. don’t forget the semicolons 13 45. ods csvall file='c:\test.cvs'; 13 46 mean(of Rev:) Use colons to represent a list of variables. 13 47 Tables variable1*variable2/nocol norow 13 48 Column input 13 49 An array cannot be referenced on a keep= data set option 13 50 Interleaving data sets with by statement: which variable comes first. 13 51 Proc contents data=_all_; 13
Image of page 2
答案、中文讲解、原题皆来自 52 Merge. In dataset option 13 53 Retain statement initializes the value to missing by default. 13 54 retain City 'Beverly Hills'; 13 55. Sas date constant: no blank before d. 13 56. Tables varible1*variable2 13 57 Sas date function 13 58 Proc format; value name (no period) 13 59 Delimited raw data file and truncover 13 60 Drop option in the data step 13 61 if Age not in(15,16) then 13 62 ods html file='sales.html' 13 63 Do until 13 65 Permanently assign labels in the data step 13 66 do loop 13 67 See a missing value as negative infinity 13 68 Character variable vs. numeric variable. 13 69 where Code like 'E_U%'; 13 70 Data step drop option 13
Image of page 3

Subscribe to view the full document.

答案、中文讲解、原题皆来自 1) first.variable last.variable On 2010/11/20, in crackman sas base 认证试题 , by crackman Basically, this means
Image of page 4
Image of page 5
  • Fall '14

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern