SAS Utility Proc 1

《SAS Utility Proc 1》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、UtilityProc(1)ObjectivesWewillcoverfollowingproceduresinthisclass:PROCFORMATPROCSORTPROCTRANSPOSEPROCPRINTPORCPRINTTOPROCCONTENTSPROCAPPENDPROCCOMPAREPROCCOPYPROCDATASETSPROCIMPORTPROCEXPORTPROCDOWNLOADPROCUPLOADAftersuccessfulcompletionofthisclass,youareexpectedtoknow:Pro

2、cedureFunctions–WhentouseBasicSyntax(options,statements,etc.)–HowtouseCommonUsageContentsPROCFORMATPROCSORTPROCTRANSPOSEPROCPRINTPROCPRINTTOPROCCONTENTSPROCAPPENDPROCCOMPAREPROCCOPYPROCDATASETSPROCEXPORTPROCIMPORTPROCDOWNLOADPROCUPLOADCustomizeformats,tolabelorgroupthevalu

3、eSyntaxPROCFORMAT;EXCLUDEentry(s);INVALUE<$>name<(informat-option(s))>value-range-set(s);PICTUREname<(format-option(s))>value-range-set-1<(picture-1-option(s))><...value-range-set-n<(picture-n-option(s))>>;SELECTentry(s);VALUE<$>name<(format-option(s))>value-ra

4、nge-set(s);PROCFORMATPROCFORMAT–VALUEstatementprocformat;valuefmttrt1=‘TreatA‘2=‘TreatB';valuefmtage0-19='Young'20-59='Adult'60-high='Old‘Others=‘Others’;run;NumerictoCharacterprocformat;value$fmtgde'Male'='group1''Female'='group2';run;CharactertoCharacterCreatesaformattha

5、tspecifiescharacterstringstousetoprintvariablevaluesRangecanbespecifiedwithspecialkeywords:LOW–Fromtheleastpossiblenumber(doesnotincludemissingvalues)HIGH–TothelargestpossiblenumberORHER–Allothernumbersnototherwisespecified(includemissingvaluesunlessaccountedforwitha‘.’or‘

6、’)PROCFORMAT–FMTLIBOptionPrintinformationaboutformatsprocformatlib=workfmtlib;select$MFMTGDE;run;FORMATNAME:$MFMTGDELENGTH:7NUMBEROFVALUES:2MINLENGTH:1MAXLENGTH:40DEFAULTLENGTH7FUZZ:0-------------------------------------------------------------------------------------START

7、

8、END

9、LABEL(VER.V7

10、V808FEB2010:09:19:22)----------------+----------------+-------------------------------------------------Female

11、Female

12、group2Male

13、Male

14、group1SASoutputPROCFORMAT–CNTLIN=OptionLoadformatfromadatasetortableprocformatcntlin=cntlin;run;VariableTypeLabel--------

15、----------------------------------------------------------------FMTNAMECharFormatnameTYPE