.

20 SAS Macros Tips in 30 Minutes

Need to convert SDTM data to ADaM data? Here's (Clinplus Report) Introduction If you have you been wondering how you can effectively meet the clinical data study standards set out by the Clinical Data Interchange Standards Consortium (CDISC) specifically with regards to the Study Data Tabulation Module (SDTM) and the Analysis Data Model (ADaM) our data conversion and reporting tool may be the solution you are looking for to generate all of your safety tables and listings and provide supporting documentation in a validated, standardized ADaM compliant manner. A Taste of SDTM in Real Time Do we need to create ADaM dataset for each SDTM dataset? By Jack Shostak: You do not need to create an analysis dataset for every SDTM domain. The SDTM files can be used as-is (and probably with support from ADSL for key analysis variables) for statistical analysis if you can get away with that. The idea with analysis datasets and ADaM is that ADaM datasets are value added. ADaM...

This paper presents a set of programming guidelines and conventions that can be considered in developing code to ensure that it is clear, efficient, transferable and maintainable. These are not hard and fast rules but they are generally accepted good programming practices. These techniques can be used in all types of SAS® programs, on all platforms, by beginners and experts alike. SAS ® PROGRAM EFFICIENCY FOR BEGINNERS Guidelines for Coding of SAS® Programs

2009 November - Looping the loop with DO loops October - The Use and Abuse of the NODUPKEY option in the SORT Procedure September - Comparing all datasets in one directory against all the datasets in a second dataset, using CALL EXECUTE August - Selecting data for a particular month July - I am missing a '0' in front of my day value, can SAS still read it okay? (or can SAS read a text date of '6JUN2009' correctly) June - Prefixing a value with '+' or '-' May - Why use dataset variable labels? April - More on using a FORMAT to merge data March - Delete all datasets in a library, except ... February - Getting rid of the message "NOTE: BASE data set does not exist. DATA file is being copied to BASE file." January - SUM(OF variables) 2008 December - Making a copy of a SAS dataset, Part 2 November - How would I set only character or numeric variables of an observation to missing? October - Making a copy of a SAS dataset, ...

A many-to-many match-merge is more complicated. When we try to do many-to-many merge that means both the data sets have multiple occurrences of BY variable values. Simple match-merge the two data sets using the BY statement is never OK… Because when we do, we get the following note in the log. "NOTE: MERGE statement has more than one data set with repeats of BY values." SAS Programmer always tries to avoid this message in the log file….because this message means that the resulting data set is probably not what we expected. Don’t be afraid that there is no way… you can do many-to-many merge using data step. A well known SAS Expert David Franklin points out a way to do many-to-many merge Many Thanks David! (Read his original post here ) NS8PO19P The Fundamentals of MERGE

Assessing SAS® Skill Level during the Interviewing Process Interviewing and assessing SAS Programmers SAS Technical Interview Questions SAS® Interview or “How to Get a Second Date Tips for Effectively Interviewing SAS Programming Candidates HIRE Power in the Pharmaceutical What’s a “Senior” SAS® Position? Hiring the Best SAS Programmers Quizzes and Solutions (source: http://www2.umdnj.edu ) by Ron Cody http://www2.umdnj.edu/codyweb/biocomputing/quizzes.html SAS Proficiency Test by Judy Loren Evaluating Sample Code for an Interview Assessing SAS Skill Level during the Interviewing Process

If you happen to be one of the unlucky programmers who lost the SAS code … because you didn’t save it. There is solution for that…. SAS System automatically takes the backup of the SAS code for every 10 minutes (default); Just look in the following location: C:\Documents and Settings\Programmer Name\Application Data\SAS\EnhancedEditor\ Note: Replace “ Programmer Name ” with your login user id of the System you are using; If you go the specified location above, you will see a copy of the unsaved version of the SAS code. It will be quick if you search files with the extension name ‘.$AS’ (extension for auto-saved SAS codes) If you want, you can also change the 10-minute time interval for Auto save…. Go to… Tools ► Options ► Preferences ► Edit. In the preferences dialog box, make sure to the change the time under Autosave every …. And click on OK ...