topic Re: Error running Proc DS2 code in SAS Programming

Error running Proc DS2 code

DannyDsouza — Thu, 21 Mar 2013 11:14:48 GMT

Hi,

I am trying to run a Proc DS2, which is as follows

options emailsys=smtp emailhost=exchangeind.apac.sas.com emailport=25;

filename mymail email "emailsupport@yahoo.com" subject="test message";

proc ds2;

data _null_;

method run();

file mymail;

put 'Test Ds2';

end;

enddata;

run;

quit;

The error in the log is

ERROR: Compilation error.

ERROR: Missing END statement for the method run.

ERROR: Parse error. Expecting end of input on source line 195: data _null_; method run();

==>file.

Running the same on SAS 9.3

Any insight would be helpful

Regards

Danny

Re: Error running Proc DS2 code

gergely_batho — Fri, 22 Mar 2013 08:46:26 GMT

There is no file statement in proc ds2.

Re: Error running Proc DS2 code

Amazigh — Tue, 26 Jul 2016 16:17:31 GMT

Hi,

I'm trying to execute a simple proc DS2 and I have an ERROR message that gives me a headache !

I'm under SAS 9.4.01M2PXXXXXXXX.

PROC DS2 NOLIBS CONN="DRIVER=ODBC;DB=&Db.; UID=&uid.; PWD=&DbPwdEncrypt.; CATALOG= (SI=DW_GIt)"; 
   DATA;
      METHOD RUN();
         SET 
{
		SELECT DISTINCT  
	  	a.ClePointDeVenteSI 
	  ,	STRIP(PUT(a.CleMoisAnnee,6.)) AS DT_PERIODE
	  ,	SUBSTR(CALCULATED DT_PERIODE,5,2) AS DT_MOIS
 	  ,	SUBSTR(CALCULATED DT_PERIODE,1,4) AS DT_ANNEE
	  , a.ClePresentation
	  , a.CleCanalDeDistribution
      , SUM(a.Unite) AS Unite
      , SUM(a.CAHT)  AS CAHT
	
	FROM  SI.FaitMoisAchat(WHERE =(CleMoisAnnee = 201604 AND CleCanalDeDistribution in (1,2))) AS a
	GROUP BY a.ClePointDeVenteSI, a.ClePresentation

};
      END;
   ENDDATA;

RUN;QUIT;

ERROR: Invalid connection string.
ERROR: TKTS initialization failed.
ERROR: Expected list item separator.

I can not manage to handle this issue that hampers me to handle further merges with PROC DS2

Anyone could help me please ?

Amazigh.

Re: Error running Proc DS2 code

LinusH — Thu, 28 Jul 2016 16:29:43 GMT

@Amizigh, even if your inquire is in the same area, don't hijack and old thread. Each thread corresponds to one question.

Re: Error running Proc DS2 code

Amazigh — Thu, 28 Jul 2016 16:57:39 GMT

@Linus,

Ok, no problem. I sent a track to the support.

Amazigh.