The following are popular keywords being used in SAS financial analytics. Given here complete statements list for your reference:
In the SAS format applies to conversion from one currency to another currency.
put amount dollar10.2;
Here, the numeric amount converted to dollar amount. The result is as follows:
>sas input or infile
Use the INPUT statement to read raw data from an external file or in-stream data. If your data are stored in an external file, you can specify the file in an INFILE statement. The INFILE statement must execute before the INPUT statement that reads the data records.
The PUT statement uses an output buffer and writes output lines to an external location, the SAS log, or your monitor. The OUTPUT statement uses the program data vector and writes observations to a SAS data set.
LIBNAME libref ‘SAS-library‘; An engine specification is usually not necessary. If the situation is ambiguous, SAS uses the setting of the ENGINE= system option to determine the default engine. If all data sets in the library are associated with a single engine, then SAS uses that engine as the default. In either situation, you can override the default by specifying another engine with the ENGINE= system option:
The IMPORT procedure reads external data and writes the data to a SAS data set.
<OUT>=<libref.SAS data-set-name> <SAS data-set-option(s)>
>proc export sas
It exports data from SAS dataset to external file
DATA=<libref.>SAS data-set <(SAS data-set-options)>
OUTFILE=”filename” | OUTTABLE=”tablename“
>>sas proc format
The FORMAT procedure enables you to define your own informats and formats for variables. In addition, you can print the parts of a catalog that contain informats or formats, store descriptions of informats or formats in a SAS data set, and use a SAS data set to create informats or formats.
specifies whether PROC SUMMARY displays the descriptive statistics. By default, PROC SUMMARY produces no display output, but PROC MEANS does produce display output.
The DATALINES statement is the last statement in the DATA step and immediately precedes the first data line. Use a null statement (a single semicolon) to indicate the end of the input data.
You can use only one DATALINES statement in a DATA step. Use separate DATA steps to enter multiple sets of data.
>>sas data step
Recall that SAS programs consist of two main blocks of code: the data step and the procedure (proc) step. The data step is where data is created, imported, modified, merged, or calculated.
- SAS terms to know before you write your first macro
- SAS statements handy list always need
- SAS splitting input file logic you need
- SAS files real use awesome quiz