Does SAS have the ability to create a view (or query) like you can create within a typical Database application (SQL Server, Access, Oralce, ...)?
I have multiple sas datasets all sorted with the same ID that contain similar data (claim_count, total_spend, etc..), but the fields within each dataset reflects the name of the dataset:
dataset1 = pd1_retail
fields(ID, pd1_retail_claim_cnt, pd1_retail_total_spend)
dataset2 = pd1_mail
fields(ID, pd1_mail_claim_cnt, pd1_mail_total_spend)
dataset3 = pd2_retail
fields(ID, pd2_retail_claim_cnt, pd2_retail_total_spend)dataset4 = pd2_mail
fields(ID, pd2_mail_claim_cnt, pd2_mail_total_spend)
Each of these datasets actually contains many more fields and up to 20 million observations, making each individual file rather large. What I would like to do is create an object that merges the 4 dataset together without physically creating a new dataset. This will allow me to look at the files individually as well as collectively without the increased overhead of physically storing the data in two different datasets.
Any ideas???????????
I have multiple sas datasets all sorted with the same ID that contain similar data (claim_count, total_spend, etc..), but the fields within each dataset reflects the name of the dataset:
dataset1 = pd1_retail
fields(ID, pd1_retail_claim_cnt, pd1_retail_total_spend)
dataset2 = pd1_mail
fields(ID, pd1_mail_claim_cnt, pd1_mail_total_spend)
dataset3 = pd2_retail
fields(ID, pd2_retail_claim_cnt, pd2_retail_total_spend)dataset4 = pd2_mail
fields(ID, pd2_mail_claim_cnt, pd2_mail_total_spend)
Each of these datasets actually contains many more fields and up to 20 million observations, making each individual file rather large. What I would like to do is create an object that merges the 4 dataset together without physically creating a new dataset. This will allow me to look at the files individually as well as collectively without the increased overhead of physically storing the data in two different datasets.
Any ideas???????????