Hey, I am trying to do something similar i.e. create a report with the mean of a variable (price) in the title but I wanted to know how would you create a macro variable for the mean to reference in the title without the proc sql step. would it be easier to do with proc means or proc report?
... View more
In the first loop, counter c counts the number of rows with the same id and series number, i.e. the length of the sequence. In the second loop, going over exactly the same sequence, the rows are output if the sequence length is >= 3.
... View more
Thanks a lot. Made those changes (adding i.id and j.id in the coalesce and adding order by) and the output looks much better. Only one question, why idno 5 is coming up twice ?
... View more
SAS files are text files so if those are actually files, you can open them with a text editor and then paste it into SAS UE. You'll have to move the data though. There is a small chance those are just pictures though.
Also, whomever decided to save code/data that way needs to be smacked.
... View more
