How would you create multiple observations from a single observation? Will either read or writes all numeric and character variables in dataset.Ģ7. What are _numeric_ and _character_ and what do they do? If you were told to create many records from one record, show how you would do this using array and with PROC TRANSPOSE?ĭeclare array for number of variables in the record and then used Do loop Proc Transpose with VARstatementĢ6. Functions usually affect the existing datasets.Ģ5. Proc can be used with wider scope and the results can be sent to a different dataset. What is the different between functions and PROCs that calculate the same simple descriptive statistics? How would you create a data set with 1 observation and 30 variables from a data set with 30observations and 1 variable?Ģ4. Most SAS statistical procedures exclude observations with any missing variable vales from an analysis.Ģ3. The result of any operation with missing value will result in missing value.
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data? Sampling method using OBS option or subsetting, commenting the Lines, Use Data NullĢ2. What are some good SAS programming practices for processing very large data sets? What versions of SAS have you used (on which platforms)? Match Merging, Direct Access, Format Tables, Arrays, PROC SQLĢ0. Describe 5 ways to do a “table lookup” in SAS. What areas of SAS are you most interested in?ġ9. I am not sure what you mean different structures.ġ8. I think sort them with common variables and use merge statement. How would you combine 3 or more tables with different structures? What other SAS features do you use for error trapping and data validation?Ĭheck the Log and for data validation things like Proc Freq, Proc means or some times proc print to look how the data looks like …….ġ7. How do you debug and test your SAS program?įirst thing is look into Log for errors or warning or NOTE in some cases or use the debugger in SAS data step.ġ6. What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data? I would use TRANSPOSE if the variables are less use arrays if the var are more ……………. If you were told to create many records from one record, show how you would do this using arrays and with PROC TRANSPOSE? What is the different between functions and PROCs that calculate the same simple descriptive statistics?įunctions can used inside the data step and on the same data set but with proc’s you can create a new data sets to output the results. Sort them once, can use firstobs = and obs = ,ġ2. of the variables later labels all that kind of info inside the dataset and you can look at that info using proc contents procedure. SAS is considered self documenting because during the compilation time it creates and stores all the information about the data set like the time and date of the data set creation later No. Following the data step then you can avoid the usage of the run statement.ġ0. When SAS editor looks at Run it starts compiling the data or proc step, if you have more than one data step or proc step or if you have a proc step. Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Identify statements whose placement in the DATA step is critical.Ĩ. Approximately what date is represented by the SAS date value of 730?ħ. The PDV is created following the input buffer creation.Ħ. An input buffer is created at the time of compilation which holds a record from an external file. At the time, SAS creates a database of one observation at a time. The logical area in the memory is represented by PDV or Program Data Vector. The Data step creates a SAS dataset which carries the data along with a “data dictionary.” The data dictionary holds information about the variables and their properties.
=DATA step, which recovers & manipulates data.ģ. What is the basic structure of the SAS base program? Operation research and Project managementĢ.Business planning, forecasting, and decision support.Statistical analytics, econometrics and data mining.
Information retrieval and data management.
#Sas interview questions pdf software#
SAS means Statistical Analysis System, which is an integrated set of software products. What is SAS? What are the functions does it performs? SAS Interview Questions for freshers experienced :-ġ.
0 kommentar(er)
