Thank you for your quick response ... View more

Thank you for your help and support. ... View more

Hi @SASKiwi,   It's very strange. When I run the code bellow,  I get the error message:"data could not be located in the LASR". However the table is already loaded in LASR.    41         PROC IMSTAT data=lasr.raw_sensor_data; 42                 update data=greenplum.raw_sensor_data; 43         RUN;   ERROR: The table greenplum.RAW_SENSOR_DATA could not be located in the LASR Analytic Server image. WARNING: The LASR Analytic Server action request for the UPDATE statement did not complete successfully.   ... View more

@JuanS_OCS,   We have distributed VA-environment.   I understand you, but I am not a high level programmer, only a good SAS administrator.    So I am not very familiar with append option. Indeed, what we want to do is check if there new records are available in the source table and load only the new records to the target table.   What kind of modifications should we do if we want only append the new records to the target table ? Can I use a where clause with datetime to filter the records?     ... View more

Hi guys @SASKiwi @JuanS_OCS,   Thank you for your suggestion.   @JuanS_OCSESP is running on a separte environment and writes data directly to Greenplum database. We are using SAS/ACCESS Interface GreenPlum in VA to connect the Greenplum database. We want to load some tables from this database to LASR and update the data frequently.   @kiwi   I have tried to write a SAS program to perform the load. Proc LASR, Append option works fine, but proc IMSTAT, update option not. Is there something wrong with my code?      /* Load into server */ LIBNAME greenplum GREENPLM DATABASE= SERVER="" SCHEMA= USER="" PASSWORD="" ; /* Assign the target library */ LIBNAME lasr SASIOLA TAG=lasr PORT=10051 SIGNER="https://va.example.com:443/SASLASRAuthorization" HOST="va.example.com" ; /* Optimize Load With PROC LASR */ PROC LASR add data=lasr.dataset noclass port=10051; performance host="va.example.com"; RUN; /* Add new records to the the table */ DATA lasr.dataset (append=yes); set greenplum.dataset; RUN; PROC IMSTAT data=lasr.dataset; update data=greenplum.dataset; RUN; Thanks in advance for your help   ... View more

Hi @SASKiwi,   I have found the following option in SAS:     You can record the actions in SAS Visual Analytics as SAS statements.   After enabling this option you need to load once manually the regarding tables.     After that SAS creates a load.sas program in the tmp directory. I can schedule this program in crontab now.   But is this the right way to perform this action or are other efficient ways to do this ?   Thank you. ... View more

Hi @SASKiwi,   Thank you for your quick reply.   We are running on SAS VA 7.3. The tables containts sensor data from ESP (Event Stream Process). So it could be grow very fast. I think so. But for now the tables are very small (2.5 MB), because we are expirementing now. And adding new rows is enough for this action.   Is there a standard sas program that we can use and schedule for these kind of purposes? ... View more