https://communities.sas.com/t5/Developers/To-get-data-from-a-variable-in-multiple-files-And-then-create-an/m-p/783487#M1337 Hi, I need to get monthly outstanding and payment balance from monthly files. And then need to create a series to check last balance and last payment made ever in any month. How do I do this?<BR />I am thinking of appending data first. Please suggest. Wed, 01 Dec 2021 23:30:20 GMT Prerna20 2021-12-01T23:30:20Z https://communities.sas.com/t5/Developers/To-get-data-from-a-variable-in-multiple-files-And-then-create-an/m-p/783487#M1337 Hi, I need to get monthly outstanding and payment balance from monthly files. And then need to create a series to check last balance and last payment made ever in any month. How do I do this?<BR />I am thinking of appending data first. Please suggest. Wed, 01 Dec 2021 23:30:20 GMT https://communities.sas.com/t5/Developers/To-get-data-from-a-variable-in-multiple-files-And-then-create-an/m-p/783487#M1337 Prerna20 2021-12-01T23:30:20Z https://communities.sas.com/t5/Developers/To-get-data-from-a-variable-in-multiple-files-And-then-create-an/m-p/783646#M1340 <P>Please provide us with sample program and sample data next time. What you are asking is a complicated programming task and we would need that info to be able to guide you in the right direction. We at the community site are here to help you out. One suggestion I normally have is, make sure you consider taking SAS training courses. These SAS training courses give you the tools to tackle any project back at work. If you like , i can assess your training needs and give you some course suggestions.&nbsp;</P> Thu, 02 Dec 2021 15:15:02 GMT https://communities.sas.com/t5/Developers/To-get-data-from-a-variable-in-multiple-files-And-then-create-an/m-p/783646#M1340 CarmineVerrell 2021-12-02T15:15:02Z