1) You are right. The reason is that currently the code does not have any loops and the date is random date just to do testing. I will put all of them inside loop (or just do by as others suggested but should think about it more). Because I'm doing it cloud (SAS studio) the organization does not give me much space (overall something like 5GB+scratch shared folder). 2)I agree. I should combine them. Part of that is lack of knowledge. 3)correct. All of those will be linked to loop's changing variable 4) By date conversions you mean generating year variables? That's for merging purpose with other datasets and aggregating later
... View more