Crosstab with zero counts and counts of distinct values proc freq and sql %let pgm=utl-crosstab-with-zero-counts-and-counts-of-distinct-values-wpe_r_sql; ...
SET @DWHTABLE = ('select DISTINCT Schemaname+' + '''.''' + '+Tablename AS COL from AUDIT.SP_CONTROL_TABLE where Tablename=' + '''' + @Tablename + '''' + ' and ...
The following examples use the SQL procedure to query, update, and create DBMS tables. Querying a DBMS Table This example uses the SQL procedure to query the ORACLE table PAYROLL. The PROC SQL query ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback