SAS Servers In a Glance : SAS Application Server (SASApp)

Hi Guys,

As we are learning SAS DI Studio, So it is a high time to keep an eye on SAS Servers. We can simply say that we have a list of SAS Servers but here we would put spot light on some important servers only.

SAS Application Server/s : We can easily say that this server is a bucket of all important SAS server. If we would talk with respect to SAS DI Studio, when administrator installs SAS intelligence platform, he define a metadata object which represents SAS server tier . For SMC (SAS Management Console), such type of object is known as SAS Application Server. By default SAS Application Server is named as SASApp.

SASApp is not an actual server while it contains a set of actual servers. In other word, we can say that SASApp is a logical container of actual servers.

 Usually SAS Application Server contains the following servers:

1. SAS Workspace Server: It executes SAS code, it means workspace server reads and writes data. In SAS DI Studio, when we submit any ETL job for execution, SAS DIS generates SAS code to perform execution and submits the SAS code to Workspace Server for processing.

2. Pooled Workspace Server:  This SAS Server automatically use pooling and load balancing.

3. Stored Process Server:  It is also a great time to discuss Stored Processes. Stored processes are SAS programs which are stored and can be executed by client application. These processes are to perform complex work like: to analyze data and creating reports, and then publish / return the results to the client / channel or repository.

So Stored Process Server submits stored processes by SAS for execution.

4. SAS OLAP Server: It creates cubes and processes queries against cubes. OLAP Server processes the data by using multidimensional expressions language (MDX).

5. SAS / CONNECT Server: This server is to move data between client and server machine or we can say that it enables the client to execute code on a remote host. It can also be used for interactive access to remote libraries.

6. SAS Grid Server: This server is to enable platform for LSF to start SAS/CONNECT servers on a SAS compute grid, so that it could execute grid enabled jobs which are created in SAS DI Studio and SAS Enterprise Miner.

7. SAS/SHARE Server:  It enables parallel access of sever libraries from multiple users.

8. SAS Scalable Performance Data (SPD) Server: it enables concurrent processing of large data stores, Data backup and to restore utilities as well as some tuning options.

What Is The Difference Between SAS Character Functions INDEX And INDEXC

In my previous post related to, how to read mixture dates from raw data in sas, I have used INDEXC function so it’s a good time to define INDEX and INDEXC function in SAS with difference in both.

link to previous post :How To Read Different Formats Of Dates In SAS (Reading Mixture DatesFrom Raw Data In SAS )

INDEX Function : It looks for a character expression in a character string and returns the position of string’s first character for the first position. In short, it scans the string and provides the location of sub-string.

INDEXC Function : It looks for a expression for any of the given characters and returns the position of that expression. In Short, It scans the string and provides the location of sub-string based on list of expression in sub-string.

Explanation : Suppose we have a character string “UmAShankerSaini” and we are looking for ‘ain’.

Once we are running INDEX function, then it would search for complete string like ‘ain’ and it would return the position of it, which is 12.

Once we are running INDEXC function, then it would make a list of all letters in specified string and returns the position of any character for the first instance of any of them. So when it comes to lowercase ‘a’ at the sixth character, it returns the position value which is 6.  In case of uppercase ‘A’, it would return 3.

Data DSN;
Name='UmAShankerSaini';
Exp='ain';
Indx=Index(Name,Exp);
IndxC=INDEXC(Name,Exp);
Put Indx= / Indxc = ;
Run;

How To Read Different Formats Of Dates In SAS (Reading Mixture Dates From Raw Data In SAS)

Today we are going to discuss about, how to read dates in SAS, which are in multiple format in raw data.

Suppose we have dates in raw data which contains multiple types of separators and formats.

We would read such type of mixed date data and make all dates in one required format. We have two master blaster functions to perform this task :INDEXC and WORDDATE

SAS Code would be as follows:

Data DSN;

Input @1 Dummy_Dates $15.;

If INDEXC (Dummy_Dates,'-/:') NE 0

Then Date=Input(Dummy_Dates,MMDDYY10.);

Else Date=Input(Dummy_Dates,Date9.);

Format Date WORDDATE.;

Drop Dummy_Dates;

Cards;

10/07/2014

10MAY1984

8-12-1999

1:09:60

;
Run;

For more on INDEXC : What Is The Difference Between SAS Character Functions INDEX And INDEXC