Question47:GiventherawdatarecordDEPT:
----|----10---|----20---|----30
Printing750
ThefollowingSASprogramissubmitted:
databonus;
infile`dept';
inputdept$1-11number13-15;
$insertstatementhere$
run;
WhichSASstatementcompletestheprogramandresultsinavalueof`Printing750'fortheDEPARTMENTvariable?
1.department=deptIInumber;
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:4
Exp: Theinputstatementreadsthevariabledeptusing11bytes.Thevalueofdept(Department)consistsof8bytestherefore3trailingblanksarepresentinthevalue
ofdeptwhichneedtobetrimmedoutusingthetrimfunction.Thisisconcatenatedtotheputfunctionwhichconvertsnumericvariablestocharactervariablesusingthesupplied
format(3.)
TRIM(source)TheTRIMfunctionproducesavaluewithoutthetrailingblanksinthesource.
Note:OtherrulesabouttrailingblanksinSASstillapply.Ifthetrimmedresultisshorterthanthelengthofthevariabletowhichtheresultisassigned,SASpadstheresultwith
newblanksasitmakestheassignment
Syntax: PUT(source,format.)
You can access to full explanation to question and answer from this page.