Just in case anybody else comes here and there is no solution..
According to the documentation, the data source should be set to the folder where the sas7bdat file(s) reside.
The provider treats the folder as the “database” and each file is a “table” in the “database”
"Provider=sas.LocalProvider; Data Source=C:\SASInputFiles\"
Each file is then treated as a table..
Hope this helps!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.