I have a data set of sales data by day. Unfortunately the names of the columns represent the dates. In order to work with the data, I need to transform the data set so each day represents an observation.The data set looks something like this:store _0…
Category: SAS
Delete observations from a SAS data set when all or most of variables has missing data
/* Sample data set */
data missing;
input n1 n2 n3 n4 n5 n6 n7 n8 c1 $ c2 $ c3 $ c4 $;
datalines;
1 . 1 . 1 . 1 4 a . c .
1 1 . . 2 . . 5 e . g h
1 . 1 . 3 . . 6 . . k i
1 . . . . . . . . . . .
1 . . . . . . . c . . .
. . . . . . . . ….
Using R for Data Management, Statistical Analysis and Graphics soon to start shipping
Our newest book, Using R for Data Management, Statistical Analysis and Graphics, is anticipated to soon start shipping from Amazon, CRC Press, and other fine retailers. The book complements our existing SAS and R book, particularly for users less inte…
Sending an email from SAS
Have you ever wanted to know when your code completes? Or maybe you want to automate the report to include sending an email? Regardless, SAS is happy to send that email for you. The easiest way to do this is through the SMTP access method via filename statements. Example: filename sendemail email ‘toaddress@email.com’ subject=’This is […]
SAS tip: Why you always should use a RUN statement
Always use a RUN statement
Interview with the M2010 Data Mining Conference Co-Chairs
Note: This is the first in a series of blog posts highlighting the annual M2010 Data Mining Conference, hosted by SAS Education. All subsequent posts will be designated with this snazzy little M2010 graphic.
The 13th annual Data Mining Conferenc…
Got dating problems? Use ANYDATE…
Many a times we might come across a situation where we would not be able to determine the informat of the date or datetime variable that needs to be read into the SAS dataset. Or me may at times fail to remember the informat name for a particular date …
Adding Abbreviation in SAS
I am a bad typer. And I have a short term memory loss. Remembering the syntax, typing a lot of code (especially the repeating ones)… Na… Not my cup of tea..SAS Enterprise Guide (4.1 onwards) has come up with a one shot solution for people suffering…