Move a SAS created CSV to Azure Blob Storage

jcromwell77 — Wed, 01 Jun 2022 19:01:29 GMT

I have a dataset that I have converted to a CSV file. (No issues). However, I cannot figure out how to send this file to an Azure Blob Storage container with public access.

I tried to use the following:

LIBNAME UPLOAD '<location of the dataset>' ;

PROC EXPORT DATA UPLOAD.<dataset>

DBMS=CSV

OUTFILE= "<Blob Storage URL>..csv" REPLACE ;

RUN;

I get an ERROR: A component of <outfile> is not a directory. Obviously, the outfile method is incorrect.

I have reviewed this, but not sure how this works:

https://documentation.sas.com/doc/en/pgmsascdc/v_027/lestmtsglobal/p1arsjiowdszd8n1qk8mqg5p2uhv.htm

All I need to do, is save the CSV in the Blob Storage. From there an ADF pipeline will do the rest, but I cannot figure out how to save it in the Blob storage.

Thanks.

Re: Move a SAS created CSV to Azure Blob Storage

Tom — Wed, 01 Jun 2022 19:26:06 GMT

Looks like that page is describing how to create a FILEREF that points to the blob storage.

So try doing that first. In this example from that page the fileref they are using is literally FILEREF, but it can be any valid SAS name of 8 characters or less,

* example ;
filename fileref abs "blob-file-name" ... <more-code>;

and then use the FILEREF in the PROC EXPORT code.

... OUTFILE= fileref ...

topic Re: Move a SAS created CSV to Azure Blob Storage in SAS Programming

Move a SAS created CSV to Azure Blob Storage

Re: Move a SAS created CSV to Azure Blob Storage