Hi piyushdwij,
As LinusH already mentioned you may have an I/O bottleneck. Does laptop have seperate drives or paritions to manage your permanent and temporary SAS datasets? Having seperate disks for permanent and temporary datasets can help speed up the processing.
In addition if you are accessing an MS SQL Server (presumably not on the same machine that you have SAS on) and you are submitting SQL code, why not submit explicit MS SQL server code and have SQL server do the processing for you?
Without seing your code i don't think there is much more that i can add.
One final thought. This sounds more like a data management question so you may want to post this to: https://communities.sas.com/t5/Data-Management/ct-p/data_management
Cheers, Simon
... View more
