Set, Match, Merge.... Don't You Love SAS | StudySAS Blog

Saturday, October 3, 2009

Set, Match, Merge.... Don't You Love SAS

Posted by sarath at Saturday, October 03, 2009

Labels: Datastep, Merge statements, SET

0 comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Search This Blog

blogger analytics

DASHBOARD- RSS - DISCLAIMER- EMAIL

Full RSS Feed

Subscribe to our RSS Feed with full posts.
E-Mail Delivery

NESUG 2011 Publication

Generating the Define.XML

Recruiting Agencies, Contract and Consulting Firms

Recruiting Agencies, Contract and Consulting Firms

SAS Interview Tips and FAQ's

Base-SAS® Tips, Tricks and Techniques
Basics
Behavioral Type
Better Programming Practice Tips
Clinical
Clinical Trials
Clinical Trials (contd.)
Common Sense Tips and Clever Tricks (SAS®)
Macros
Proc SQL/Graphs/ODS
SAS SQL 1: Essentials
SAS Tips for data handling
SAS: What You Need to Know to Write a SAS Program
SAS® Systems Options Are Your Friends
Very Basic

SAS Tutorials (Video & Audio)

Index to SAS Tutorials
Learn SAS Programming in 7 weeks
SAS Study materials
SAS Tutorials
Self Teach SAS Tutorials
Statistics Tutorials

SAS Certifications

SAS Date,Time and datetime functions
Base SAS certification Summary Functions
Base and Advanced SAS Certification Exam Material
Base SAS Certification Exam Model Questions
SAS Certification Assignments
Base SAS Certification: Functions

Macros

%Global vs %local Macro variables
20 SAS Macros Tips in 30 Minutes
Ampersands(& vs &&)
CALL SYMPUT vs CALL SYMPUTX
LOCF Macro
Macro Debugging Options
Macro IN operator
Macro to check the max. length of variable
More About SAS Macros
P-Value Calculation Made Easy with the SAS® Call Execute
SAS Macros that Convert a Directory of Transport Files
Standard Macros for P-values
Why use Macros

SAS Webinars/Presentations

Cynthia Zender and Michele Burlew offer their vast expertise in a new Webinar presentation: Output Delivery System: The Basics and Beyond
Programmatically Measure SAS Application Performance on any Platform with the New LOGPARSE SAS Macro (Michael Raithel)
Exploring Dictionary Tables with PROC SQL (Kirk Lafler)
Tips and Techniques for Producing Quick Results with PROC SQL (Kirk Lafler)
Statistical Programming in the Pharmaceutical Industry: Moving Forward, Confronting Challenges, and Embracing Opportunities (Jack Shostak)
Using SAS Software in the Design of Clinical Trials (Alex Dmitrienko)

Role of Statistics in Clinical Trials
Clinical Trials in INDIA: Opportunities
Clincal Data Exchange

SAS Programmer Work Environment

