Hello all,
I have been having issues converting date ths is in yymmdd10. to ddmmyy10.
I have been trying this code
, input(LVRTEDAT,yymmdd10.) as LVRTEDAT format ddmmyy10. , input(LVPURDAT,yymmdd10.) as LVPURDAT format ddmmyy10.
ERROR: INPUT function requires a character argument. ERROR: Character expression requires a character format. ERROR: INPUT function requires a character argument. ERROR: Character expression requires a character format.
LVTREDAT is a variable pulling from sql which is in yymmdd10.
I have also tried the below code and coming up with the below error
format LVINPDAT ddmmyy10.; format LVRTEDAT ddmmyy10.; format LVPURDAT ddmmyy10.;
ERROR: CLI cursor fetch error: [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
FULL ACTUAL CODE:
proc sql exec; connect to odbc (&connectA); create table pveh as select LVPOLNO , LVVEHNO , LVVEHPRM , LVVEHPRC , LV1SPR2A , LVALWDRV , LVPLNNO , LVNCD , LVRGDPRS , LVBASEXS , LVADDEXS , input(LVINPDAT,yymmdd10.) as LVINPDAT format ddmmyy10. , input(LVRTEDAT,yymmdd10.) as LVRTEDAT format ddmmyy10. , input(LVPURDAT,yymmdd10.) as LVPURDAT format ddmmyy10. , LVNCDPRO , LVCVRTYP , LVUSECDE , LVINSVAL , LVVEHMOD , LVVEHBDY , LVCHPFCT , LVVEHYRL , LV1SPR7P0 , LVANNMLG , LVBRKCVR , LVLGLPRO , LV2SPR1A , LVMOPCDE from connection to odbc (select * from OPENQUERY (BETA,' Select * from budadm.pveh as A where a.lVpolno >= '&min' and a.lVpolno <= '&max' and a.lVamdno = 1 ')A)B; disconnect from odbc; quit; run;
Your help will be much appreciated. Thanks 🙂
... View more
