Can you state some special input delimiters?DLM= or Delimiter = Infile each spl char is individual delimiter State different ways of getting data into SAS?Methods for getting your data into SAS can be put into four general categories:Įntering data directly into SAS data setsĬreating SAS data sets from raw data files (infile and input statements) Converting other softwares data files into SAS data sets (proc sql connect to database files) Reading other softwares data files directly ( Proc Sql Pass-Through Facility)ġ2. input buffer (if reading any non-SAS data),ĭetermining variable attributes for output SAS data setĬapturing variables to be initialized to missingġ1.
#Base sas interview questions code#
SAS source code translation to machine language Name at least five compile time statements?During Compilation of Data Step For what purposes do you use DATA _NULL_?ġ0. Options mlogic merror mprint symbolgen sasautos= mautosource mcompilenote 9. Options nodate notime linesize= pagesize = Session from the time the option is specified until it is changed.SAS options: an option that affects the processing of an entire SAS program or interactive SAS What system options are you familiar with?- SAS system options are initialized with default settings when SAS is invoked Data statement options at least any 3 options.ĭata libref.outputdtataset(datasetoptions) ĭrop =, Keep =, Rename=, Where =, Firstobs =, Obs =ĭrop, Keep, Where and Rename can also be used as statementsĨ. INFORMAT to convert non standard to standard to create mathematicalħ. Mathematical expressions cannot be performed on character data type so use If reading data from existing variable which consists of non standard data If reading data from raw data file we use INFORMAT Statement, INFORMAT converting non standard data value into standard value If formats are available with sas system(in-built) it is SYSTEM DEFINEDįORMAT (dollar14.2, comma10.2, date9., mmddyy10.,time8.) Describe your familiarity with SAS Formats / Informats.įORMAT presentation / display / appearance of a value for the end user toįormats are created using FORMAT PROCEDURE(USER DEFINED What version of SAS are you currently using?Ħ. Not possible, it can only be character data type.4. If a variable contains letters or special characters, can it be numeric data type? If Numbers are stored as character data type then we cannot perform any mathematical expression.Īddl Information: To perform mathematical expressions then use INFORMAT to convert into standard numeric data value and numeric data type.3. Yes, character data type can store Letters(A-Z,a-z) or Number (0-9) or Spl or Combination of these.
If a variable contains only numbers, can it be character data type? Also give example?
Read class notes to understand the storage values / length / missing values representation2. How many data types are there in SAS?Sas has only Two Data Types Flat No: 212, 2nd floor,Annapurna Block, Aditya +9140 6462 6789, +91 9Online and Classroom Trainings for SAS, SAS BIīase Sas / Advance SAS Interview Questions1.
0 kommentar(er)
