SASTechies

SAS Analytics Delivered to iPhone

• Deliver SAS Reports and Data to Mobile Users
• User Friendly Interface for Parameter Selection without Programming
• Capture Real Time Data from SAS Directly from your iPhone
• Intuitive Web Interface for Administrators and Power Users
• Deliver Powerful Business Intelligence to iPhone®

Any SAS macros, programs or data can be delivered to iPhone. By simply registering the programs or SAS libraries, you can make this available to specified users who connect via standard 3G or Wifi network and results are delivered into a viewer on iPhone. This is executed in real time so the user gets always the latest data.

There are a number of ways to export data from SAS into Microsoft Excel. However, very few allow for exporting into custom-formatted spreadsheets such as those demanded for specific reports, in which explicit attributes such as font sizes and column widths are required. Traditionally, Dynamic Data Exchange (DDE) was the only way to do this. Now there are newer methods for this which are considered superior...

Various methods are ---

1. Proc Export / SAS Export wizard
2. Dynamic Data Exchange (DDE)
3. ODS CSV / HTML xls file route...create a .csv file and open with Excel
4. SAS to Excel via XML
5. Libname with xls
6. Using Display manager command Dexport to create a csv file

Export SAS datasets to Excel


1. Proc Export / SAS Export wizard




2. Dynamic Data Exchange (DDE)








Export SAS datasets to Excel with DDE -




3. ODS CSV / HTML xls file route...create a .csv file and open with Excel






4. SAS to Excel via XML


Export SAS datasets to Excel via XML -



5. Libname with xls


Export SAS datasets to Excel -

6. Using Display manager command Dexport to create a csv file....The Display manaager (DM Dexport) command invokes the External File Interface of SAS...

Point and Click SAS Getting Started with SAS � Enterprise Guide� 4.1 -


Introduction to SAS Enterprise Guide 4.1 for Statistical Analysis -


SAS Enterprise Guide 4.1 -

TS-DOC TS-440 - How can I use PROC COMPARE to produce a report ... -

SAS Macros that Convert a Directory of Transport Files @ http://www.sas.com/govedu/fda/macro.html

Parallel processing SAS Batch jobs in Windows -

Running SAS in batch mode in Windows OS -

This sample shows a macro version and the data step version that can be used to find the nth business day of a given month and year.

This example uses the INTNX function to increment the date, time, or datetime value by a given interval or intervals.
http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000212700.htm

This macro is a modified version of the Source: http://support.sas.com/kb/37/632.html

SAS ODS Tips Sheets from SAS Institute

ODS

ODS DOCUMENT

ODS PDF

ODS RTF

ODS TAGSETS.RTF (SAS 9.2)

PROC TEMPLATE tables

PROC TEMPLATE styles

Reporting PROCs styles

Hash object

Perl regular expressions

SAS Slides 13 : Using Proc SQL


Introduction to Proc SQL


Introduction to Proc SQL -

Proc SQL: When and how to use it



PROC SQL When and How to Use It -


Top 10 Reasons to Learn Proc SQL

http://www2.sas.com/proceedings/sugi22/ADVTUTOR/PAPER35.PDF


Creating Macro variables with Proc SQL

http://www.cinsug.org/docs/frey/SELECTINTO.pdf


How can I get a new column like _N_ in my SAS table using PROC SQL



How can I get a new column like _N_ in my SAS table using PROC SQL ... -



Comparing SAS steps and PROC SQL_ Coding and Performance


Comparing SAS steps and PROC SQL_ Coding and Performance -

SAS Proc SQL example with Flow Diagram

www.pauldickman.com/teaching/sas/proc_sql_code_20041026.pdf

PROC SQL Why Use It When Simple IF THEN


PROC SQL Why Use It When Simple IF THEN -


SAS Learning Module Collapsing across observations using proc sql

SAS Learning Module Match merging data files using proc sql

Obtaining the Filename and Full Path of Submitted Programs

When you submit code or a catalog entry from the Enhanced Editor, the filename or catalog entry name and their respective folders are placed in these environment variables:

SAS_EXECFILEPATH

contains the full path of the submitted program or catalog entry. The full path includes the folder and the filename.

SAS_EXECFILENAME

contains only the name of the submitted program or the catalog entry name.

You can then extract the filename and full path for use in your SAS programs.

After the following DATA step runs and the data is sorted, the PRINT procedure includes the filename in the title and the full path in the footnote of the procedure output. The results are shown below as a Screen Shot

data oranges;

   input variety $ flavor texture looks;

   total=flavor+texture+looks;

cards;

navel 9 8 6

temple 7 7 7

valencias 8 9 9

mandarins 5 7 9

;

 

proc sort data=oranges;

   by descending total;

run;

 

proc print data=oranges;

title 'Taste Test Results for Oranges using File ' %sysget(SAS_EXECFILENAME);

footnote 'The full path is ' %sysget(SAS_EXECFILEPATH);

run;

The resulting output displays the filename in the title and the full path in the footnote:

Using an Environment Variable to Place a Filename in DATA Step Output

These environment variables are set only when code is submitted using the Enhanced Editor in the Windows environment. They are not set when you submit SCL code or when you submit code in a batch session.

However, when SAS is running in batch mode, you can obtain the full path (which includes the filename) by submitting %sysfunc(getoption(SYSIN)) . The following macro can be used to obtain the full path in both a batch session and an interactive session by using the Enhanced Editor:

%let execpath=" ";

%macro setexecpath;

   %let execpath=%sysfunc(GetOption(SYSIN));

   %if %length(&execpath)=0

      %then %let execpath=%sysget(SAS_EXECFILEPATH);

%mend setexecpath;

 

%setexecpath;

%put &execpath;

You can also use the following %PUT macro statements to display the filename and full path in the SAS log:

%put Submitted file path is %sysget(SAS_EXECFILEPATH).;

%put Submitted file name is %sysget(SAS_EXECFILENAME).;

 

Source: http://support.sas.com/onlinedoc/913/getDoc/en/hostwin.hlp/editor_enhanced.htm#eegetfilename

 

SAS Code Examples




SAS STAT Examples

SAS Macros


SAS Annotated Output

SAS Library


What statistical analysis should I use?


SAS Textbook Examples
David Franklin's Examples

Common Programming Mistake with Proc Sort NODUPRECS -

PROC PRINTTO <option(s)>;

To do this	Use this option
provide a description for a SAS log or procedure output stored in a SAS catalog entry	LABEL=
route the SAS log to a permanent external file or SAS catalog entry	LOG=
combine the SAS log and procedure output into a single file	LOG= and PRINT= with same destination
replace the file instead of appending to it	NEW
route procedure output to a permanent external file or SAS catalog entry or printer.	PRINT=