Issue in transferring files by using azcopy from SAS

Anu123 — Thu, 16 Dec 2021 11:09:55 GMT

Dear All,
I am trying to transfer csv files into Azure datalake storage by using Azcopy from a SAS program but this is not working.
If am exciting the same azcopy command directly command prompt the files are transferring successfully.
So this issue is only when i call azcopy command from SAS.

rc = system ("azcopy copy "source_directory/file_name.csv" "SAS_token" options;" );

ERROR 388-185: Expecting an arithmetic operator.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE,
GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||, ~=.

ERROR 390-185: Expecting an relational or arithmetic operator.

ERROR 76-322: Syntax error, statement will be ignored.

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
52:2
NOTE: The SAS System stopped processing this step because of errors.

Re: Issue in transferring files by using azcopy from SAS

Kurt_Bremser — Thu, 16 Dec 2021 11:54:28 GMT

The SYSTEM function expects a single character value as parameter, you are trying to feed it what SAS sees as an expression with missing operators.

Your call should look like this:

rc = system("azcopy copy source_directory/file_name.csv SAS_token options");

topic Re: Issue in transferring files by using azcopy from SAS in SAS Programming

Issue in transferring files by using azcopy from SAS

Re: Issue in transferring files by using azcopy from SAS