Clinical BioStatistician/Programmer: A Day in the Life
Design of Case Report Forms
DLP (Data Life Cycle Plan)
How to QC your own programs
ISS and ISE Analysis
MedDRA and WHODrug Dictionaries
Metadata for Data-Driven Programming
Oracle Clinical for SAS Programmers
Phase I -IV of Clinical trials
Protocol
SAS Programmers Working Environment
Standardizing Clinical Data Exchange
Statistical Analysis Plan (SAP)
Statistical Principles for Clinical Trials
Tables, Listings and Figures (TLF's)
Techniques for Designing CRF's
Tips for Producing Comprehensive Integrated Summaries (ISS and ISE)
Why SAS

Submission Standards

21CFR Part 11
A concept for define.xml generated in SAS
ADaM Dataset Checking Toolkit
ADaM Implementation Guide
ADaM Standards: Introduction
ADaM Version 2.0 Final
ADaM Version 2.1
Analysis Datasets for FDA submissions
CDER Common Data Standards Issues Document
CDISC ADaM Datasets-SDTM to Submission
CDISC Discussion Forum
CDISC Glossary
CDISC Implementation
CDISC Implementation process
CDISC Implementation Process by Michael Todd (MP3)
CDISC Perspective: Clinical Trial Process
CDISC SDTM 3.1.1 Validation Rules
CDISC SDTM 3.1.2 Validation Rules
CDISC SDTM Basics
CRT's for FDA Submission
Data Definition Tables – Definition and Automation
Date Conversions in SDTM and ADaM Datasets
Define.XML
Developing e-Stds for Clinical Trials Data
Exploring the Analysis Data Model – ADaM Datasets
From SAP to ADaM: The Nuts and Bolts
Future of ODM/SDTM and CDISC
GENERATING Define.xml
How Do I Map That? - SDTM Implementation Challenges
How to build ADaM from SDTM: A real case study
Implementation of CDISC
Implementing SDTM and ADaM Stds
Important Documents from FDA Website
Introducing the CDISC Analysis Data Model(ADaM) Implementation Guide
New Tips and Tricks for Creating a Harmonized, Report-Friendly SDTM and ADaM Lab Data for a CSR
Practical Methods for Creating CDISC SDTM Domain Data Sets from Existing Data
Producing clinical laboratory shift tables from ADaM data
Review and Implementation of CDISC Standards In the Pharmaceutical Industry
SAS Transport Files/ (XPORT) .XPT files
SDTM (Study Data Tabulation Model) V 1.1
SDTM Datasets: Unlocking CDER's 7 Most Commonly Found Problems
SDTM Implementation process
SDTM V 3.1.2 Implementation guide
SDTM Validation Tools or Compliance Checks
Standards for e-sub of data to FDA
Study Data Specifications
Study Data Specifications
The 5 Biggest Challenges of ADaM
Validation Checks for SDTM datasets
Why CDISC Standards
XML Schema Validation for Define.xml

Related Posts with Thumbnails

Must read information

Character Functions
Choosing between the DATA Step and PROC SQL
Coming to SAS® from SPSS
Debugging SAS Programs: Understanding the Types of Errors
Don't Be a SAS® Dinosaur: Modernize Your SAS Programs
Little SAS Book (Chapter 1) Getting Started Using SAS® Software
Little SAS Book (Chapter 1) SAS® Enterprise Guide Basics
Performing Queries Using PROC SQL
Ron Cody's Data Cleaning Techniques Using SAS (Chapter 1: Checking Values of Character Variables)
SAS Formats Pocket Reference
SAS Programming in the Pharmaceutical Industry (Chapter 1) Environment and Guiding Principles
SAS® 9.1 SQL Procedure (Users Guide)
SAS® Certification Prep Guide (Chapter 1): Base Programming
Step-by-Step Programming with Base SAS® Software
Validating Clinical Trial Data Reporting with SAS (Chapter 1) Pharmaceutical Industry Overview
Writing Reports with SAS

FDA Study Data Standards Resources

FDA Study Data Standards Links

SAS Programs (Examples)

Cornell University Sample Programs
SAS Graphs (Replay 4 graphs per page )
Three SAS Programs that use Arrays
University Of Arizona (Sample Programs #1 #2 and #3)
Georgia State University (Sample Programs #1 #2 and #3)

SAS Tips and Sample Codes

?? Format Modifier
Add leading zeros to numeric vars
Call Execute: Easy way to Print or Sort Multiple files
Check How easy to find ERROR/WARNING/UNINITIALIZED messages in the LOG window
Clean-up the LOG files
Counting no.of obs/subject
Customize pageno in RTF output
DASH and DOUBLE DASH
Debug the SAS Code
Delete formats/informats from dataset
Delete slected obs. from dataset
DEXPORT/DIMPORT Commands
Display Manager Commands
Dummy Dataset or SAS Options: Which is better to insert a Zero Row?
Encoding=Wlatin1
Exporting the dataset into .csv file
File exists in the library or not
Find path & filename of executed program
Finding Number of obs in the dataset:
Get the details of Format from Format Library
How to get the program name and path
How to Remove carriage returns (‘OD’x ), line feeds (‘OA’x) from Text Fields
Import Excel files into SAS
Introduction to Dates and Times in SAS
Keyboard Shortcuts
LAG function
Local vs Global macros
Lost the SAS Code, No problem....
MDY Function
MDYAMPMw.d and ANYDTDTMw.d Formats
Missing Values: How To detect using Arrays
MMDDYY+: Format that inserts a slash, space or "-" between the date, month and year
New IF functions: IFC and IFN
Option Missing='0'
Option nofmterr; fmtsearch option
Options in SAS INFILE statement:
PROC SQL vs Datastep:
Proc STDIZE: Replace Missing Values
PRXMATCH Function
Random Sample Selection (RANUNI Function)
Read next record while working on the current record (Opposite to LAG function)
Renaming variables using SASHELP views
Reordering variables to be in alphabetical order
Replace missing values into zeros
Run vs Quit Statements
SAS Tip 1_Use less code
SAS Tip of the Month: Archive
SAS to SPSS
SAS Toolbar settings
SAS-L Tips
Saving the LOG file
Sending E-Mail from Within SAS
Special Missing Values (.A -.Z)
Study Day Calculation
Sub&Super scripts in footnotes/titles of report
tod8. format:Format that doesn't remove leading zeros in dates
Top 10 most powerful functions for Proc SQL
Transport Files conversion(.XPT)
Transporting SAS Files using Proc Copy and or Proc Cport/Proc Cimport
Upcasing the variables names
VALIDVARNAME=UPCASE
Variable exists in dataset or not