SAS & Statistics

Click Here  

Notes taken from PharmSUG seminar SOUNDEX (Sound Alike) Ignore case, embedded blanks and punctuations; works best with English-sounding n...

varname = compress(varname, , 'kw'); The modifier “k” stands for ‘KEEP’ and the modifier “w” stands for ‘WRITABLE’. When compress ...

data km;   seed=12345;   do loc=1 to 2;     do time=2 to 22 by 1+int(4*ranuni(seed));       status=int(2*ranuni(seed));       output; ...

retain seed 111618; call ranuni(seed, ranno);

VVALUEX VVALUE

Include the GROUPORDER=ASCENDING option in the VBARPARM statements.  For example: vbarparm category=subject response=&var /       ...

INSET  "Mean of the best percent change = &pmean." / position = bottomleft; Example:  Click Here  and  Here

Click Here %macro readpass(xlsfile1,xlsfile2,passwd,outfile,sheetname,getnames); options macrogen symbolgen mprint nocaps; options noxwa...

Click Here

For "ERROR: Some character data was lost during transcoding in the dataset DB.XXXDAT. Either the data contains characters that are not ...

Click Here

ods escapechar= "^" ; proc report data = statsp nowd split = '|' headline headskip             style(report) = [as...

proc import file = 'C:\Users\procx\sample.xls'         out =test dbms =xls replace;         sheet =disposition;         na...

Fisher's Exact test can be memory and computation extensive when the sample size is large. For the large sample size problem, you can u...

Highlight a row:   compute __stresc;   if index(__stresc,'>') then call define(_row_,"style","style={backg...

Click Here And Here Here

This is a good blog!

Click Here

Click Here

One can avoid this error by putting a dummy analysis variable on the end of the COLUMN statement.  For example: proc report data=test head...

Click Here And Here

Click Here Click Here Too

Click Here The following codes are copied from the above link. options ls=132 ps=53 nocenter; ******************************************...

This sample is from the SAS Sample Library. For additional information refer to SAS Help and Online Documentation. /********************...

For Video Click Here For Article Click Here and Here Change SAS email options and use SMTP email.   Refer to:     http://support...

An Introduction to Perl Regular Expressions in SAS 9 SAS 9 – Perl Regular Expressions Tip Sheet

Secrets of Macro Quoting Functions - How and Why

proc template;   define style timesrtf;   parent=styles.journal;   replace fonts /      'BatchFixedFont' = ('Times',9pt)    ...

Using RTF codes in ODS RTF outputs Enhancing RTF Output with RTF Control Words and In-Line Formatting

Use TO_NUMBER function in PROC SQL. proc sql;    connect to oracle (user=xxx orapw=yyy path="@zzz");      create table temp a...

A Gentle Tutorial in Bayesian Statistics

Example of finding power of a balanced one way ANOVA: proc power;         onewayanova test = overall         groupmeans = 59 | 66 | 42  ...

Click Here

An archive of SAS webinars

Click Here

Link to download free version

Interviewing and Accessing SAS Programmers

This example uses the DATA step to create a transport file for one data set. libname source 'SAS-data-library'; libname xportout x...

Desired result: This sample program uses PROC GREPLAY together with macro code to dynamically replay a specific number of graphs per page...

%SYSFUNC

File Permissions - chmod

By Mark Madsen

ODS EXCLUDE EngineHost ; SAS default behavior is for this statement to be in effect only until the next procedure it encounters. To tell...

data one; input id $; /* create formatting to preserve leading zeros in excel */ cid&nbsp =&nbsp '&nbsp=&nbsp"&...

*** Create transport file; libname source "/home/kwxxx/requests/xxxdata"; libname tran xport "/home/kwxx/requests/xxxdata/...

First, enter the following command to see your SAS job that are currently running: &nbsp &nbsp &nbsp ps -ef|grep kwxxxx And you...

libname fmts "/temp/formats"; proc format library=fmts cntlout =fmts.fmtout; run;

data _null_; &nbsp &nbsp &nbsp do i=0 to 255; &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp x=byte(i); &nbsp ...

LAG Function (SAS 9.2 Doc) *** Use a third variable to assign the value from the previous record; array one a b c d; array two e f g h; ...

%macro vol(type,desc); proc report data=fmxx center headline headskip split='/'; &nbsp &nbsp &nbsp column site_id havevi...

I ran into some problems with the interpretation of the parameter estimate of the logistic model recently. When I contacted SAS, here's ...

Use the AUTOHREF and AUTOVREF options on the PLOT statement of PROC GPLOT to draw reference lines at all major tickmarks. Create an annotat...

An additional option that you should be aware of when using SELECTION= with a model that has the interaction as a possible variable is the H...

libname oradb Oracle User=orauser Password=xxxxxxx Path="@orapth"; proc sql; &nbsp &nbsp &nbsp create table oradb.dsn ...