Why SAS, Proc SQL does not throw an error when I create existing tables

Question

SAS Starter here.

INTRO: An error occurs in SQL Server Management Studio when trying to create an existing object / table. So the solution is to first DROP table and then CREATE.

So, how can I write something like this in SAS ... (pretending to be an example table)

PROC SQL;
    CREATE TABLE Example AS
        SELECT *
        FROM Work.Test;
QUIT;

Question: Although the Example object / table already exists, an error does not occur. Does anyone know why SAS or SQL Server Management Studio are different from each other?

Answer 1

SAS OPTION REPLACE, SAS, .

, OPTION NOREPLACE. , - , work ( ).

, ( -), , , , . SAS ( , PROC SQL); , SQL Server ( 1960- PL/1 PL/2). SQL Server ; SAS , SAS , .