SAS

quick question about how to import a user defined macro
The first data statement runs find. I am trying to replicate the right function found in Excel in SAS. However I wrote the macro for it but I am not sure if the way I am doing it is right. It is not giving me the result I want. /** mini program starts here */ data _null_; x='1-(310)-720-4206'; y = compress(x,'... 17 Jun 2010 16:45

Ab Initio Developers
Hi, Very good morning friends Urgent requirement looking for profiles please sent your consultant profiles to Lavanya(a)igiit.com POSITION Title: Ab Initio Developers LOCATION: Warren, NJ DURATION: 2 + years Experience Level: 7 – 8 + minimum RATE: $45 Description: • Good understanding of D/W and ETL conce... 17 Jun 2010 10:02

FYI: SAS 9.2 install on Ubuntu
Hi All, I recently posted installation instructions that worked for me. I installed SAS 9.2 (32 bit) on Ubuntu 9.10 (linux). In case anyone is interested here is the link to the Ubuntu forum. http://ubuntuforums.org/showthread.php?t=1494027 HTH, M ... 17 Jun 2010 10:02

spilt each word in a string and put in new variables
Hi All, i would appreciate your help with regard to the following. i have dataset that has multiple variables. i want to split the words in each variable and put in different variables with a suffx. lets say variables are X Y Z. new variables for each variable: x1 -xn y1 -yn z1 - zn below is an exam... 17 Jun 2010 08:56

proc sql where clause with macro variable problem with index
I have a large dataset (66 million rows) indexed on dt which is a datetime numeric. I have a macro variable &mdt = 01JAN1986:00:00:00 When I run my query: Proc sql; select * from x where dt = "&mkt"dt;quit it works but takes over a minute and a half to run. if I replace &mkt with '01JAN1986:00:00:00'DT... 17 Jun 2010 08:56

Error: No valid parameter points were found
Guys Need your help! I am using the proc nlmixed to model the following data; my codes follows. PROC IML; n_sim = 20; n_debtor = 10000; rho_V = 0.3; rho_Y = 0.25; rho_U = -0.9; beta_0 = -1.5; gamma_0 = 4; sigma = 2.5; Vektor = j(n_debtor,1,1); DO sim=1 TO n_sim; F=RANNOR(0); F_Vektor=F*Vektor; Z_V... 17 Jun 2010 05:41

SQL - File does not exist
Hi, When I declare an oracle lib name it works fine. When I connect to the database through SQL Plus , it works fine. If I do a desc schema.table_name works fine. However when I run a proc sql it says file schema.table_name.data does not exist. Any idea why ? Am I missing out on some thing ? appreciat... 17 Jun 2010 02:28

Free Project Management Software Trial Demo
Free Project Management Software Get it now!!!! Try it today Project management software by launched http://www.project-drive.net Visit project drive for FREE PROJECT MANAGEMENT SOFTWAR... 17 Jun 2010 01:23

Macro variable impacting performance
Can someone explain why there is this extraordinary impact to performance of the following proc sql statement: %let mdt = 30DEC1986:00:00:00; 17 %LET NEXT_MDT = 31JAN1987:00:00:00; 18 proc sql; 19 create table Temp_crsp_dly as 20 select * 21 from hold.gold_crsp_19671231 22 where ncusip in... 16 Jun 2010 22:07

Alternate row color in excl using dde
Hello Group I made some changes but It is filling up all the rows . %ExcelCreate( dsn1=,dsn2=xyz); some code ...... put '[select("c1:c6")]'; put '[formula("=mod(row(),2)=1")]'; put '[patterns(1, ,15)]'; put '[select("r1c1")]'; put '[SAVE.AS("c:\tempo\Bits' "&dsn2..xls" '")]'; put '[QUIT... 16 Jun 2010 17:42