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?
4 15781How would you include common or reuse code to be processed along with your statements?
PSCI,
5 14736When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
7 19420If 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?
16 20084Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
3 7816How would you code a merge that will keep only the observations that have matches from both sets?
5 11685How 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?
2 9679
What is the general format of function in sas? : sas-grid-administration
how sas deals with business intelligence? : Sas-bi
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
AE datasets names? how many types?
what is information maps?
Why double trailing @@ is used in input statement?
How do you control the number of observations and/or variables read or written?
Describe a time when you were really stuck on a problem and how you solved it?
Are you involved in writing the inferential analysis plan? Tables specfications?
name several ways to achieve efficiency in your program? : Sas programming
how does sas handle missing values in sort order? : Sas programming
explain what is data set in sas? : Sas-administrator
Explain what is data step?
what is function of retain statment
which date function advances a date, time or datetime value by a given interval? : Sas programming