BookmarkSubscribeRSS Feed
DannyDsouza
SAS Employee

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

4 REPLIES 4
gergely_batho
SAS Employee

There is no file statement in proc ds2.

Amazigh
Fluorite | Level 6

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
Tourmaline | Level 20
@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
Amazigh
Fluorite | Level 6

@Linus,

 

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

 

Amazigh.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1625 views
  • 0 likes
  • 4 in conversation