How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.How would you code a merge that will keep only the observations that have matches from both sets.How would you delete observations with duplicate keys?.How would you delete duplicate observations?.
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?.When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?.How would you include common or reuse code to be processed along with your statements?.Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.What is the one statement to set the criteria of data that can be coded in any step?.If you're not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?.If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?.What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?.Under what circumstances would you code a SELECT construct instead of IF statements?.What is the purpose of the trailing The How would you use them?.How would you code the criteria to restrict the output to be produced?.Name and describe three SAS functions that you have used, if any?.What is the difference between an informat and a format? Name three informats or formats.If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn't have a value?.Are you familiar with special input delimiters? How are they used?.How do you read in the variables that you need?.What SAS statements would you code to read an external raw data file to a DATA step?.
0 kommentar(er)
