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.