Dear All, I am trying to insert data into PostgreSQL DB, in some cases it is working fine but in some cases it is throwing below error. ERROR: CLI error trying to establish connection: could not translate host name  "HOST NAME" to address: Name Please help me out what is the issue. ... View more

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.     ... View more

Hi All, Trying to convert the c=12345678912345.61 value to string by using put function but is not working as expected.  It looks SAS is having limitations in converting big numbers. Is it possible to convert integer values( more than 17 digits) to string ?   data _null_; c=12345678912345.61; b=put(c,best32.2); put b; run;   Output :-  12345678912345.6 ... View more