To help you develop
content for a new standard or study, SAS provides these macros:
-
%CSTUTILSQLCOLUMNDEFINITION
-
-
%CSTUTILFINDFIXEXTDASCIICHARS
The %CSTUTILSQLCOLUMNDEFINITION
and %CSTUTILSQLGENERATETABLE macros deconstruct a SAS data set and
create code for SAS SQL, ANSI SQL, or Oracle SQL. You then modify
the resulting code to fit your needs and submit it as needed.
The %CSTUTILFINDFIXEXTDASCIICHARS
macro scans a SAS data set and replaces extended ASCII characters
with characters that are acceptable to SAS.
For more detailed information
about these macros, see the SAS Clinical Standards Toolkit: Macro API Documentation.