Error running Proc DS2 code

Reply
SAS Employee
Posts: 8

Error running Proc DS2 code

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

SAS Employee
Posts: 340

Re: Error running Proc DS2 code

There is no file statement in proc ds2.

Occasional Contributor
Posts: 8

Re: Error running Proc DS2 code

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.

Esteemed Advisor
Posts: 5,198

Re: Error running Proc DS2 code

@Amizigh, even if your inquire is in the same area, don't hijack and old thread. Each thread corresponds to one question.
Data never sleeps
Occasional Contributor
Posts: 8

Re: Error running Proc DS2 code

@Linus,

 

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

 

Amazigh.

Ask a Question
Discussion stats
  • 4 replies
  • 540 views
  • 0 likes
  • 4 in conversation