Snipplr http://snipplr.com/language/sas Recent snippets posted on Snipplr.com en-us Sat, 17 May 2008 11:55:51 GMT (SAS) Create a new data set for each BY-Group in a data set - webonomic http://snipplr.com/view/6212/create-a-new-data-set-for-each-bygroup-in-a-data-set/ This sample uses macro logic to determine the number of unique values of a variable (the BY variable) and creates a new data set for each. The resulting data set names will be the BY variable value. Limitations: The sample code does not allow for BY values of longer than 32 positions, numeric BY values or BY values that contain characters that are not permitted in SAS data set names. If your data contains any of the above, you must add program statements to convert your BY values into valid SAS data set names.

]]> Tue, 13 May 2008 17:23:08 GMT http://snipplr.com/view/6212/create-a-new-data-set-for-each-bygroup-in-a-data-set/ (SAS) SAS String Parsing - webonomic http://snipplr.com/view/6111/sas-string-parsing/ Need to construct and ID of the first 5 letters and the last 7 digits

]]> Sat, 03 May 2008 15:52:36 GMT http://snipplr.com/view/6111/sas-string-parsing/ (SAS) Merge datasets with unlike variable names - webonomic http://snipplr.com/view/6110/merge-datasets-with-unlike-variable-names/

]]> Sat, 03 May 2008 15:26:35 GMT http://snipplr.com/view/6110/merge-datasets-with-unlike-variable-names/ (SAS) Using Proc SQL to summarize tables into groupings - webonomic http://snipplr.com/view/6109/using-proc-sql-to-summarize-tables-into-groupings/ Using Proc SQL summarize the table sashelp.shoes grouping on

]]> Sat, 03 May 2008 15:19:18 GMT http://snipplr.com/view/6109/using-proc-sql-to-summarize-tables-into-groupings/ (SAS) Create one response from "check all that apply" variables - webonomic http://snipplr.com/view/5748/create-one-response-from-check-all-that-apply-variables/ Below is some code written for creating one response from survey questions where the respondent checks all that apply.

]]> Tue, 08 Apr 2008 03:33:17 GMT http://snipplr.com/view/5748/create-one-response-from-check-all-that-apply-variables/ (SAS) Paired Bar Chart - webonomic http://snipplr.com/view/5648/paired-bar-chart/

]]> Tue, 01 Apr 2008 14:03:20 GMT http://snipplr.com/view/5648/paired-bar-chart/ (SAS) Logical Expressions In SQL - webonomic http://snipplr.com/view/5647/logical-expressions-in-sql/

]]> Tue, 01 Apr 2008 13:39:05 GMT http://snipplr.com/view/5647/logical-expressions-in-sql/ (SAS) Convert Excel to SAS Dataset - webonomic http://snipplr.com/view/5646/convert-excel-to-sas-dataset/

]]> Tue, 01 Apr 2008 13:16:40 GMT http://snipplr.com/view/5646/convert-excel-to-sas-dataset/ (SAS) Send SAS Data to Excel - webonomic http://snipplr.com/view/5637/send-sas-data-to-excel/

]]> Mon, 31 Mar 2008 15:01:04 GMT http://snipplr.com/view/5637/send-sas-data-to-excel/ (SAS) Connecting to Microsoft SQL Server from SAS with OleDB - webonomic http://snipplr.com/view/5636/connecting-to-microsoft-sql-server-from-sas-with-oledb/

]]> Mon, 31 Mar 2008 14:57:32 GMT http://snipplr.com/view/5636/connecting-to-microsoft-sql-server-from-sas-with-oledb/ (SAS) Word Count 2 - webonomic http://snipplr.com/view/5635/word-count-2/

]]> Mon, 31 Mar 2008 14:38:00 GMT http://snipplr.com/view/5635/word-count-2/ (SAS) Word Frequency Count - webonomic http://snipplr.com/view/5634/word-frequency-count/

]]> Mon, 31 Mar 2008 14:27:51 GMT http://snipplr.com/view/5634/word-frequency-count/ (SAS) Reusable Data Merge Macro - webonomic http://snipplr.com/view/5633/reusable-data-merge-macro/

]]> Mon, 31 Mar 2008 14:12:47 GMT http://snipplr.com/view/5633/reusable-data-merge-macro/ (SAS) Setting variable value based on value of another variable. - webonomic http://snipplr.com/view/5632/setting-variable-value-based-on-value-of-another-variable/

]]> Mon, 31 Mar 2008 13:58:33 GMT http://snipplr.com/view/5632/setting-variable-value-based-on-value-of-another-variable/ (SAS) String Matching - webonomic http://snipplr.com/view/5631/string-matching/

]]> Mon, 31 Mar 2008 13:50:36 GMT http://snipplr.com/view/5631/string-matching/ (SAS) Cummulative Totals - webonomic http://snipplr.com/view/5630/cummulative-totals/

]]> Mon, 31 Mar 2008 13:45:45 GMT http://snipplr.com/view/5630/cummulative-totals/ (SAS) Display Percentages in Pie Charts - webonomic http://snipplr.com/view/5629/display-percentages-in-pie-charts/

]]> Mon, 31 Mar 2008 13:32:48 GMT http://snipplr.com/view/5629/display-percentages-in-pie-charts/ (SAS) Get Computer Name - webonomic http://snipplr.com/view/5628/get-computer-name/ This code will help you to get the name of the computer you are running he code from.

]]> Mon, 31 Mar 2008 13:27:53 GMT http://snipplr.com/view/5628/get-computer-name/ (SAS) Traffic Light Analysis - webonomic http://snipplr.com/view/5627/traffic-light-analysis/ Colour code table cells to help visually reveal results.

]]> Mon, 31 Mar 2008 13:16:22 GMT http://snipplr.com/view/5627/traffic-light-analysis/ (SAS) Test Dataset: Class - webonomic http://snipplr.com/view/5626/test-dataset-class/ This code simply creates a test dataset that can be used when testing new code.

]]> Mon, 31 Mar 2008 12:54:35 GMT http://snipplr.com/view/5626/test-dataset-class/