The ALTER TABLE statement specifies EMPLOYEES as the table to alter.
This paper describes what would happen if one would have permission to CREATE an MS SQL table from PROC SQL, including the automatic conversion of DATE, TIME and DATETIME (and DOLLAR into MONEY) fields, based on their date and time related formats, via the SAS/ACCESS engine.
Of course, when reading from an MS SQL database table via the ODBC engine into SAS, for which one has read permission, SAS provides automatic date and time conversions.
The paper discusses the code to explicitly convert date and time fields by way of their associated DATE, TIME and DATETIME formats (like SAS does).
For example, each iteration of the following DATA step increments the value th power.
As mentioned in the previous section, you can also use the BY option to increment the counter by non-unit values and by negative values.
Both of them have credit_id, loan_id and Date field.