Hello,
Here's an example of the SQL code I am dealing with. (The variable name has been changed for security purpose)
CREATE TABLE "test"
( "var1" NUMBER(12,0) NOT NULL ENABLE,
"var2" NUMBER(2,0) NOT NULL ENABLE,
"var3" NUMBER(10,0),
"var4" NUMBER(3,0),
"var5" NUMBER(15,2),
"var6" NUMBER(15,2),
"var7" NUMBER(15,2),
);
I have consulted the following page: http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#n0v236a0ti4nmen1mm...
as I have understood from my reading, I have transformed this code into SAS code as below:
Proc Sql;
CREATE TABLE test
( var1 numeric format = 12.0 not null,
var2 numeric format =2.0 NOT NULL,
var3 numeric format =10.0,
var4 numeric format =3.0,
var5 numeric format =15.2,
var6 numeric format =15.2,
var7 numeric format =15.2
);
Quit;
Is it the similar SAS format or close to the SQL format?
Thanks for your help