Some tips: Don't use monotonic(), its not production. Don't code in uppercase, its like shouting. See here for a better solution: https://communities.sas.com/t5/SAS-Programming/Calculate-the-highest-two-records-of-Metrc2-for-each-date/m-p/497108/highlight/true#M131644   As for your code I can't check, post the exact log of the run.  Nothing jumps out at me, but without something to check against...   ... View more

Its possible, you could just put all the dsX on the data line, or you could be more complicated with: data _null_; set sashelp.vtable (where=(libname="SASHELP" and memname="CLASS")); do i=1 to nobs; call execute(cats('data ds',put(i,best.),'; set sashelp.class; run;')); end; run; At the end of the day its pointless and a question like that would put me off the role.   ** Updated to be dynamic with number of observations. ... View more

To continue with that approach you would need two datasteps, one to calculate the variable, the second to do the lag.  You cannot use lag() and variables which are not fixed.  There are other ways, such as retain, and merging on obs=obs+1.  However without test data in the form of a datastep we cannot provide anything. ... View more

Sorry, its not clear what you mean.  Do you want 19 copies of the same dataset, or 19 datasets with one record in each?  Either way it really does not sound like th ebest way to go about doing whatever it is you want to do.  SAS has inbuilt by group processing, so printing data by a variable and doing sums by a variable is far simpler using that. ... View more

Something like: data want; set have; if lengthn(comrpess(name," ","d"))=0 then name_derived=compress(name," ","kd"); run; Not tested as you have not provided test data in the form of a datastep (and not here to type in test data!). What this does is check the length when numbers are removed, if there is nothing but numbers, then keep only them.  Compress is described in the docs: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212246.htm ... View more

Post test data of both datasets in the form of a datastep: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712   And show what you expect from them.   I am pretty certain however that there is a much better method than the update you present here, a simple merge on ID would be far more efficient. ... View more

Are there always exactly 6 months of data or would there be some sort of rolling window?  I would suggest creating a change from previous result flag, then you can simply sum() the flags based on a 6 month window, perhaps something like: data have; set rawdata; by id; if not first.id and score ne lag(score) then chg_flg=1; run; In this way you can say sum chg_flg over start of period to end of period = changes in the 6 months. ... View more

I am a biit confused about why you are doing it this way in the first place, its a pretty inneficient method.  Also, I would highly recommend a review of naming conventions! Now onto the why.  If you look at the all dataset you will see that there are rows where tit1 is missing, tit2 is missing etc.  This is because each one is only defined in the datastep it appears in, so does not cross across all datasets.  When the put to file happens is prints the empty space because you have asked it to with: put tit1 tit2 tit3 tit4 var1; on the first data part of all tit1 gets printed, on the second, missing gets printed as tit1 is empty, then tit2 gets printed, on the third, tit1 and tit2 are both printed as space, then tit3 etc.  ... View more

That is one of the things I was going to ask also.  In clinical trials is common to use questionnaires, and so CDISC already have a datastructure for such a thing.  Normalised it contains a variable for questionnaire, quesition, character result, numeric result. This question really highlights why transposed data is really not a good storage solution.  It takes up far more room (as all the missings are there as well), and means a recoding to get a different structure to work further with.   ... View more

And what software are you using?  This is a general programming board, and I have never seen titles created like that.  Do you use DI or something?  In terms of SAS code: tit1=strip("**************** NOTIF01 *****************************"); However, its likely spaces are coming in from somewhere else.  So maybe put a newline in. ... View more

Well, coding ALL IN UPPERCASE is not a smart way to start as I cannot read that shouting.     The question however has been asked many times, just the other day for instance: https://communities.sas.com/t5/SAS-Programming/Return-count-of-0-in-a-Group-By-SQL-Statement/m-p/539644#M148730 ... View more