what is criteria1 2 3... ... View more

Hi it should be in quotes. "CRSP" ... View more

Hi , This says that if the step is reading the first observation in datastep then hash variable is decalred and properties are set including the key variabels and data variables. ... View more

Hi , You are using macro if condition for data variabl check.Please use data step if statement. Data temf; set trans; per_miss = nomiss/(nomiss+nmiss); ind_name = trim(_name_)||'_in'; ind_name = trim(_name_)||'_in'; medianstr = put(median,3.); run; data temf; set temf; if per_miss  > 0.50 then do; indicator = trim(ind_name)||'=('||trim(_name_)||'=.)'; run; end; else if 0.10 <per_miss <= 0.50 then do; indicator = trim(ind_name)||'='||trim(medianstr); run; end; else do; indicator = 'none'; run; end; ... View more

I guesss notes doesn't have any issues howevrr Warnings might. Actually the columns specified in the warnings may have different lengths.you just need to check the output dataset and input datasets and make the input columns of same length. Thanks ... View more

libname abc "YOURPATH"; proc sql noprint;   select memname into : names separated by ' '      from dictionary.tables              where upcase(memname) like "DAILYRTN_20%" and libname=abc; quit; %put &names; data want;    set &names; run; ... View more

proc sql noprint;   select memname into : names separated by ' '      from dictionary.tables              where upcase(memname) like "DAILYRTN_20%"; /* have to be capital letters */ quit; %put &names; data want;    set &names; run; ... View more

you can use scan function. ... View more

Very Tough i guess. Not sure whether it is possible or not as well. ... View more