If get the error
“An error was encountered in the transport layer”
when you try to synchronize an existing SSAS-database onto another empty SSAS instance for the first time, a solution could be to take a backup of the source SSAS-database and restore it onto the new SSAS instance and then do the synchronization.
To get the port number used by your MSSQL-server, you can use the command below.
SELECT local_tcp_port FROM sys.dm_exec_connections WHERE session_id = @@SPID GO
Below is code that produces a quoted string from a column in a dataset. This can be used in an IN-statement in SQL.
proc sql;
select quote(Compress(name)) into :SQLMetaSrc separated by ','
from datasets
;
quit;
Below is a description of very useful options in SAS, if you want a look “behind the scenes” and see what SAS actually does when processing data.
options fullstimer sastrace=(,,,d) sastraceloc=saslog mprint source2 nostsuffix;
| fullstimer | The SAS System provides the FULLSTIMER option to collect performance statistics on each SAS step, and for the job as a whole and place them in the SAS log. It is important to note that the FULLSTIMER measures only give you a snapshot view of performance at the step and job level. |
| sastrace=(,,,d) | Generates trace information from a DBMS engine.
‘,,,d’ specifies that all SQL statements that are sent to the DBMS are sent to the log. Here are the applicable statements: |
| sastraceloc=saslog | Prints SASTRACE information to a specified location. In this case the log in SAS. |
| mprint | Specifies whether SAS statements generated by macro execution are traced for debugging. |
| source2 | Specifies whether SAS writes secondary source statements from included files to the SAS log.
SOURCE2 specifies to write to the SAS log secondary source statements from files that have been included by %INCLUDE statements. |
| nostsuffix | The NOSTSUFFIX system option suppresses printing or display of trailing SASTRACE information and makes the SASTRACE log easier to read. |
In DB2 it’s possible to save temporary tables in the schema SESSION.
It’s possible to insert the command below under keys in the Display Manager (DM) in SAS. The command will reset the line number in the log, clear the log and jump back to the editor.
gsubmit 'resetline';log;clear;wpgm;
You can use the DOS-command TYPE and MORE to get the first megabytes or gigabytes of a large file e.g. of TXT, XML, CSV etc.
This is done by piping the result into another file, there by getting only the first part of the file piped into the new file.
The DOS-command below will start piping the large file into the smaller new file.
type LARGE_SOURCE_FILE | more > SMALL_DESTINATION_FILE
You are not able to see the result from the DOS-command. You need to press the SPACE-key on your keyboard, because every time you press the SPACE-key a new page of the file will be showed and thereby piped into the SMALL_DESTINATION_FILE.
When you think you have done this enough times, then you have to press CTRL-C on your keyboard, this will terminate the type-command and you will have the SMALL_DESTINATION_FILE containing data from the LARGE_SOURCE_FILE.
Be aware that you will get the — more — pipe text in the file!
The SAS SQL-statement below will create a dataset containing all information for the observation with the lowest age in the dataset SASHELP.CLASS.
proc sql;
create table CLASS as
select *
from SASHELP.CLASS
group by AGE
having AGE=min(AGE)
;
quit;
The syntax for the SAS SQL-statement is showed below.
proc sql;
create table <DESTINATION TABLE> as
select *
from <SOURCE TABLE>
group by <COLUMN TO SEARCH>
having <COLUMN TO SEARCH>=<FUNCTION>(<COLUMN TO SEARCH>)
;
quit;
As you see the <FUNCTION> doesn’t have to be min (minimum), it can be any function working on the type of <COLUMN TO SEARCH> – numeric or char.
Below is a list of enterprise password managers
https://www.vaultproject.io/
HashiCorp Vault secures, stores, and tightly controls access to tokens, passwords, certificates, API keys, and other secrets in modern computing. Vault handles leasing, key revocation, key rolling, and auditing. Through a unified API, users can access an encrypted Key/Value store and network encryption-as-a-service, or generate AWS IAM/STS credentials, SQL/NoSQL databases, X.509 certificates, SSH credentials, and more.
https://teampass.net/
eamPass is a Passwords Manager dedicated for managing passwords in a collaborative way by sharing them among team members.
Teampass offers a large set of features permitting to manage your passwords and related data in an organized way in respect to the access rights defined for each users.
Teampass is an Open-Source free to use product distributed in respect with OpenSource GNU GPL-3.0.
In SAS Enterprise Guide it is not very easy to see the size and number of observations in datasets in the WORK-library.
The macro below looks in the DICTIONARY.TABLES and gets these info for the WORK-library. Be aware that it will not work for views, because it’s not doing and actual count of the SAS-datasets.
/********************************************************************************
Author :
Creation date :
Description : Gets info about datasets in the WORK-library.
Example : %countwork(print);
*********************************************************************************
Input
-----
&print : If not empty it will do a PROC PRINT of the dataset WORKDS created
by the macro.
*********************************************************************************
Output
------
WORKDS : Contains information about the datasets in the WORK-library.
********************************************************************************/
%macro CountWork(print);
proc sql;
create table workds as
select libname
, memname
, typemem
, nobs format=commax10.0
, filesize format=sizekmg.
, nvar
from dictionary.tables
where libname eq 'WORK'
order by nobs
;
quit;
%if &print. ne %then
%do;
proc print data=workds;
run;
%end;
%mend;