Which version of Visual Analytics are you using? And what are you referring to as the "landing" page?  ... View more

It is an external database, PostgresSQl database ... View more

Check what encoding your SAS session is using. It will probably work better to run SAS using UTF-8, but that might depend on your Postgres settings.   Note that labels are not going to be written into the foreign database so going to the trouble of trying to define them in your code is a waste of time for that destination.   You might try determining which observation and which variable is the one that is actually triggering the error.  Should not be that hard using a simple binary search strategy.  First eliminate half the variables and if that works then the variable is one in the other half.  Repeat until you figure out which variable.  Same for observations.  Try loading the first half of the observations if that works the problem is in something in the second half. ... View more

The documentation does not mention quotes around the "PROC S3 Region Values," that's why I think they should be omitted. It says, however, "You might need to activate a region for your account if it does not appear in your list of regions. See your AWS documentation for more information." Maybe this is the reason why afcapetown is not (yet) available to your system. Another reason might be the SAS release: In my offline help file (I'm using SAS 9.4M5) there's no African region listed at all, i.e., afcapetown seems to be a recent addition in 9.4M6 or later.   Sorry, this is pretty much all I can contribute to this thread, having never used PROC S3 or the AWS S3 environment. ... View more

Hi LinusH,   I've registered the tables into SAS, yes. I've also tried using the extract transformation which just give an error message of  "there are no unused destinations" for both the libraries it's reading from and pushing the data to. I've tried the table loader as well, the data contains about a million or more rows.   ... View more

Hi, what version of DI Stiodo do you use? What other SAS products do you have at hand? Viya?   As a general note - if you are unsure of the concept, try to make it wotk outside DI Stio first. Then try to adopt it in DI Studio.   https://communities.sas.com/t5/SAS-Communities-Library/Getting-Started-Write-SAS-data-to-a-Parquet-file-on-Amazon-S3/ta-p/613322   ... View more