SAS

sample size determination
A chemist needs to estimate sample size to compare three calibration curves of 11 standard concentrations for chemical analysis for three different matrices. The null hypothesis is that there is no difference in the intercept and slope of the three calibration linear regression curves. The chemist would like to kno... 14 Dec 2009 17:42

Using PROC HTTP from mainframe SAS
I'm trying to figure out if it is possible to do geocoding (submitting addresses and receiving latitude and longitude coordinates in a file) using Google Maps API by going through PROC HTTP in SAS 9.2. My question here is not so much the geocoding part as the possible interface through SAS. I'm working in a z/OS ... 14 Dec 2009 16:35

Dynamic data set-Loop
Hello everyone, Can someone help me out with the following I am trying to dynamically combine few data sets and create one final data sets. Let say , If I have the following data sets – State wise State_il State_nj State_pa …etc When I try with the normal code . data combined_st; set state_il state_ma state... 14 Dec 2009 15:28

Dynamic data set-Loop
In 9.2 I think you can use the : operator to get everything starting with 'state_' with state:. In your macro, I think you need to take the semicolon out of the macro loop= , at minimum, and put 'set' before the macro loop. I don't imagine your macr= o would work anyway, but you may be leaving something out. ... 22 Dec 2009 05:58

Do loop to extract info from multiple consecutive rows.
Hi, I need to build a report about several cognos' cubes (dimensions, levels measures etc..) from .mdl files (ascii type) then contain the structure. First I import xxxx.mdl file and create variable x, than I exstract cube infos by scan(x, ....), because all infos are key-substring from first collumn. when I meet... 16 Dec 2009 07:56

Prevalence and Bias Index
When working with rater agreement with two raters on variables that have 2 levels (e.g. yes/no, True/False, etc.) I know you can get a prevalence index and a bias index simple enough. What about a prevalence/bias index for tables with greater than 2 responses? Say a 3x3 or 4x4 table. =20 Scott=20 ....and ... 14 Dec 2009 12:07

Tabulate
proc format ; value catfmt 0-1='Category 1' 2-5='Category 2' 6-10='Category 3'; run; proc tabulate data=have; class date var ID; table date*var='',ID*(N*f=8. pctn<var>='%'*f=8.)/misstext='0'; format var catfmt.; run; HTH Yu On Mon, Dec 14, 2009 at 6:16 AM, Randy <randistan69(a)hotmail.co... 15 Dec 2009 00:18

SAS dynamic arrays
Dynamic arrays are commonly used in SAS/SCL. The declaration and usage would be nearly the same as fortran, but you will need to use CLASS property arrays. This is not so easy with Base/ SAS, and with SAS/SCL I frequently use a series of three and four dimensional arrays, all of which are resized per observation.... 15 Dec 2009 13:21

PROC EXPORT excel formatting in SAS 9.2 on x64
Hi, I have just switched from 9.1.3 on x32 to 9.2 on x64, and now my exports are getting lost in translation. I have created a code to run a bunch of analyses/queries and then export these results to a formatted excel workbook with multiple sheets. Each of 20 sheets has conditional formatting (e.g., if p<0.0... 16 Dec 2009 14:35

New SAS tools for importing all of the sheets in a workbook or
The SAS Tech Report sent out a week or so ago has a link to a usage note th= at lists new SAS tools that speed up the process of importing Excel workboo= ks or Access data bases=2E The title of the note is=0D=0A=0D=0AUsage Note 1= 3348: Using SAS(r) autoimporterv9 programs to automatically import all work= sheets i... 14 Dec 2009 08:47