PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000)

SnehasisTTPL — Wed, 05 Feb 2020 13:48:56 GMT

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

Re: PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000)

JosvanderVelden — Wed, 05 Feb 2020 17:09:52 GMT

Using just SAS datasets or other DBMS?

Re: PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000)

SnehasisTTPL — Thu, 06 Feb 2020 02:29:00 GMT

Hi JosvanderVelden,

Yes SAP R/3

topic PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000) in SAS Programming

PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000)

Re: PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000)

Re: PROC SQL (ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:000)