@s_lassen Thanks for your response! Answers to question 1 and 2 makes sense. Re: 3, I think this is Truven pharmacy claims data. data __drugs;
set &do i=1 %to %sysfunc (countw (&pharm_files.));
%let filename = %scan (&pharm_files., &i));
raw.&filename.
%end;
;
/* This was subsequently cleaned (i.e. removed negative values, etc) and
made into collapse_drugs_2;
The purpose of the code in the OP was "get the mode of daysupp per NDC"
*/ I added in the comments. Not sure what else I can provide? I don't even think I have access to the actual data, though I do have the data dictionary + the standard data summary that Truven gives? Thanks!!
... View more
