SAS 'O' LOG

Pages

TIPS
SAS FORUM

Thursday, August 8, 2013

SAS FORUM

SAS 'O' LOG - Discussion

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Labels: SAS FORUM

1 comment:

UnknownNovember 16, 2013 at 6:49 AM
DESCRIBE 5 WAYS TO DO A TABLE LOOK UP IN SAS EXPLAIN IT?
ReplyDelete
Replies

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Labels

SAS FORUM
slider

Popular Posts

What is the difference between Count, Count C and Count W?

Let us see with example a difference between Count, Count C and Count W in SAS: DATA ds; text = 'we are learning SAS function lik...
How to check for the existence of a variable in SAS?

If you want to check if a variable exists in a dataset or not, you can simply use the below macros which uses open and varnum function, to...
Create a progress bar in SAS

Progress bars are fairly easy to implement in SAS/AF however a little harder from base SAS. You can however produce progress bars for use ...
SAS FORUM

SAS 'O' LOG - Discussion
Excel Goal Seek in SAS

In Excel you have the function "Goal Seek". It is a nice function that allows you to "search" for a value for a input ...
Varnum option in Proc contents

Generally when you create a sas dataset by using proc contents on a sas dataset, the output data set is sorted in ascending order by name ...
No Warning Messages

When you write a code ensuring no warning messages are thrown in log but this get the error message below. WARNING 32 -169 : The quoted ...
How to create a PDF ﬁle of a SAS job

For creating a PDF file of a SAS job or SAS procedure, we need to bracket the section of code for which you want to create tables or/and g...
Using SAS DATA Step Views to Conserve Data Storage Space

A SAS data view is a type of SAS data set that retrieves data values from other files. A SAS data view only contains descriptor informatio...
How to retrieve the first character of a variable in SAS

If you need to create a variable which has only first character of the character variable, then there are 4 different ways with which you c...

Featured Posts

Popular Posts

Using Proc SUMMARY to Produce Multiple Tables with Varying Statistics

When calculating descriptive statistics on a table of data, we often need to produce different statistics for the different measurements c...
Extract the first letter of the character variable

Have you ever needed to create a variable which is the first letter of the character variable? In the below example there are four ways to...
%macro skip

When working on a lengthy SAS program, there are a couple of ways to block out parts of your code so they don’t execute. For example, ...
Bookmark a code to find it later

If you are working with long codes, you may want to bookmark the code. Here is the Tip You can bookmark a line of code in your Program Ed...
Examples of SAS's programmer friendliness

Truncated character comparisons The relational expression in if ( 'AB' = 'ABC' ) evaluates to False, since the shorte...
Create a progress bar in SAS

Progress bars are fairly easy to implement in SAS/AF however a little harder from base SAS. You can however produce progress bars for use ...
Creating SAS dataset using datalines gives error if written inside a macro

The error is something like this: ERROR: The macro X generated cards (data lines) for the DATA step which could cause incorrect result...
How to retrieve the first character of a variable in SAS

If you need to create a variable which has only first character of the character variable, then there are 4 different ways with which you c...
How to Improve SQL Merges

If you are looking to improve performance of your SQL code consider the following options: Include all your numeric, date or datetime v...
Using Wildcards in Variable Lists

You can use the colon as a variable modifier (e.g. abc:), which acts as a wildcard. So rather than entering variables abc1, abc3 and abcde...

Blog Archive

► 2014 (6)
- March (1)
- February (5)

▼ 2013 (69)
- October (6)
- August (51)
- July (12)

► 2012 (2)
- March (2)

Powered by Blogger.