Good Day expect, am running the below script and am getting the above error message PROC SQL;
CREATE TABLE CAP.DECK16P4 AS
SELECT 'DECK16P4' AS DECK,*
FROM FB.FINAL_BRACC_ALL
WHERE ACCNRSER IN
(
SELECT INPUT(PUT(COMPRESS(INPUT(PUT(ACNO,13.),$13.)||PUT(SERIAL,Z3.)),$16.),16.)
FROM WORK.MAP_COP_FILE
);
quit; lOG 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (16)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='Y:\AML\VBM\SAP Model\SAS Scripts\SAS Scripts\Tracking Tool.egp'; 6 %LET _CLIENTPROJECTPATHHOST='LSBSA-4HDVQ73'; 7 %LET _CLIENTPROJECTNAME='Tracking Tool.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HtmlBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 27 PROC SQL; 28 CREATE TABLE CAP.DECK16P4 AS 29 SELECT 'DECK16P4' AS DECK,* 30 31 FROM FB.FINAL_BRACC_ALL 32 WHERE ACCNRSER IN 33 ( 34 SELECT INPUT(PUT(COMPRESS(INPUT(PUT(ACNO,13.),$13.)||PUT(SERIAL,Z3.)),$16.),16.) 35 FROM WORK.MAP_COP_FILE 36 ); ERROR: Numeric format F in PUT function requires a numeric argument. ERROR: Numeric format Z in PUT function requires a numeric argument. ERROR: Numeric format F in PUT function requires a numeric argument. ERROR: Numeric format Z in PUT function requires a numeric argument. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-04-20T14:32:23,969+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 2206438| _DISARM| 27697152| _DISARM| 13| _DISARM| 21| _DISARM| 0| _DISARM| 56| _DISARM| 0.000000| _DISARM| 0.025944| _DISARM| 1966077143.943687| _DISARM| 1966077143.969631| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-04-20T14:32:23,969+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 624679| _DISARM| 27697152| _DISARM| 13| _DISARM| 21| _DISARM| 0| _DISARM| 56| _DISARM| 0.010000| _DISARM| 0.001826| _DISARM| 1966077143.968149| _DISARM| 1966077143.969975| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 37 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2022-04-20T14:32:23,970+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 118976512| _DISARM| 27697152| _DISARM| 13| _DISARM| 21| _DISARM| 0| _DISARM| 56| _DISARM| 0.010000| _DISARM| 0.084105| _DISARM| 1966077143.886494| _DISARM| 1966077143.970599| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 0.08 seconds user cpu time 0.01 seconds 2 The SAS System 13:46 Wednesday, April 20, 2022 system cpu time 0.00 seconds memory 6551.28k OS Memory 32432.00k Timestamp 2022/04/20 02:32:23 PM Step Count 60 Switch Count 0 Page Faults 0 Page Reclaims 78 Page Swaps 0 Voluntary Context Switches 22 Involuntary Context Switches 10 Block Input Operations 0 Block Output Operations 0 38 39 GOPTIONS NOACCESSIBLE; 40 %LET _CLIENTTASKLABEL=; 41 %LET _CLIENTPROCESSFLOWNAME=; 42 %LET _CLIENTPROJECTPATH=; 43 %LET _CLIENTPROJECTPATHHOST=; 44 %LET _CLIENTPROJECTNAME=; 45 %LET _SASPROGRAMFILE=; 46 %LET _SASPROGRAMFILEHOST=; 47 48 ;*';*";*/;quit;run; 49 ODS _ALL_ CLOSE; 50 51 52 QUIT; RUN; 53 accno is a character and serial is a character
... View more