Hello everyone, I am new to SAS for my doctorate program and using proc sql, I am needing to merge the following data sets: ep_provider_paid_ehr National_downloadable_file zip_to_cbsa All three are csv files that have been imported into SAS and the file names changed to the respective names above in my libraries -> work from import. This is the code that has been given, but it keeps erroring out and I cannot figure out why after multiple attempts, google, youtube, etc: proc sql; SELECT DISTINCT national_downloadable_file.group_practice_PAC_id, national_downloadable_file.number_of_group_practice_members, ep_provider_paid_ehr.provider_npi, zip_to_cbsa.cbsa FROM national_downloadable_file JOIN provider_intersect ON national_downloadable_file.national_downloadable_file_id = provider_intersect.national_downloadable_file_id LEFT JOIN ep_provider_paid_ehr ON provider_intersect.ep_provider_paid_ehr_id = ep_provider_paid_ehr.ep_provider_paid_ehr_id JOIN zipcode_table ON national_downloadable_file.zipcode = zipcode_table.zipcode LEFT JOIN zip_to_cbsa ON zipcode_table.zipcode = zip_to_cbsa.zipcode WHERE national_downloadable_file.group_practice_PAC_id<>'NA'; Here is the error that keeps occurring: ERROR: File WORK.PROVIDER_INTERSECT.DATA does not exist. ERROR: File WORK.ZIPCODE_TABLE.DATA does not exist. Any help would be greatly appreciated. Thanks!
... View more