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...
Please join StudyMode to read the full document