SAS

Populating variables
Several ways to do this; I'll post two. Retain, and a simple datastep: data want; set have; retain _VarA; if not missing(VarA) then _VarA = VarA; else VarA = _VarA; drop _varA; run; If it's always on the first record for each date, then you can [and should] use it like: data want; set have; by date; ... 5 Oct 2009 11:16

Unable to Repair Large Data Set
Why couldn't you just re-create the index? Something like: data large; do keyA=1 to 10000; keyB=ceil(ranuni(0)*1000); output; end; run; proc sql; create index keyAKeyB on large ( KeyA,Keyb); create index KeyB on large ( Keyb); quit; ... 6 Oct 2009 03:13

Looking for VAX/VMS SAS version 5.x/6.x
Hello All, I am a veteran SAS user, as well as the "owner and curator" of "The World's First MicroVAX II Museum". The museum is built like a computer room from the late 80's, and it is my humble contribution to the preservation of computer history (http://www.microvax2.org). For over 5 years now I am looking ... 3 Oct 2009 13:16

What's wrong with this ftp code?
I think DIR and CD options are not compatible, so if you specify a directory you cannot use DIR; Try the "list" command to get file attributes; I tested the following on a Unix server: filename dir ftp '' cd='/test' list user="USERNAME" pass="password" host="SERVER"; data _null_; ... 1 Oct 2009 21:49

Rand () function in SAS
Hi all, I have a few questions on the RAND () function in SAS. How does this function work? I know that one has to supply the 'seed' value first by, CALL STREAMINIT (seed); x=rand('dist', mu, sigma); But it seems that changing the value of the 'seed' changes the values of 'x'. Why is that? If I compute ... 1 Oct 2009 16:12

PROC IMPORT Bug in 9.2 TS2M0
FYI: My years-old PROC IMPORT code broke in 9.2 TS2M0. Here's an explanation and a suggested work-around from SAS tech support: The algorithm to determine if a value is a date, datetime or time was changed in SAS 9.2. Unfortunately it looks like there is a problem with typing some of the values to... 2 Oct 2009 13:10

ODS tagsets.excelxp: What is possible and what not?
Hi everyone, Today I looked into ODS markup for the first time and tried to figure out whether I could fulfill my current task with ODS tagsets.excelxp. I read through the help text that I generated with "ods tagsets.excelxp options ( doc = 'help' ) ;" and my impression is that I can't fulfill my requirements li... 2 Oct 2009 10:52

Need Help with Excel headers
Hi, I'm trying to rotate the variable names in my excel output so that my report looks compact. Right now I have to scroll left as my var names are too big. HEre is what I'm using : proc print data=Visit1 style(report)={rules=none } style(header)={font_weight=bold htmlstyle="mso-rotate:90;cellheight: 5pt;ce... 1 Oct 2009 10:33

proc inbreed
I have been trying to use the inbreed procedure in SAS. I have a large pedigree file (~540,000 records) consisting of Animal Sire Dam identification codes. Proc inbreed supposedly can handle large pedigree files. However I am getting an Out of Memory error. I'm just specifying the procedure as proc inbreed data=p... 30 Sep 2009 13:31

excel rate function
Hi, Can anybody help me on how to emulate the RATE excel funtion in sas? Thanks in advance. ... 28 Sep 2009 17:02