topic Re: The table i promoted got disappeared in SAS Programming

The table i promoted got disappeared

arundhatiD — Mon, 27 Dec 2021 15:46:45 GMT

Hi Team,

I am working on SAS studio in SASViya.

I am having one use case where I have one table Audit table in system data Library in sas viya which holds only last 7days data always.

I have created COPY of this data as i am working on ETL to have more data ,so i created copy of this table and promoted it.

But two day before the table disappeared. I used below code .This should not desired in my case as this will be a one time run code and later i will append new rows in the same promoted table.

I have recently started working on SASViya. Please guide me to solve this issue.

options validvarname=ANY;
cas casdemo sessopts=(caslib=casuser timeout=1800 locale="en_US");

caslib _all_ assign;
libname pblic cas caslib=PUBLIC_DNFS ;
libname sys cas caslib=SystemData;
/copy a dataset named AUDIT from sys lib to pblic lib/
Proc sql;

Drop table pblic.audit;
Quit;

proc copy in=sys out=pblic;
select AUDIT;
contents data=pblic.AUDIT ;
run;
quit;


PROC CASUTIL;
Promote casdata ="AUDIT" incaslib="PUBLIC_DNFS"
outcaslib ="PUBLIC_DNFS" casout ="AUDIT";

RUN;

Re: The table i promoted got disappeared

sbxkoenk — Wed, 05 Jan 2022 17:33:45 GMT

Hello,

Is this solved already??

It could be that the server was rebooted. In that case the memory is purged.

It's a good idea to always save your in-memory tables with a special on-disk format (*.sas7hdat). You can use the same CASLIB.

Then after rebooting the server, you can very, very (!) quickly re-load the tables that were in-memory.

See PROC CASUTIL SAVE statement.

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casref/n1fujq5fhyeiprn1whq1iva21obo.htm

Koen

Re: The table i promoted got disappeared

Kurt_Bremser — Wed, 05 Jan 2022 18:27:19 GMT

PLEASE post your code in correct manner. I showed you the buttons in a picture(!), so it should be child's play to get it right.