SAS Programming Fundamentals

The INDEX function in SAS searches a character string for the first occurrence of a specified substring. In 'TATA CONSULTANCY SERVICES', the character 'C' first appears at position 6 (the first letter of 'CONSULTANCY').

The %INCLUDE statement brings external SAS code files into the current program during compilation. It does not include datasets or variables - it includes SAS code from external files, similar to #include in C or import in Python.

January 1, 1960 is the SAS epoch date - the internal value 0. All SAS dates are stored as the number of days from this epoch. Therefore, 01-Jan-1960 has a SAS date value of 0.

The KEEP= option initially retains 3 variables (name, mark1, mark2) from the input dataset. The Total variable is then created (4 vars total). Finally, DROP removes mark1 and mark2, leaving only name and Total = 2 variables in the output.

SAS internally represents missing values differently by data type: numeric missing values are stored as a period (.) while character missing values are stored as a blank space. This is fundamental SAS behavior.

The first PUT resolves &one normally to 'two'. The double ampersand &&one resolves the first & as a delimiter, triggering another lookup of &one which gives 'two'. The triple &&&one resolves the first two as delimiters, looking up &&one (two), then &one (three). Output: two, two, three.

INTNX advances a date, time, or datetime value by a given interval (month, quarter, year, etc.) and returns the new value. INTCK counts intervals between two dates. INTNX is for advancing, INTCK is for counting.

The 'firstobs=50 obs=450' option tells SAS to start reading at observation 50 and stop at observation 450. The number of observations processed is (450 - 50) + 1 = 401.

The COMMA informat (e.g., comma8.) reads numeric values that contain commas and converts them to standard numbers. Formats control output display; informats control input reading. Dollar is a format, not an informat for comma-separated input.

At compile time when reading an external file, SAS creates an input buffer (to hold the raw input record), the Program Data Vector (PDV - holding variable values), and the descriptor portion (dataset metadata). These are the three compile-time constructs.

The single trailing @ holds the current input record in the input buffer for the next INPUT statement within the same DATA step iteration. It prevents SAS from moving to a new record until the iteration ends or a double trailing @@ releases it.

SUM(OF X1-X3) sums the variables X1, X2, X3 (values 9, 4, 1). 9+4+1 = 14. The SUM function handles missing values differently than simple addition, though here all values are present.

In SAS, the PUT function is used to convert a numeric value to a character value using a specified format. The INPUT function is used to convert character values to numeric values.

PROC TRANSPOSE is designed specifically to transpose data - converting variables to observations (or vice versa). It converts 1 observation with 30 variables into 30 observations with 1 variable efficiently. TABULATE and REPORT are for summarization/display, not transposition.

For a two-way crosstabulation in PROC FREQ, use the TABLES statement with an asterisk between variables: TABLES variable1 * variable2. The asterisk requests the cross-tabulation. Note it's TABLES (plural) not TABLE.

The automatic variable ERROR is set to 1 when any error occurs during DATA step execution, and 0 otherwise. Its value indicates error presence, not line number. On the 10th line error, ERROR becomes 1.

PROC CONTENTS is specifically designed to display the descriptor portion (metadata) of a SAS dataset, including variable names, types, lengths, formats, informats, and labels. PROC DATASETS is a utility procedure for dataset management but PROC CONTENTS is the direct answer for viewing descriptor information. PROC PRINT displays data values and PROC FREQ generates frequency tables, not metadata.

In SAS, when a character variable is created using a function like SUBSTR(), the variable's length is determined by the length of the source string literal, not the length of the result. SUBSTR('joshi anand',1,3) extracts 'joh' but the variable 'a' gets length 11 (length of 'joshi anand'). This is because SAS determines variable lengths at compilation time from the source expression.

The LIBNAME statement uses Windows-style backslashes without proper escaping. In SAS, backslashes are escape characters, so 'c:\mydocuments\output' should be written as 'c:\mydocuments\output' or use forward slashes 'c:/mydocuments/output'. The rest of the code is syntactically correct.