Communities.sas.com



Fact Collection Table:PROGRAM:34 proc sql;35 CREATE TABLE autodialer as36 SELECT a.cardid, datepart(a.dimattemptdate) as attdate format mmddyy10.,37 a.dimattempttimeID, a.dimowneragencyID, b.attemptType, b.actioncode,38 c.owneragencycode as agency, d.state39 FROM newdw.factcollection a, newdw.dimattempt b, newdw.dimowneragency c,40 newdw.dimlocation d41 WHERE a.dimattemptID=b.dimattemptID42 AND a.dimowneragencyID=c.dimowneragencyID43 AND a.dimlocationID=d.dimlocationID44 AND a.dimattemptdate between "&Pend"d and "&Cend"d45 AND b.actioncode = '1';NOTE: Table WORK.AUTODIALER created, with 1457333 rows and 8 columns.46 QUIT;NOTE: PROCEDURE SQL used (Total process time): real time 1:29.25 cpu time 2.92 secondsRESULT: CHARACTERWRONG FORMAT:NEXT PART OF THE PROGRAM TO CORRECT:21 22 GOPTIONS ACCESSIBLE;23 data autodialer;24 set autodialer;25 attdate = input(attdate,mmddyy10.);26 RUN;NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 25:11 NOTE: Format $MDDYY was not found or could not be loaded.NOTE: Invalid argument to function INPUT at line 25 column 11.CardID=1001019 attdate=. dimAttemptTimeID=598 dimOwnerAgencyID=11 AttemptType=ManualAttempt ActionCode=1 agency=GCS3 State=CA_ERROR_=1 _N_=1NOTE: Invalid argument to function INPUT at line 25 column 11.CardID=1001019 attdate=. dimAttemptTimeID=898 dimOwnerAgencyID=11 AttemptType=ManualAttempt ActionCode=1 agency=GCS3 State=CA_ERROR_=1 _N_=2NOTE: Invalid argument to function INPUT at line 25 column 11.CardID=1001019 attdate=. dimAttemptTimeID=1080 dimOwnerAgencyID=11 AttemptType=ManualAttempt ActionCode=1 agency=GCS3 State=CA_ERROR_=1 _N_=3NOTE: Invalid argument to function INPUT at line 25 column 11.CardID=1019133 attdate=. dimAttemptTimeID=731 dimOwnerAgencyID=34 AttemptType=ManualAttempt ActionCode=1 agency=IRM2 State=IN_ERROR_=1 _N_=4NOTE: Invalid argument to function INPUT at line 25 column 11.CardID=1019133 attdate=. dimAttemptTimeID=568 dimOwnerAgencyID=34 AttemptType=ManualAttempt ActionCode=1 agency=IRM2 State=IN_ERROR_=1 _N_=5NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 1457333 at 25:11 NOTE: There were 1457333 observations read from the data set WORK.AUTODIALER.NOTE: The data set WORK.AUTODIALER has 1457333 observations and 8 variables.NOTE: DATA statement used (Total process time): real time 0.75 seconds cpu time DIFFERENT TABLEFACT HISTORY DETAIL TABLE:Same format as fact collections. verifiedSame format as fact collections table: verifiedPROGRAM:PROC SQL;CREATE TABLE history ASSELECT cardID, datepart(dialerdate) as dialdate format mmddyy10., phonenumberFROM newdw.facthistorydetailWHERE dialerdate between "&Pend"d and "&Cend"d;QUIT;LOG:23 PROC SQL;24 CREATE TABLE history AS25 SELECT cardID, datepart(dialerdate) as dialdate format mmddyy10., phonenumber26 FROM newdw.facthistorydetail27 WHERE dialerdate between "&Pend"d and "&Cend"d;NOTE: Table WORK.HISTORY created, with 15141840 rows and 3 columns.28 QUIT;NOTE: PROCEDURE SQL used (Total process time): real time 47.62 seconds cpu time 28.31 secondsCorrect format of the date variable. Verified date is in the correct format. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download