![]() #ADVANCED SAS INTERVIEW QUESTIONS AND ANSWERS SOFTWARE# SAS provides a graphical point-and-click user interface for non-technical users and more advanced options through the SAS language.Īnswer: The following are the features of SAS:įeatures Of SAS – SAS Interview Questions – SAS Interview Questions – Features of SASīusiness Solutions: SAS provides business analysis that can be used as business products for various companies to use.Īnalytics: SAS is the market leader in the analytics of various business products and services.ĭata Access & Management: SAS can also be use as a DBMS software. Reporting & Graphics: Hello SAS helps to visualize the analysis in the form of summary, lists and graphic reports. Visualization: We can visualize the reports in the form of graphs ranging from simple scatter plots and bar charts to complex multi-page classification panels.ģ.What is the function of output statement in a SAS Program?Īnswer: You can use the OUTPUT statement to save summary statistics in a SAS data set. This information can then be used to create customized reports or to save historical information about a process. Specify the statistics to save in the output data set, You can use options in the OUTPUT statement to Specify the name of the output data set, andĬompute and save percentiles not automatically computed by the CAPABILITY procedure.Ĥ. What is the function of Stop statement in a SAS Program?Īnswer: Stop statement causes SAS to stop processing the current data step immediately and resume processing statement after the end of current data step.ĥ. What is the difference between using drop = data set option in data statement and set statement?Īnswer: If you don’t want to process certain variables and you do not want them to appear in the new data set, then specify drop = data set option in the set statement. Whereas If want to process certain variables and do not want them to appear in the new data set, then specify drop = data set option in the data statement.Ħ.What is the difference between reading data from an external file and reading data from an existing data set?Īnswer: The main difference is that while reading an existing data set with the SET statement, SAS retains the values of the variables from one observation to the next. Whereas when reading the data from an external file, only the observations are read. The variables will have to re-declared if they need to be used.Īnswer: There are two data types in SAS. Apart from this, dates are also considered as characters although there are implicit functions to work upon dates.Ĩ. What is the difference between SAS functions and procedures?Īnswer: Functions expect argument values to be supplied across an observation in a SAS data set whereas a procedure expects one variable value per observation. Here arguments of mean function are taken across an observation. ![]() The mean function calculates the average of the different values in a single observation. Proc means is used to calculate average temperature by month (taking one variable value across an observation). Here, the procedure means on the variable month.ĩ.What are the differences between PROC MEANS and PROC SUMMARY?Īnswer: PROC MEANS produces subgroup statistics only when a BY statement is used and the input data has been previously sorted (using PROC SORT) by the BY variables. ![]() PROC SUMMARY automatically produces statistics for all subgroups, giving you all the information in one run that you would get by repeatedly sorting a data set by the variables that define each subgroup and running PROC MEANS. PROC SUMMARY does not produce any information in your output. So you will need to use the OUTPUT statement to create a new DATA SET and use PROC PRINT to see the computed statistics.ġ0. Give an example where SAS fails to convert character value to numeric value automatically?Īnswer: Suppose value of a variable PayRate begins with a dollar sign ($). When SAS tries to automatically convert the values of PayRate to numeric values, the dollar sign blocks the process. The values cannot be converted to numeric values. The following steps happen when PROC SQL is executed: Therefore, it is always best to include INPUT and PUT functions in your programs when conversions occur.Īnswer: PROC SQL is a simultaneous process for all the observations. ![]() #ADVANCED SAS INTERVIEW QUESTIONS AND ANSWERS FREE#.#ADVANCED SAS INTERVIEW QUESTIONS AND ANSWERS SOFTWARE#.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |