PROC SQL; CONNECT TO TERADATA(DATABASE=<dbname> USER=<user> PASSWORD=<pwd>); CREATE TABLE temp AS SELECT * FROM CONNECTION TO TERADATA (SELECT * from <table_name> sample 0 ) ; DISCONNECT FROM TERADATA; QUIT; Try this if you are using SQL Pass through to teradata ... View more

You can also use the automatic macro variable SQLOBS to check if your query returned any observations. Also be careful to distinguish between where you want macro functions (to test text and generate code) and actual SAS functions and SAS statements.  For example you were using macro function %UPCASE() to turn the string name into the string NAME instead of the SAS function UPCASE() to operate on the value of the variable named NAME.  You enclosed a block of pure macro code inside of a data _null_ step for no reason since the macro code did not generate any statements that would run in that data step. %macro mcr_test(dst_term); %local nm n; proc sql noprint; select name into :nm trimmed from sample_name where upcase(name)=%upcase("&dst_term") ; %let n=&sqlobs; quit; data _null_; %if &n %then %do; put "Found name=&nm"; %end; %else %do; put "Did not find name= &dst_term"; %end; run; %mend; %mcr_test(David); %mcr_test(ANDY);  Results: 160 %mcr_test(David); NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Found name=DAVID NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds 161 %mcr_test(ANDY); NOTE: No rows were selected. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Did not find name= ANDY NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.00 seconds ... View more

@nbonda wrote: Thank you. It works. I never knew there is a informat like trailsgn. IIRC, it was added with version 9. ... View more

So Teradata fixed one problem (count(*) overflowing) and introduced a new one (non-standard data type).   Things haven't chnaged much in the computer industry in the last 35 years.  My first job out of college I was implementing PCOs (program change orders).  Most of them were to fix issues caused by earlier PCOs. ... View more