Hi I am running this code but in the lines where I am ask to Replace the texts I can't seems to get it.....Not sure If i'm doing the right thing Just need some assistance in getting this code done ASAP!! Any help is appreciated DATA WORK.BAKERYSALES ; INFILE '/home/emilymoore20/EPG194/output/myTestFolder/BSA570v4_Week4_assignment_data.txt' DELIMITER = '|' MISSOVER DSD LRECL=32767 FIRSTOBS=2 ; /* REPLACE THIS COMMENT TEXT TO ANSWER THE QUESTION: INFORMAT statements do what? */ INFORMAT strDate $30. ; INFORMAT product best32. ; INFORMAT sales nlnum32. ; /* REPLACE THIS COMMENT TEXT TO ANSWER THE QUESTION: FORMAT statements do what? */ FORMAT strDate $30. ; FORMAT product best12. ; FORMAT sales nlnum12. ; INPUT strDate $ product sales ; DATA new; SET bakerysales; dateSlashFinder=FIND(strDate,"/"); dateCommaFinder=INDEX(strDate, ','); FORMAT productSales COMMA20.; FORMAT productName $30.; FORMAT date MMDDYY10.; /* REPLACE THIS COMMENT TEXT TO ANSWER THE QUESTION: What is the if/else statement accomplishing? Your answer should be specific and complete, and describe (among other things) the purpose of the DO loop.*/ IF dateCommaFinder = 0 THEN DO date = input(strDate,MMDDYY10.); FORMAT date MMDDYY10.; day = day(date); mnth=month(date); year=year(date); END; ELSE DO date3 = SUBSTR(strDate, dateCommaFinder+2); dateSpaceFinder=INDEX(date3, ' '); month = SUBSTR(date3, 1, dateSpaceFinder); SELECT (month); WHEN ('January') mnth=01; WHEN ('February') mnth=02; WHEN ('March') mnth=03; WHEN ('April') mnth=04; WHEN ('May') mnth=05; WHEN ('June') mnth=06; WHEN ('July') mnth=07; WHEN ('August') mnth=08; WHEN ('September') mnth=09; WHEN ('October') mnth=10; WHEN ('November') mnth=11; WHEN ('December') mnth=12; OTHERWISE mnth=.; END; day = INPUT(SUBSTR(date3,dateSpaceFinder+1,2),2.); year = INPUT(SUBSTR(date3,dateSpaceFinder+5,4),4.); date = MDY(mnth,day,year); END; /* REPLACE THIS COMMENT TEXT TO ANSWER THE QUESTION: What is the following section accomplishing? */ productSales = INPUT(TRIM(sales), COMMA20.); SELECT (product); WHEN (1) productName='Breakfast bar'; WHEN (2) productName='Cookie bar'; WHEN (3) productName='Savory meal bar'; OTHERWISE productName=.; END; RUN; /* REPLACE THIS COMMENT TEXT TO ANSWER THE QUESTION: What is the following section accomplishing? */ PROC TABULATE DATA = new FORMAT=DOLLAR11. STYLE={BACKGROUND=WHITE FOREGROUND=BLUE JUST=CENTER}; CLASS productName year mnth; VAR productSales; KEYLABEL ALL='Totals'; TABLE productName = '' ALL, ((year='Year'*mnth='Month' ALL)*productSales='' *SUM=''); RUN;
... View more
