About Dawid3

Dawid3 · ‎05-06-2022

Hello, I have a list(table) with logs and I'd like to get the date of last data extraction out of it. And then based on this, run another extraction in SAS DI. How to solve it? Could someone please tell me where I can find materials related to incremental data extraction in sas?

Dawid3 · ‎05-04-2022

I use this code in pre-code to get the no. of records before the loader and then calculate at the end no. of records inserted, it works. data _NULL_; if 0 then set sashelp.class nobs=n; call symputx('nrows',n); stop; run; %put nobs=&nrows;

Dawid3 · ‎04-26-2022

Unfortunately I don"t have access to SAS Environment Manager. I think I could get a pre-code to get the no. of records before the loader and then calculate at the end no. of records inserted - as you say Can you tell me how to get it? I would like to enter the data that I have into the table where I have the start and end time.

Dawid3 · ‎04-26-2022

Hi everyone, I wrote some code for sas DI where I get the start and end time of the job. Does anyone know how to get a number, how many row was inserted? %global startTm endTm; %macro startTiming(); %let startTm = %sysfunc(datetime()); %mend startTiming; %macro endTiming(entry=); %let endTm = %sysfunc(datetime()); proc sql; insert into lib.Tab values("&Entry", &startTm, &endTm ); quit; %mend; %startTiming(); CODE OF JOB %endTiming(entry=Tab);

Dawid3 · ‎04-25-2022

Yes, my issue is solved, it was about what you've said. After modyfing the file everything works perfectly

Dawid3 · ‎04-25-2022

hi, the problem was with postgre, and more precisely, in a file called pg_hba.conf, you had to correctly set up the allow replication connections from the host section.

Dawid3 · ‎04-19-2022

When i run this code: proc setinit noalias; run; %put _all_; proc product_status; run; program returns this: ---SAS/ACCESS to Postgres For SAS/ACCESS to Postgres ... Custom version information: 9.4_M7

Dawid3 · ‎04-15-2022

Hi, I m new in sas, and I have, a problem with conection sas managment console to postgresql base. When I try to register tables, program returns this error: ERROR: CLI error trying to establish connection: could not connect to server: No such file or directory locally and accepting ERROR: Error in the LIBNAME statement. and this error: ERROR: CLI error trying to establish connection: could not connect to server: Connection timed out "IP" and accepting ERROR: Error in the LIBNAME statement. When I try to connect by odbc program returns this error: ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. Somebody knows how to solution this problem or have instruction how to connect sas to postgresql?

Online Status	Offline
Date Last Visited	‎05-24-2022 07:17 AM

Data extraction based on logs list (table)

Re: how to get a number how many row was inserted ?

Re: how to get a number of rows that were inserted ?

how to get a number of rows that were inserted ?

Re: how to add postgresql to sas managment console?

Re: how to add postgresql to sas managment console?

Re: how to add postgresql to sas managment console?

how to add postgresql to sas managment console?

Data extraction based on logs list (table)

Re: how to get a number how many row was inserted ?

Re: how to get a number of rows that were inserted ?

how to get a number of rows that were inserted ?

Re: how to add postgresql to sas managment console?

Re: how to add postgresql to sas managment console?

Re: how to add postgresql to sas managment console?

how to add postgresql to sas managment console?