I have a Azure synapse SQL Pool where I have to insert data using SAS     libname bet sqlsvr datasrc="BET" user=datanalitica password="XXXXXX" schema="BET" USE_ODBC_CL=YES insertbuff=30000 insert_sql=yes autocommit=yes stringdates=yes ;     I successfully connect to the database, but when I try to insert data using proc append   proc append base=bet.DIM_RAMO_FINANZAS () data=W_DIM_RAMO_FINANZAS nowarn ; run; It only inserts the first record of the dataset even though in log proc append shows that added all records SQLSRV_4: Prepared: on connection 2 INSERT INTO "BET"."DIM_RAMO_FINANZAS" ("RAMO_FINANZAS_CD","FILIAL_GRUPO_SK","RAMO_FINANZAS_NM","RAMO_FINANZAS_DESC","TIPO_RAMO_CD","ORDEN_RAMO_ID","PROCESSED_DTTM") VALUES ( ? , ? , ? , ? , ? , ? , ? ) NOTE: There were 23 observations read from the data set WORK.W_DIM_RAMO_FINANZAS. NOTE: 23 observations added. NOTE: The data set BET.DIM_RAMO_FINANZAS has . observations and 7 variables. SQLSRV_5: Executed: on connection 2 Prepared statement SQLSRV_4 Summary Statistics for SQLSVR are: Total SQL execution seconds were: 0.140779 3 The SAS System 14:22 Thursday, September 1, 2022 Total SQL prepare seconds were: 0.000061 Total SQL describe seconds were: 0.049702 Total seconds used by the SQLSVR ACCESS engine were 0.281108 I have SAS 9.4 M6 ... View more

Hello communities people I have this table, where each row is a customer and each colum BUn represent that id this customer has active products on that business unit (in this example I use a text, but we can also use a binary flag)   CUST BU1 BU2 BU3 BU4 123 SEG AFI     124   AFI ARS   125 SEG       126   AFI     127     ARS   128       FID             I'm tryng to buid a count matrix to try to get this result     BU1 BU2 BU3 BU4 BU1 2 1 0 1 BU2 1 3 1 0 BU3 0 1 2 0 BU4 0 0 0 1   where each cell is a frequency (count) of customers that are commons between business units.   I was trying to do this report using PROC TABULATE, but I did not get the result   PROC TABULATE DATA=WORK.W_DATOS_CLIENTE2 ; VAR CLIENTE_ID; CLASS FILIAL1 / ORDER=UNFORMATTED MISSING; CLASS FILIAL2 / ORDER=UNFORMATTED MISSING; CLASS FILIAL3 / ORDER=UNFORMATTED MISSING; CLASS FILIAL4 / ORDER=UNFORMATTED MISSING; TABLE /* ROW Statement */ FILIAL1 FILIAL2 FILIAL3 FILIAL4 , /* COLUMN Statement */ FILIAL1 *(CLIENTE_ID * N=' ' )FILIAL2 *(CLIENTE_ID * N=' ' )FILIAL3 *(CLIENTE_ID * N=' ' )FILIAL4 *(CLIENTE_ID * N=' ' ) ; ; RUN;   ... View more