Just to offer some more explanation (and a correction). Since you mentioned being new to SAS and started out using EG I will assume that you SAS coding is not a well defined skill at this point. The code that provided should work fine if you fit it into your program flow with a programming node. one correction needs to be made in that you want to count non blank variable entries but the missing function that is used looks for missing values and returns 1 if the variable is missing, so those two parts of the code should look for =0 and not =1. The two array statements lists the variables you want the loop to look through. The way the code is written right now is one array looks through all numeric variables in the dataset and the other looks at all character variables in the dataset. The two do loops (do i ... end; do j ...end;), basically tell SAS to run through the array evaluating the missing function and if a the criteria is met increment the count variable by 1, Notice that count is set to 0 at the beginning of the data step so each observation begins with a default count of 0. Hope this helps! EJ ... View more

Great explanation and tips ! The evil orphaned quotation mark has drove me to bang my head against the wall with some of my programs! EJ ... View more

I agree without seeing the code we can only offer general help. EJ ... View more

Did you resubmit the macro code to update the compiled macro code available to SAS? That is what is sounds like to me. If you change code in the macro you cant just run the macro call again you must submit the macro definition so SAS can update to the changes made. EJ ... View more

I think you may be miss using terms. To me it sounds like you are setting up macro variables and need a way to selective set other macro variables. To do this you should be able to write a real sas macro that will do this. See if the following works: %macro set; %if &align_status = 'ALIGNED' %then %do;      %let year_add = (2013); %end;      %else %do;           %let year_add = (2012,2013);      %end; %mend set; %set; %put &align_status  &year_add; ... View more

gave you a great way to do it with hash objects. Not knowing if the posted data accurately reflects your data, I would also suggest upcase your variables to maximize the match rate. This might not be necessary if all the data is all from the same original source. EJ ... View more