Copying value until end of file

[deleted_user]

Hello

I have a SAS datasets generated monthly to which I would like to include a new variable called FileDate. The filedate variable has a fixed value of end of month

Could anybody help me as to how I can :
- Copy this value of filedate till the end of file is reached or the last record of each monthly dataset.
- Roll up these datasets to a quarterly jumbo dataset.

Thanks for your time.

[Flip]

data xxx;
set monthly1;
RETAIN FILEDATE value;
...
...
...
Run;

proc append;
base=jumbo;
data = xxx;
run;
etc

[sbb]

To address your quarterly jumbo file request, you should have a "month ending" date, and with that you can derive a quarter-ending/starting date using the INTNX function in a DATA step assignment statement. Then depending on your SAS variables, you can use PROC SUMMARY / MEANS to generate your quarterly file using the quarter-ending date in your CLASS / BY statement.

Scott Barry
SBBWorks, Inc.