Hi, Is there a way to convert the below code to work in SAS? Specifically I am looking for alternative options for "decode", "sign", "to_number" & "to_char" functions used in the below code. Any help on this is highly appreciated. proc sql; create table test1 as select a.var1, count(c.var2) as var2 format=comma20.2, sum(c.var3) as var3 format=comma20.2, sum(a.var4) as var4 format=comma20.2, decode( c.var5,14,a.var6, decode( sign(to_number( to_char( d.var7,'yyyymmdd') )),2,500, a.var6)) from db.table1 as a, db.table2 as b, db.table3 as c, db.table4 as d where a.key1 = d.key1 and b.key2 = a.key2 and a.key3 = c.key3 and b.date is null group by a.var1, decode( c.var5,14,a.var6, decode( sign(to_number( to_char( d.var7,'yyyymmdd') )),2,500, a.var6)) order by 1 asc; quit; Thanks
... View more
