Hi Team,
I am working on SAS studio in SASViya.
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; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.