SAS Support Communities

LinusH · ‎09-14-2020

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.

ChrisNZ · ‎06-29-2020

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

Kurt_Bremser · ‎06-04-2019

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).

SvenWagner · ‎02-11-2019

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. 🙂

SvenWagner · ‎10-11-2018

Thanks!

SvenWagner · ‎10-10-2018

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.

Online Status	Offline
Date Last Visited	‎07-08-2020 07:41 AM

SAS Support Communities

Re: Troubles accessing DB2

Troubles accessing DB2

Re: Reading Parquet-Files in SAS 9.4

Re: Reading Parquet-Files in SAS 9.4

Reading Parquet-Files in SAS 9.4

PROC SQL & MAX

Re: Restore SPDE Data Sets

Restore SPDE Data Sets

Re: PROC FedSQL with stochastic results

Re: Erratic proc fedsql behaviour

Re: Restore SPDE Data Sets

Re: Reading Parquet-Files in SAS 9.4

Re: Troubles accessing DB2

Re: PROC SQL & MAX

Re: Restore SPDE Data Sets

Re: PROC FedSQL with stochastic results

Re: Erratic proc fedsql behaviour

Follow Us

What is...