Hi, I have a character field containing a mix of numeric and character data (ie. <20 0.555 4500 NA etc etc). I want to select only numeric data and compare with a similar field for comparison. So I wrote: IF VERIFY(EDRESULT,' 0123456789.') NE 0 THEN ; ELSE DO; IF INPUT(EDRESULT,8.2) < INPUT(EDLORNG,8.2) THEN EDFLAG = 'L'; ELSE IF INPUT(EDRESULT,8.2) > INPUT(EDHIRNG,8.2) THEN EDFLAG = 'H'; END; But I'm not sure how format I should use to read in these data. Since it contains different decimal points, I can't just use one format (8.2). It gives a mix of correct and incorrect answers when I use this format. Any idea? Thank you. James ... View more

proc export needs a nonames option/statement to allow user to suppress printing of SAS dataset column names on an output file. For example: proc export data=mysasdata outfile="c:\mydata.csv" dbms=csv replace ; run; Presently, there is no option or statement that will allow the user to suppress printing of the SAS data set column names as the first record of the output file. ... View more

Hi everyone, I am not sure about the right forum but... I have a problem problem and I would be thankful if somebody can solve this. I have dataset like this... DOCTOR PATIENT Ann Mark John Anton Ann Jeff Ann James John Howard William Cliff . . . . . . And I should export this dataset to different excel files by using keyvariable DOCTOR like this... PROC EXPORT DATA=doctorset OUTFILE="c:\data\Ann.xls" DBMS=EXCEL2000 REPLACE; PROC EXPORT DATA=doctorset OUTFILE="c:\data\William.xls" DBMS=EXCEL2000 REPLACE; PROC EXPORT DATA=doctorset OUTFILE="c:\data\John.xls" DBMS=EXCEL2000 REPLACE; PROC EXPORT DATA=doctorset OUTFILE="c:\data\xxxx.xls" DBMS=EXCEL2000 REPLACE; run; Can I use some kind of macro or something? The dataset is so large that I cannot use handjob... Thank you for advance! ... View more

Hi everyone: At: http://campus.esri.com/clubs/view/index.cfm?c=KJ7VJVD8Gm&CFID=4392899&CFTOKEN=59674410 was created a club that focuses it's attention on data and software integration between SAS, Inc. software and ESRI software. Large amounts of data are waiting for mapping applications to reach high level analysis in several professional fields. At the moment, few efforts are realized (SAS Bridge 2.1) regarding the real capabilities of ESRI applications. Information about this topic is not easily available, even though many stand-alone applications and oriented systems are developed around the world. Sharing related information and experiences via the message board could be really useful. ... View more

Hi, EG doesn't allow to create a dataset if it's already registered in metadata , like sorting a dataset , updating via a datastep , merging via a datastep , but it does allow it in other cases like a proc sql create table . In some cases there is a simple workaround by first deleting it , but that's not an option for a sort ... There I would need to sort it to a work table , delete or empty the table and then append the work table .... Is there an option to force this to be allowed ? thx, Wim /* example log */ 11 proc sort data=source.flatfiles; 12 by nbr_obs; 13 run; ERROR: The member name SOURCE.FLATFILES already exists in metadata. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.00 seconds /* end log */ ... View more

Im trying to test the SAS BI Web Services component using the DISCOVER and EXECUTE operations, DISCOVER operation give the expected response but when i try with the EXECUTE operation it give me an error, somebody knows what can i do to solve that issue? I was thinking about a miss configuration from web services to metadata server, i already check the properties files and everything looks fine. Thats the SOAP request: InData 1 20 99 50 200 9999 100 2000 1000000 Provider=SASSPS Thats the response: org.apache.commons.httpclient.HttpException : soap-env:Client SAS XML for Analysis Provider The SAS XML for Analysis Provider encountered an error Thats the tomcat console message: 2006-05-10 12:41:54,156 [Thread-58] ERROR com.sas.web.services.xmla.XMLAServlet - Exception occurred while processing SOAP request. com.sas.web.services.xmla.XMLAControllerException: Provider was not specified in DataSourceInfo. at com.sas.web.services.xmla.XMLAServlet.doPost(XMLAServlet.java:1238) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.access$000(Applicatio nFilterChain.java:98) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilt erChain.java:176) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:172) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:530) at java.lang.Thread.run(Thread.java:534) Message was edited by: cvidal at May 11, 2006 2:41 PM ... View more

Hello, The data is like this: Group Score 1 5 1 9 1 6 2 3 2 7 2 8 I guess using do statement(or similar loop) in the data step would speed the input. I know for example in matlab how to do this, but what is the equivalent code in SAS? gim ... View more

Hello, I am looking to find out if there is a good replacement for the cgm format using sas/graph. CGM is not supported in Adobe Indesign CS2, and I have had several issues with eps and ps formats produced by SAS. Is there a different prefered format? Thank you for your time. ... View more