Question56:GiventheSASdatasetEMPLOYEES:

EMPLOYEES

NAMESALARY

--------------------

Innis60000

Jolli50000

Ellis55000

Liu45000

ThefollowingSASprogramissubmitted:

procprintdata=employees;wherenamelike'_i%';run;Whatiscontainedintheoutput?

1.Liuonly

2.Get all Questions and Answer from here

3.You need to have paid subscription to access all questions

4.Thanks for considering Python Certification Material

CorrectAnswer:1

LIKEcondition:Testsforamatchingpattern.

sql-expression(NOT)LIKEsql-expression(ESCAPEcharacter-expression)

Arguments:sql-expression:isdescribedinsql-expression.

character-expression:isansql-expressionthatevaluatestoasinglecharacter.Theoperandsofcharacter-expressionmustbecharacterorstringliterals.

Note:IfyouuseanESCAPEclause,thenthepattern-matchingspecificationmustbeaquotedstringorquotedconcatenatedstring;itcannotcontaincolumnnames.Details:The

You can access to full explanation to question and answer from this page.