Cognizant Servicenow Application Developer Interview Questions, Process, and Tips

if is a conditional statement used to execute code based on a condition. where is used to filter data in a query.

• if is used in programming languages to execute code based on a condition

• where is used in SQL to filter data in a query

• if can have multiple conditions and can be nested

• where can only have one condition per query

sysfunc is a SAS function used to execute system commands and return their output.

• It can be used to execute operating system commands within SAS programs.

• It can be used to retrieve system information such as the current date and time.

• It can be used to manipulate character strings.

• Example: %sysfunc(date(), word)

• Example: %sysfunc(systeminfo, word)

Commutative sum is the sum of two numbers that remains the same even if the order of the numbers is reversed.

• Add two numbers

• Reverse the order of the numbers

• Check if the sum remains the same

Proc means and proc summary are SAS procedures used for summarizing data. Macro variables can be created using %let statement.

• Proc means provides more detailed statistics like standard deviation, minimum and maximum values, while proc summary provides only basic statistics like count, sum, mean, etc.

• Proc means can handle missing values by default, while proc summary requires the MISSING option to be specified.

• Macro var...read more

The %include directive is used in SAS programming to include external files or code snippets.

• It allows for reusability of code

• It can be used to include macro definitions or data sets

• It can be used to include code from other SAS programs

• Syntax: %include 'filename';

To check if all character variables are blank, we can use the COUNT function in SQL.

• Use COUNT function to count the number of non-blank character variables.

• If the count is zero, then all character variables are blank.

• Example: SELECT COUNT(*) FROM table_name WHERE column_name <> '';

Proc format syntax and difference between union and union all

• Proc format is used to create custom formats for variables in SAS

• Syntax: proc format lib=library cntlin=dataset; value formatname low-high='label'; run;

• Union combines the results of two or more SELECT statements, while Union All includes duplicates

• Union All is faster but may return duplicate rows

• Union requires sorting and removing duplicates, but returns only

To copy the structure of a table only, use the CREATE TABLE AS SELECT statement.

• Use the CREATE TABLE AS SELECT statement with a WHERE clause that is always false to copy only the structure of the table.

• Example: CREATE TABLE new_table AS SELECT * FROM existing_table WHERE 1=0;

• Alternatively, use the SHOW CREATE TABLE statement to generate the SQL code for creating the table structure.

• Example: SHOW CREATE TABLE existing_t

Proc report is a SAS procedure used for creating tabular reports.

• It allows for customization of column headers, footers, and data cells.

• Options include sorting, grouping, and summarizing data.

• Example: proc report data=mydata; column var1 var2 var3; run;

• Example: proc report data=mydata; column var1 var2 var3; define var1 / group; run;