I  can't make a desicion between choice B and D? what does the 'input statement specification' mean? ... View more

data work.test; infile datalines; input Name $ 1-14/ Address $ 1-14/ City $ 1-12; if City = 'New York ' then input @1 State $2.; else input; datalines; Joe Conley 123 Main St. Janesville WI Jane Ngyuen 555 Alpha Ave. New York NY Jennifer Jason 666 Mt.Diablo Eureka CA ; run; proc print data = work.test; run;   What is the 'else input' mean? if the city = New York then input NY ,  in' else input' , input what ?  ... View more

libname cert 'C:\practice everyday\input'; libname results 'C:\practice everyday'; data results.output09; set cert.input09; a = substr(custID,3,4); b = a*1000; custID = tranwrd(custID,a,'9999'); run; proc print data = results.output09; run; when I use variable a instead of 'substr(custID,3,4) as the second argument of the function tranwrd, it doesn't work. why? The following is the data : libname cert 'c:\cert\input'; Data cert.input09; Input custID $; Datalines; ID1573 ID2369 ID5361 ID8902 ; Run;   ... View more

libname te xlsx 'C:\practice everyday\input\input01.xlsx'; proc contents data = te._all_; run; output: order : SHEET BB SHEETA SHEETC  , but in xlsx file , order is following:   ... View more

title "Random Assignment - Three Groups"; proc report data=Learn.Assign panels=99 headline ps=16; columns Subject Group; define Subject / display width=7; define Group / width=5; run; partial of the my output like this : the output on textbook like this:   ... View more

data work.family; infile datalines; input relation $ first_name $ birthdate mmddyy8.; datalines; son Frank 01/31/89 daughter June 12-25-87 brother Samuel 01/17/51 ; proc print data = work.family; *format birthdate mmddyy10.; run;   The answer tells that the colon must be added. But , I get the perfect output without it , why? ... View more