SAS

Year to date calculation in OLAP cube
I have fiscal year and fiscal month as dimensions in my OLAP cube as well as revenue as a measure. I would like to have a rolling total by fiscal year that calculates the year to date revenue. This is my current attempt (which does not work): Sum(YTD([Years].[FY]),[MEASURES].[Sum Revenue]), FORMAT_STRING="DOLLAR... 24 Mar 2010 12:19

converting character datetime(ISO) to numeric datetime20.
Hi All, I have a character date dtc(2008-01-12T00:00:00 ) in data have. i want to create a new variable dtnum with datetime20. format as 12JAN2008:00:00:00. i am looking for a function or better way of doing then what i am doing now. in data want i create using three steps. is there a better way or does SAS pr... 24 Mar 2010 13:29

Create new variable by quater
Suppose I have a file like this: car.csv BRAND ADVERTISE SALE1998Q4 SALE1999Q1 SALE1999Q2 SALE1999Q3 SALE1999Q4 TOYOTA 1999/07/01 200 450 300 500 650 FORD 1999/01/01 751 654 873 654 541 How do... 24 Mar 2010 19:19

MDB files compare
Hello, Is there a way to compare SAS files that have extension .sas7mdb? I used proc compare to compare .sas7bdat (data) files, but it is throwing me errors when i tried to compare MDB files. I highly appreciate any help. Thank you Sri ... 23 Mar 2010 15:57

how to obtain level2 and level3 residual separately in a three level Mixed model
Hi SAS experts, I have a three level model like this: proc mixed data=test; class schoolid teacherid ; model post = istx prec / solution outp=r outpm=mr covb influence ddfm=bw ; random intercept / sub=teacherid(schoolid) solution G; random intercept / sub=schoolid solution G; run; I know outp r c... 23 Mar 2010 14:47

National characters and export to SPSS
Hi all, I wonder if anyone has experience with exporting national characters from SAS (sas7bdat) to SPSS (sav). Here's my problem: * I have a UTF-8 encoded SAS file (sas7bdat) * I export this file to SPSS (sav) using PROC EXPORT * When I re-import the file to SAS everything's just fine, but when I... 13 Apr 2010 06:10

How to estimate Weibull distribution parameter
Dear all, I have a variable with weibull distribution, however I can only get this variable's frequency distribution, followed is the sample data. I want to ask: 1. how to estimate the weibull distribution parameter with such data information? 2. if I want to use Maximum likelihood Estimation method, how to d... 23 Mar 2010 10:06

v-fold cross validation in Clustering
Is it possible to perform v-fold cross-validation using some standard procedure in SAS to determine the optimal number of Clusters? What else could be used to determine the optimal number of Clusters in a dataset? ... 23 Mar 2010 07:50

Win/DOS wild card filenames to Perl regular expression.
I am trying to make a system where it would be convenient to convert a Windows\DOS filename expression with wild cards to an equivalent Perl regular expression. Examples of DOS filenames: *.* ?er*.sas r?p.*s e??d*.r* ??.? Does anybody happen to have, or know how to create, a SAS function (or a SAS ma... 25 Mar 2010 04:38

HELP: Somers' D
Hi all! Anyone knows what is the difference between "Somers' D in FREQ Procedure" and "Somers' D in LOGISTIC Procedure"? I've got, sometimes, different results. Examples: proc freq data=DATA; tables event*Score / trend measures cl noprint; output out=resultat smdcr; test smdcr; ex... 23 Mar 2010 05:37