Error running Proc DS2 code

[DannyDsouza]

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

[gergely_batho]

There is no file statement in proc ds2.

[Amazigh]

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.

[LinusH]

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

[Amazigh]

@Linus,

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

Amazigh.