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
There is no file statement in proc ds2.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.