On this page, you find an overview of all the “How To’s” of this website.
How To:
- Add Leading Zeros
- Append Datasets
- Avoid Division by Zero
- Calculate Percentiles
- Calculate the Average of a Column
- Calculate the Average per Group
- Calculate the Cumulative Percentage
- Calculate the Difference between Timestamps
- Calculate the Median
- Calculate the Moving Average
- Calculate the Square Root of a Number
- Calculate the Standard Deviation
- Calculate the Sum of a Column
- Check if a Dataset is Empty
- Compare Datasets
- Concatenate Strings
- Convert Datetime into Date
- Convert Number into Date
- Count the Number of Missing Values
- Count the Number of Rows
- Count the Number of Rows by Group
- Count the Numer of Specific Characters in a String
- Create an Array
- Create a Bar Chart
- Create a Boxplot
- Create a Dynamic PROC TRANSPOSE
- Create an Empty Dataset
- Create a Dataset Manually
- Create a Histogram
- Create an Index
- Create a Library
- Create a Macro Variable
- Create a Random Sample
- Create a Scatter Plot
- Create a Substring
- Create a Title
- Create a User-Defined Format
- Create a ZIP file
- Create Variable Labels
- Create Variable Names with Spaces or Special Characters
- Calculate the Cumulative Sum (by Group)
- Delete Data Sets
- Delete an Empty Dataset
- Dynamically Rename Column Names
- Export Data from SAS to Excel
- Export Data from SAS to SPSS
- Export Data from SAS as CSV
- Export Data from SAS as TXT
- Extract the Last Character from a String
- Filter Data
- Find Duplicates
- Find the Length of a Variable
- Find the Maximum Value per Row Across Columns
- Find the Minimum Value per Row Across Columns
- Find the Maximum Value of a Variable (per Group)
- Find the Minimum Value of a Variable (per Group)
- Find the Mode of a Variable
- Find Outliers
- Identify & Remove Empty Columns
- Import a CSV File
- Import an Excel File
- Import a Text File
- Insert a Row
- List Column Names
- Rank Variables
- Remove Blanks
- Remove Duplicates
- Remove Leading Zeros
- Remove Macro Variables
- Rename a Dataset
- Rename Variables
- Reorder Columns
- Replace Missing Values
- Round Numbers
- Run a Simple Linear Regression
- Save SAS Output as a PDF file
- Select Variables with the KEEP & DROP Option
- Select the First N Rows
- Select the First Row per Group
- Select the Last Row per Group
- Show Variable Labels
- Sort a Dataset
- Use the Colon Modifier
