![]() Please Don't Lag Behind LAG!, Anjan Matlapudi and J. Those Sneaky SAS® Functions: Beware of Unexpected Handling of Missing Data and Variable Lists, Christianna WilliamsĢ8. The new SAS 9.2 FCMP Procedure, what functions are in your future?, John H. Longitudinal Data Techniques: Looking Across Observations, Ronald Cody Ģ6. LAG - the Very Powerful and Easily Misused SAS® Function,Yunchao Tian Ģ4. Building and Using User Defined Formats, Art Carpenter Ģ3. See SAS blog to help remember PUT() and INPUT()Ģ1. Dressing for success with SAS® Software Functions, Faith SloanĢ0. Helpful Undocumented Features in SAS®, Wei Cheng ġ9. A Cup of Coffee and Proc FCMP: I Cannot Function Without Them, Peter Eberhardt ġ8. Using SAS® PROC FCMP in SAS® System Development - Real Examples, Yves Deguire, Xiyun Wangġ7. Using PROC FCMP to the Fullest: Getting Started and Doing More, Arthur Carpenter ġ6. Working with Character Data, Andrew Kuligowski, Swati Agarwal ġ5. Fully “Function”-al: A Brief Tour of Selected SAS® Numeric Functions, Brenda Beaty ġ4. Introduction to SAS Functions, Neil Howardġ3. IF-THEN-ELSE, SELECT-END Code and PROC SQL CASE Statements, Thomas Billings ġ2. IFC and IFN Functions: Alternatives to Simple DATA Step Handling Dynamic Variable Types in SAS®, Venkat Lajapathirajanġ1. Using and Understanding Formats, Howard Levineġ0. Discovering the FUN in SAS Functions, Neil Howardĩ. Using and Understanding Formats, Howard LevineĨ. “LAG With a WHERE” and Other DATA Step Stories, Neil Howardħ. Learning to love the SAS LAG function, H. An Introduction to Perl Regular Expressions in SAS 9, Ron Codyĥ. Retaining, Lagging, Leading, and Interleaving Data, Toby Dunn, Chang Y. Benchmarking Character String Replacement, Bruce Gilsenģ. Data Cleaning and Base SAS Functions, Caroline BahlerĢ. INTNX and INTCK Function Examples SAS Blogġ. Understanding and Using Functions, Frank DiIorio (Table of Functions) SAS Book Examples SAS Functions by ExampleĪn Animated Guide: Using the Put and INput functions, Russ Lavery SAS Reference SAS V 9 Character Functions Variety of SAS Function Paper Using SAS Functions in Data Steps, Yue Ye, Yong Lin Scope of Function Paper A Survey of Some of the Most Useful SAS® Functions LAG() and DIF() functions process data across records like SAS proceduresĭifference from previous record's value, useful to calculate change from previous valueīeginner Function Paper An Introduction to SAS® Character Functions, Ron Cody LEAD to bring next record to current record %LET VARTYPE=%SYSFUNC( VARTYPE(&DSID, &VARPOS)) %LET VARPOS=%SYSFUNC( VARNUM(&DSID, AGE)) ![]() %LET VARTYPE=%SYSFUNC( VARNAME(&DSID, &VARPOS)) %LET VARLEN=%SYSFUNC( VARLEN(&DSID, &VARPOS)) %LET VARLAB=%SYSFUNC( VARLABEL(&DSID, &VARPOS)) %LET DSID=%SYSFUNC( OPEN(STUDYLIB.&IN_DS)) Ī number to reference dataset instead of the dataset name. Visitlbl = strip(visitlbl)||' '||strip(substr(labtest_,ĭataset ID Functions (Generally processed with Do-Loop macros for each variable and %SCAN for list of values) See also Data Step, Proc Format, Clinical Data Management, SAS Version 9.2 and SAS Dates. Lookup Reference Favorite SAS Function Blog Type of SAS FunctionsĬHARACTER / TRUNCATION, NUMERIC / MATHEMATICAL, DATE / TIME, STATISTICAL, SYSTEM, FINANCIAL, PROBABILITY, RANDOM NUMBER, STATE/ZIP CODE, ARRAY, QUANTILE and SPECIALĬonvert variable types, Create variables, Convert variables, Find/Count/Compare Single/Word character values, Verify Values, Control blanks in character values, Length, Upper/Lower Case, Substring character values, Concatenate/Replace character values, Date/Time Components, Date Intervals, Descriptive Statistics, Numeric Calculations SAS 9.2 On-Line: Informats, Formats, Functions, Functions by Category, Lists See my SAS tip on Put() and Input() on SAS blog. See Which comes first PUT() or the INPUT()? training session. PUT() using a user defined character format for example, is useful for table lookup feature. When comparing character variables or constants, it is often helpful to apply functions such as LOWCASE(), UPCASE() or PROPCASE() to standardize character text.īelow are a collection of SAS ® papers on functions, informats and formats. SAS ® functions (character, numeric, and date) play a vital role in creating variables. Which comes first PUT() or the INPUT()? (Summary Sheet) SAS ® Functions/Informats/Formats Training Videos:
0 Comments
Leave a Reply. |