Just want to add, if you create a csv file, that hasn't to be moved to your local SAS server. You can use FILENAME HADOOP to access the file in hdfs. PROC HADOOP let you submit hdfs commands or exxecute pig programs which can come in handy when converting the parquet file. None of these require a separate SAS/ACCESS licence. ... View more

It's not about the code it's about the data. Also did your see this page about SQLSTATE 01S07? https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0058997.html ... View more

When you use max() (and other such functions, like min() or avg()) with more than one argument, then it works "horizontally" within the current observation. With only one column name as parameter, it turns into a summary function that works "vertically" for the group (or the whole dataset). ... View more

Obviously, it is possible to spare the path statments for data files, indexes and metadata. If you do so, there is no path entry within the mdf-files and you can move the directory using Windows drag & drop. Certainly not what originally is intended by SPDE, but it works. 🙂 ... View more

Thanks! ... View more

Thanks, but unfortunately, your proposal does not fix the problem in my case. Please, would you take a look at my post https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/td-p/501773 ? The problem is the same with und without using SPDE. ... View more