There is a macro function named Nobs that uses SCL code to open and close the data set and return the Nobs(data). usage: %Let Nobs = %nobs(data=sashelp.class); %put note nobs:&Nobs; http://www.sascommunity.org/wiki/Macro_Nobs_function Ron Fehd  macro fun. maven ... View more

I see that proofreading has been posted and is probably the answer. fyi the data step where you create the macro variables with call symput can be replaced with macro assignment statements details and examples are on this page: http://www.sascommunity.org/wiki/Macro_Loops_with_Dates the SGF.paper: http://support.sas.com/resources/papers/proceedings13/343-2013.pdf Ron Fehd  dates maven ... View more

skip the contents %let Lib_Data = sashelp.class; PROC SQL; select Name             into :List_names separated by ' '           from   dictionary.columns           where  Libname eq "%upcase(%scan(&Lib_Data,1,.))"             and  Memname eq "%upcase(%scan(&Lib_Data,2,.))"             ;           quit; %put note: list_names = &List_names; ... View more

I have posted a general solution on SAS community wiki: http://www.sascommunity.org/wiki/Replacing_Missing_with_Mean ... View more

1. read in the data structure of your data. make an array of all the numeric variables 2. read in the single row of the Means data set whose variable have been autonamed so that Mean is the prefix of each variable. The issues are getting the names of the variables aligned with their means. so that the array references are correct. alternately you can use sql to extract the list of variable and feed that list to Summary which you can then use in the array statements. DATA Update;*todo: (drop = Mean:); *get the data structure for the array Valu; if 0 then set Library.Mydata; array Valu(*) _numeric_; *read the Means data set -- one row -- into the set of values for updating; set Means; array Mean(*); do until(EndoFile);    set Library.MyData end = EndoFile;    do i = 1 to dim(Valu);       if Valu(I) eq . then Valu(I) = Mean(I);       end;    output;    end; stop; run; PROC SQL; describe table &syslast;            quit; Ron Fehd  matching maven ... View more

Do you have a list of data sets to process? http://www.sascommunity.org/wiki/Making_Lists ... View more

sleeping on a problem always help me realize easier ways to do things keyword: wallpaper code Here is my this.morning's version of a solution using temporary arrays to replace the wallpaper array Country{*}$10 _temporary_      ('bolivie'       'chypre'       'cyprus'       'équateur'       'equateur'       'éthiopie'       'ethiopie'       'indo'       'kenya'       'nigeria'       'nigéria'       'pakistan'       'sao'       'sri lanka'       'tanzanie'       'thai'       'tailand'       'turquie'       'viet'       'yemen'       'yémen'       ); Have_Country = 0; do I = 1 to dim(Country);    Have_Country = Have_Country                or index(lowcase(strip(objet)),Have_Country(I));    end; if Have_Country    and index(lowcase(strip(objet)),'acc') then do;    count_gafi_acc=count_gafi_acc+1;    switch = "y";    end; ... View more