Hi All,
I am getting ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000 while executing proc sql.
proc sql ;
create table SAMPLE_OUTPUT as
select
DI.VIN AS VIN,
DI.REG_NO AS REG_no,
input(DI.FITMENT_DEALER,comma10.)as fit_dealer_code,
input(DI.ORDER_DEALER,comma10.)as Parent_dealer_code,
input(DI.VENDOR,comma10.)as Vendor_code,
DI.DI_ORDER_DATE AS Order_Dt,
DI.DI_ORDER AS Order_num,
DI.SALE_DATE AS Sale_Dt,
DI.V_INV_DATE AS INVC_DT,
DI.V_INV as INVC_NUM,
DI.FINAL_SUBMIT AS FINAL_SUBMIT,
DI.FINAL_SUBMIT_DATE AS FINAL_SUBMIT_DT,
DI.VAHAN_UPD_DATE as vahan_upd,
DI.LASER_VALIDATE as general_flg,
DI.DLR_FDATE as dlr_fit_dt,
DI.AEDAT as UPdate_dt,
VEN.VENDOR_NAME as vendor_name,
CASE WHEN NOT MISSING(REORDER.VIN) THEN 'X' END AS REORDER_FLG,
CASE WHEN NOT MISSING(PHOTO.VIN) THEN 'X' END AS FR_HSRP_Photo,
CASE WHEN NOT MISSING(DEF.VIN) THEN 'X' END AS Defect_Punch,
'' as GRN_FLG,
DI.D_STS as dealer_status
from
Libref1.INPUT1 as DI
left join Libref2.INPUT2 as VEN on input(DI.VENDOR,comma10.)=VEN.vendor_code
left join Libref1.INPUT3 as reorder on di.vin=reorder.vin
left join Libref1.INPUT4 as PHOTO on di.vin=PHOTO.vin
left join Libref1.INPUT5 as def on di.vin=def.vin AND DI.V_INV=def.V_INV AND DEF.NOT_OK<>''
where
input(DI.FITMENT_DEALER,comma10.)=64394
;
run;
Any idea or suggestion why I am getting the error?
Regards,
SnehasisTTPL
