topic Re: Transferring datasets from Dropbox to SAS 9.4 in SAS Data Management

Transferring datasets from Dropbox to SAS 9.4

arsy1198 — Mon, 03 May 2021 17:28:49 GMT

Hello! First time poster here. So I'm working with SAS 9.4 and I'm trying to open datasets downloaded from Dropbox directly into my SAS software. However, when I try to open this download, I receive an error and a blank dataset. Is there any way to download datasets from a different server (i.e., Dropbox) into SAS 9.4 without having to go through the associated Excel file first? I'm working in a team and we're trying to find a way to directly edit the dataset without having to edit the Excel file first then having to import it to update the dataset. Thank you!

Re: Transferring datasets from Dropbox to SAS 9.4

sbxkoenk — Mon, 03 May 2021 17:58:04 GMT

Hello,

Welcome to the SAS communities 😉.

You have posted in the data management SOLUTION board.

But are you using a SAS data management solution

like Data Integration Studio or DataFlux or a solution for Data Quality or ...?

I have the impression you are just using 'plain' SAS in an (program) editor. Is that right? In that case, the programming board would have been a better choice.

Can you show the LOG of what you are doing? Does it show an ERROR message?

Paste the LOG in the screen that pops up after clicking the </> icon in the toolbar. Otherwise the LOG is losing structure and formatting.

Cheers,

Koen

Re: Transferring datasets from Dropbox to SAS 9.4

arsy1198 — Mon, 03 May 2021 23:43:12 GMT

Sorry about that, but yes, I'm just using plain SAS. I'll make sure to keep that in mind next time.

So I'm just trying to open a dataset I downloaded from Dropbox into SAS. However, when I try to open it, I receive the pop-up, "ERROR: Unable to open the table TMP2.MARCH3DATA. TMP2.march3data cannot be opened. Do you want to select a different table to open?" and this is what shows up in my LOG

ERROR: Format AFRAIDQA not found or couldn't be loaded for variable AFRAIDQ.
ERROR: Format HUNGRYJA not found or couldn't be loaded for variable HUNGRYJOB.

According to the creator of the dataset, these are variables aren't ones she created so she's not sure why they're showing up in the dataset. Any explanations would be great, thanks!

Re: Transferring datasets from Dropbox to SAS 9.4

SASKiwi — Tue, 04 May 2021 02:08:42 GMT

Run this statement then try opening the datasets again. The datasets contain variables with SAS formats assigned which you haven't defined.

options nofmterr;

Re: Transferring datasets from Dropbox to SAS 9.4

arsy1198 — Tue, 04 May 2021 18:49:20 GMT

Yup, this command worked. Thank you so much! Really appreciate it 🙂