Snipplr - sarathannapareddy

(SAS) ERROR: The format XXXX was not found or could not be loaded.

Tue, 18 May 2010 13:24:04 GMT

Whenever you try to open a SAS data set which has permanent formats, you will get the error message in the log file saying “ERROR: The format XXXX was not found or could not be loaded.” This happens generally when you don't have the format library where the SAS dataset located. What happens here is, SAS will not permit you to open the data set without the format library. But, if you use options nofmterr; at the top of your program, SAS will opens the dataset for you despite the fact that it does not have the format library.

(SAS) Sending the LOG and OUTPUT from PC SAS to a seperate file

Tue, 18 May 2010 13:17:18 GMT

(SAS) Random Sample Selection

Tue, 11 May 2010 10:40:28 GMT

Last week my manager asked me to randomly pick 10%observations from a large data set and then create a listing so that the Data management programmers can QC the data. I want to share some thoughts here … how easy and simple to do random sampling. Approach 1: Data step Approach: In this approach, the observations are shuffled using the RANUNI function which assigns a random number to each observation.

(SAS) tod8. and picture formats: How Can I Find a Time Format that Does Not Remove the Leading Zero e.g. Time5

Mon, 26 Apr 2010 19:58:45 GMT

There is currently no time format that puts leading zeros automatically in time values. But there are a number of ways of achieving this, below are some examples.

(SAS) $UPCASEw. format

Mon, 26 Apr 2010 19:55:30 GMT

http://studysas.blogspot.com/2010/03/upcasew-format.html

(SAS) PRXMATCH Function

Mon, 26 Apr 2010 19:52:30 GMT

Prxmatch () function is very useful in locating the matching strings. Prxmatch() function has 2 parameters, the first parameter is the regular expression ID (i.e what you are looking in a string for a match) and the second parameter is the character string to be searched. PRXMATCH () function returns the start position of the matching string.

(SAS) How to create a macro variable containing a list of variables in a DATA set

Mon, 26 Apr 2010 19:49:45 GMT

Sometimes it is very handy to have a macro variable contanining the variables names of the dataset. Here are the 2 different ways you can create a macro variable with list of variables names ...

(SAS) Special Missing Values in SAS

Mon, 26 Apr 2010 19:47:19 GMT

Special missing value is a type of numeric missing value that enables you to represent different categories of missing data by using the letters A-Z or an underscore.

(SAS) http://studysas.blogspot.com/2010/04/write-letter-using-sas.html

Mon, 26 Apr 2010 19:44:39 GMT

SAS can do many things which most of us don’t have a clue. Here is one example…. Writing a letter

(SAS) CALL EXECUTE: Easy way to print or sort multiple files.

Mon, 26 Apr 2010 19:42:48 GMT

When printing multiple files, or sorting multiple datasets, the traditional method is to write multiple steps as below. Proc print data=libref.ae; var _all_; run; Proc print data=libref.conmed; var _all_; run; Proc print data=libref.demog; var _all_; run; Proc print data=libref.lab; var _all_; run; Proc print data=libref.medhist; var _all_; run; If you are like me who likes to simplify the traditional SAS code here is the tip. CALL EXECUTE comes to rescue here.

(SAS) WARNING: The quoted string currently being processed has become more than 262 characters long. You may have unbalanced quotation

Mon, 26 Apr 2010 19:40:43 GMT

SAS can allow the strings up to 32,767 characters long but some times SAS will write a Warning message ‘ WARNING: The quoted string currently being processed has become more than 262 characters long. You may have unbalanced quotation marks.

(SAS) SAS Display Manager Commands

Mon, 30 Nov 2009 20:09:17 GMT

In my view, Display Manager commands didn’t get much attention of SAS programmers as they should be. It may be because... 1) SAS Documentation has very little information about how to use this facility. 2) Even Google searches aren’t helpful enough. Here are the list of Display Manager Commands I know… Read more: http://studysas.blogspot.com/2009/11/sas-display-manager-commands.html

(SAS) Even you can Use HASH and DOUBLE DASH: It’s that Simple……

Sun, 01 Nov 2009 08:01:39 GMT

In order to understand HASH and DOUBLE HASH concept in SAS you need to know about two different ranges of variables:

(SAS) SAS Interview Questions on Macros

Sun, 01 Nov 2009 07:59:08 GMT

(SAS) Very Basic SAS Interview Questions and Answers

Sun, 01 Nov 2009 07:57:43 GMT

SAS Interview : General

(SAS) Self teach SAS Tutorials

Sun, 01 Nov 2009 07:52:49 GMT

The following are a series of self-teach tutorials which will introduce you to the command language approach to SAS programming. Each tutorial is designed to take about twenty minutes. To work through the tutorials you need to be on a machine which has SAS Version 8 loaded on it, or has access to SAS through the campus network. The material presented in the tutorials is designed to get you 'up and running.' Consequently, many options are omitted. Check the SAS help files for more a detailed discussion of the procedures outlined in the tutorials. The last tutorial is an introduction to SAS Analyst which is SAS's version of a 'point and click' approach to statistical analysis.

(SAS) Merging the data sets with a common variable if the datasets has the same prefix name?

Sun, 01 Nov 2009 07:48:29 GMT

For example: col1-col10 dsn1-dsn 7 data1 to data6 with common variable of Usubjid. here is the example, I have 7 datasets i need to merge and each of them having the common variable(usubjid) to merge, and all the datasets having the same prefix dsn(dsn1 to dsn7).

(SAS) SAS Tips: Few Lines of code

Sun, 01 Nov 2009 07:46:04 GMT

*Creating a flag variable when a test variable meets certain criteria is very common for SAS programmer…. Many SAS programmers use the below code to assign a flag of 1 or 0 depending on of the test variable meets criteria or not.;

(SAS) Standardising Clinical Data exchange

Sun, 01 Nov 2009 07:43:04 GMT

Almost everyone in Pharma R&D has heard of CDISC, yet many clinical researchers seem unsure of how the standards work and how they can fit in with existing data management operations…..Barry Burnstead explains the existing standards and the practicalities of implementation.

(SAS) Dummy Dataset or SAS Options: Which is better to insert a Zero Row?

Sun, 01 Nov 2009 07:38:23 GMT

Always, programmers need to summarize the demographics data and show it in a table and to do so they use Proc Freq procedure. Even though proc Freq calculates the Frequency exactly, it may not be the write procedure in all cases especially when data do not exist. Some times statistician wants to see all the data values on the CRF in the final table, even though there is no combination as such exists in the dataset. In this case we have to insert observations with 0 values. Here I will present you ….the different methods to insert a zero row. 1) Creating a Dummy Dataset and Concatenate the dummy dataset with the input dataset. 2) Proc Freq SPARSE option 3) Proc Means COMPLETETYPES Option 4) Proc Means COMPLETETYPES Option with PRELOADFMT option.