Hi, I'm still not sure to fully understand your point; what do you mean by "re-load"? - when you said "the user manually re-loads the imported entities" I understand "the user manually launch the reindex of the imported entities". If it is also your point, I already showed you how to do it (see my code above). Or maybe the solution I gave you does not fit? - or I am wrong in my understanding, and when you're talking about "re-load" you want to say that the user re-import the entities from scratch? Depending on your response to the first point, I will be able to show you how to do it for all entities. Have a nice day, JD ... View more

Hello, I'm happy to help; if I understand well the reindexing is OK for you, but you want to reload your data in-memory?  Could you please describe what should be your reload process? Do you want to load data into a CAS table? Could you also tell me which type of datasource are you using for your external entity (PostgreSQL, MySQL, ...)?   Thank you for your answers,   JD ... View more

Hello, I'm not familiar with SAS LSF but if you want to update your external entity and see the changes into VI, you just have to reindex the entity after updating your table. You can do it automatically with rest api calls; in SAS you should use the proc http: you just have to change the fields between "<>":   # First you have to get the authentication token filename resp TEMP; filename hdrs TEMP; proc http url="http://<your-domain-name>/SASLogon/oauth/token" method='POST' auth_basic webusername="sas.ec" webpassword="" in='grant_type=password&username=<your-user-name>&password=<your-password>' out=resp headerout=hdrs; run; # Put the token in the access_token macro variable data _null_; infile resp truncover dlm='"' ; input @'"access_token":"' token :$2000. ; call symputx('access_token',token,'g'); run; # Launch the reindexing job through the API proc http url="http://<your-domain-name>/svi-datahub/admin/asyncJobs?new" method='POST' OAUTH_BEARER="&access_token." in='{"parameters": {"type": "SEARCH_INDEX_LOADER"},"tasks": [{"parameters": {"type": "LOAD_DOCUMENT","name": "<your-entity-name>"}}]}'; headers 'Accept'='application/json' 'Content-Type'='text/plain'; run;   Hope this will help.   Cheers,     JD  ... View more

Hi, I get the response from the support, thank you for your help. Cheers, JD ... View more

Hi Paulius, Thank you for your response, that's exactly what I'm looking for. I understand there is no public documentation about that, but could you help me on the first REST API call, to upload files to a specific folder? I think I will be able to achieve the second one.   Cheers, JD ... View more

Hi, Could you provide a sample of you input table please?   Regards, JD ... View more

Hello, You should try this code:   proc report data=dii_m out=dii_median; columns sex Q Adj_DII; define sex / group "Sexe"; define Q / group "Quartile"; define Adj_DII / median; run; ... View more

Hi, Dis toi try this method : libname test pcfiles path=your-path-to-the-file; data toto; set test.sheet1; run; When sheet1 is the name of the sheet you want to ingest ... View more