Mathematics

Only available on StudyMode
  • Download(s) : 66
  • Published : January 18, 2013
Open Document
Text Preview
2

Copyright©2011 by KNIME Press All Rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording or likewise. For information regarding permissions and sales, write to: KNIME Press Technoparkstr. 1 8005 Zurich Switzerland knimepress@knime.com

ISBN: 978-3-9523926-1-4 SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.

3

Table of Contents
Foreward ............................................................................................................................................................................................................................................................... 7 Data and Script Structure ...................................................................................................................................................................................................................................... 9 Script Structure how to build an analysis workflow ................................................................................................................................................................................... 10

The programming environment ...................................................................................................................................................................................................................... 11 LIBNAME PROC PRINT DELETE path to workspace .................................................................................................................................................................................................................... 12 display data table ................................................................................................................................................................................................................... 13

delete data table / increase the heap space................................................................................................................................................................................ 14

Include other script languages ............................................................................................................................................................................................................................ 15 PROC SQL Java, R, Python, Perl Snippet................................................................................................................................................................................................. 16

Input/Output ....................................................................................................................................................................................................................................................... 17 INFILE read data from text file .................................................................................................................................................................................................................. 18 create data inside the script ......................................................................................................................................................................................... 19 connect/disconnect to/from database ....................................................................................................................................................... 20

INPUT … datalines

connect to /disconnect from

PROC IMPORT … DBMS=EXCEL read data from Excel file...
tracking img