Combining Graphs/Procs with Custom HTML in a SAS Stored Process

July 20, 2010
By
Combining Graphs/Procs with Custom HTML in a SAS Stored Process

The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or...
Read more »

Print global macro variables

July 20, 2010
By

The call symput("macroname", varname) is really useful for getting data from a data set into SAS code that's executed later.  One example is shown here.  This entry is inspired by a simulation project I'm coding right now where there are many...
Read more »

Find a String in UNIX

July 20, 2010
By
Find a String in UNIX

We've become so much addicted to find/search functionality these days that I tend to look out for Ctrl+F button when I want to find something on a hard bound book as well!!I had a requirement where I had to search for all the files in my home directory...
Read more »

“call symputX” is the symput upgrade

July 20, 2010
By

SymputX is the upgrade from Call Symput. Syntax: call symputx(“macro_var_name”, character_value (or numeric to be converted to char), symbol table def); Where symput will produce a note about converting character values to numeric, symputx won’t produce such a note. Additionally it will strip leading and trailing spaces form the character value. Lastly, you can...
Read more »

Converting SAS datasets to SPSS

July 19, 2010
By

If you want to view SAS dataset in SPSS you can use GET SAS command of SPSS. Here is the syntax; get sas data='C:\data\class.sas7bdat'. For conversion of SAS to SPSS we need to see if any formats assigned to variables in the dataset or not. ...
Read more »

Data Steps 2010-07-19 22:25:00

July 19, 2010
By

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...
Read more »

Delete observations from a SAS data set when all or most of variables has missing data

July 19, 2010
By

/* 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 . ....
Read more »

Using R for Data Management, Statistical Analysis and Graphics soon to start shipping

July 19, 2010
By
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...
Read more »

Sending an email from SAS

July 19, 2010
By

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...
Read more »

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.