we faced one issue when moving from 14 to 15. Please check the topic Impact of ROW_NUMBER in Teradata 15 versus Teradata 14 on SAS tables in below article   http://www.mwsug.org/proceedings/2016/SA/MWSUG-2016-SA11.pdf   ... View more

I have not. I use Teradata 15 with SAS. Did you face any issues ... View more

I do not completly understand the query. But most of it should work in Proc SQL too. Except few changes where you mention date columns and at is not null.   Activity_Date >= 'mm/dd/yyyy' to Activity_Date >= 'ddmmmyyyy'd  example '21jul2017'd   is not null to is not missing       ... View more

I am getting exact answer you want by running your query data TableA; input PatientID InitialVisit:mmddyy10.; format InitialVisit mmddyy10.; datalines; 1 1/1/2016 2 3/12/2016 3 4/15/2016 ; data tableb; infile datalines truncover; input MemberID Date:mmddyy10.; format date mmddyy10.; datalines; 1 12/14/2015 1 1/1/2016 1 2/25/2016 2 3/12/2016 2 4/4/2016 2 7/1/2016 3 11/7/2015 3 12/18/2015 3 4/15/2016 ; proc sql; create table test as select a.* ,b.Date from TableA as a left join TableB as b on a.PatientID=b.MemberID and date>InitialVisit ;quit; ... View more

you can do this by using proc format.   A similar but not exactly same logic is given in the article below.   http://blogs.sas.com/content/iml/2016/08/08/sas-formats-bin-numerical-variables.html ... View more

something like this hsould work for your scenario proc sql; create table new as select a.hospid, a.year, case when a.hospid=b.hospid and a.ratio is missing then b.ratio *1.04 else a.ratio end as ratio from (select hospid, year, ratio from old)a left join (select distinct hospid, ratio from old where ratio is not missing)b on a.hospid =b.hospid; ;   ... View more

your row number logic is helping you to insert acurately but as you have same name as macrovariable, it is overwritten and Put is picking the last value. To find each value better option is to use do  i= 1 %to &count and use &&nputfile&i. ... View more

proc sort data=have; by customeraccount date; run; data want; set have; by CustomerAccount; if InterestRate -lag(interestrate) ne 0; run; proc sql; select max(date) as date format= ddmmyy10., customeraccount, max(previousrate) as previousrate, max(newrate) as newrate from (select max(date) as date format =ddmmyy10., customeraccount, case when date =min(date) then interestrate end as previousrate, case when date =max(date) then interestrate end as newrate from want group by customeraccount) group by customeraccount; something like this   ... View more