Diff between proc sql merge and join?
Answer / anand
Merge - Data sets must be sorted by or indexed on the BY variable prior to merging.
Proc SQL - Data sets doesnot need to be sorted or indexed.
| Is This Answer Correct ? | 8 Yes | 0 No |
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
Name some categories in sas 9? : sas-grid-administration
Explain the difference between informat and format with an example.
How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
What are the different servers in sas? : sas-grid-administration
Mention what are the data types does SAS contain?
how the sas basic syntax style described? : Sas-administrator
Describe a time when you were really stuck on a problem and how you solved it?
How many data types are there in SAS?
How could you generate test data with no input data?
How would you determine the number of missing or nonmissing values in computations?