Note that the value of LIBNAME will always be in uppercase in the dictionary tables.  So you would need libname = "SAPENG" ... View more

You granted me the "correct answer" before I deliver a correct one. The previous one only works if all of your variables are in the format of /bic/, you would need more fire power than scan() function if you want to ignore those not in literals. data have; input '/bic/var1'n '/bic/var2'n var3; cards; 1 2 3 ; proc sql; select cats("'",name,"'N","=", prxchange('s/\/bic\///io',-1,name)) into :ren separated by ' ' from dictionary.columns         where LIBNAME='WORK' AND MEMNAME='HAVE'; QUIT; DATA WANT; SET HAVE; RENAME &ren; RUN; Regards, Haikuo ... View more

Thank you. ... View more

You are mostly there. SAS interprets non-missing values other than 0 as TRUE. What you also need to know is that when it evaluates a logic expression, such as (dart_new=1), it will return 1 when true and 0 otherwise. So if you code SUM( (dart_new=1) ) in SQL statement then you are asking to sum the results of that logic expression. So basically you are counting the number of rows where dart_new=1. ... View more

Thank you. All that's missing is to add an "as" to this line: create table fall_all ... View more

Thank you. ... View more

It wont be to hard to create the "missing" cells.  I think that is easier that using CALL DEFINE espically on an across variable.  Show some data. ... View more

Or try this: data _null_; input var$40.; year=year(input(var,ANYDTDTE32.)); put year=; cards; 9/6/2013 11:16:13 AM 8/2/1994 4:18:06 PM 11/15/1995 3:54:36 PM ; Haikuo ... View more