I know this is a really old thread, but I finally have a use for this - I've got a SAS dataset with hundreds of hospital diagnosis codes, and I only want to keep the code fields that have at least one non-blank value (to save space). I was going to use Sridharma's %DROPMISS macro mentioned above (it's hundreds of lines of SAS code, but it works well). However, this option using the NLEVELS option (which I've never heard of) also works well, and it's MUCH shorter. I think I'll use that. Thanks! ... View more

The link given to the %COMBCHI macro is not being updated and still points to v1.0. There is an amended formula in version 2.1 of  Dr. Paul Allison's %COMBCHI macro from 2007 linked from the "Resources" section of his bio at https://statisticalhorizons.com/our-instructors/paul-allison/ ... View more

@Walker_cabay wrote: 'Big data' is the new science of understanding and predicting human behavior by studying large volumes of unstructured data. Big data is also known as 'predictive analytics'. This discussion was not about "Big Data" in the Data Science sense, but about dealing with big datasets in a technical SAS sense. ... View more

Hi @France,  So did this eventually work when you used the semicolon delimiter?  ... View more

I apologize. Thanks! ... View more

Your code works for me if I just add the out= option and get rid of the bit that says " data kchomes ; run;"   proc import datafile="KCHomes.txt" out=kchomes REPLACE; DELIMITER='09'x; GETNAMES=YES; run; ... View more

Hi, from @RandyStan original post it looks like a transaction cannot take place until there is both a buyer and seller ordernum present ,and it looks like the order numbers are cumulative. Assuming these to be true then should be able to match using the maximum order number in each row of the transaction data set.   Use the O & T datasets as starting points , but be sure that the ORNUM related variables are numeric.   Then data WANT; set O T ; if TYPE="T" then ORNUM=max(BUYORNUM,SELLORNUM); proc sort data=WANT; by ORNUM ; *clean up to remove the ordernum from transaction rows; data WANT; set WANT; if Type="T" then ORNUM=.; run;   ... View more

Hi Sandy10 "Kindly advise why the condition is always false ..."  Your condition is ... %if ((val=0) AND (Runstatus = 'F' or RUNSTATUS='N' )) %then %do; ... and this is always false because we have to use macro variables in a %if-%else statement, and cannot use data step variables. Val and Runstatus are both data step variables.   You could avoid using macros with the call execute; see @Kurt_Bremser maxim#11 and the sas blog "CALL EXECUTE made easy for SAS data-driven programming"       ... View more