topic how to create a table with proc sql and setting a variable to a default value in SAS Enterprise Guide

how to create a table with proc sql and setting a variable to a default value

alepage — Thu, 09 Aug 2018 18:54:48 GMT

Hello,

I am using SAS EG 7.11 and I would like to create a table and setting some variables to a default value as below

Except this code is not working.

Does someone has already work on that issue.

Regards,

proc sql;

create table table1 (field1 num,

field2 num default 5557,

field3 num default 1337,

field4 date default today());

quit;

LinusH — Thu, 09 Aug 2018 19:03:59 GMT

SAS doesn't support default constraints (unfortunately).

If you have access to a SQL Server database you can use SQL pass through to specify these.

alepage — Thu, 09 Aug 2018 19:27:35 GMT

Could you please provide me an example how set default value using SQL pass through facility?

Thanks