SAS

HASH HELP NEEDED
Thanks to anyone who can help me with this. I am working with two large datasets. The first table, JAN, is huge, 140million records, distinct by PersonID, EventDate and Hour. PersonID EventDate Hour EventAmt The second table, MASTER, has 2 fields RateCode and Cycle that I need to lookup and put onto the... 20 Apr 2010 18:29

HASH Help Needed
I am working with two large datasets. The first table, JAN, is huge, 140million records, distinct by PersonID, EventDate and Hour: PersonID EventDate Hour EventAmt The second table, MASTER, has 2 fields RateCode and Cycle that I need to lookup and put onto the first file. A person can have different ... 20 Apr 2010 15:59

using ds2csv with char substitution
Hi guys, I'm a SAS noob and need your help I want to take all the SAS data set files in a directory and convert them to csv files I want to use %ds2csv (data=myfolder."&char", runmode=b, csvfile="&char".csv); where myfolder is a LIBNAME and char is the filename in an array of filenames I created in a previo... 20 Apr 2010 18:29

if last statement with missing
Hi all, I have data that looks like this: Id visit outcome 1 1 0 1 2 0 1 3 0 1 4 1 1 5 . 1 6 . 2 1 0 2 2 0 2 3 . 2 4 . ho... 27 Apr 2010 05:24

HASH Help Needed
Hi The "issue" is that hash tables use exact key matches but you have to deal with a date range. The option multidata: 'y' in the declare statement allow to load multiple observations per key into the hash table. The approach is to first match over the ID and then loop through the subset to find the obse... 20 Apr 2010 15:59

Hazardratio statement in Proc Phreg
Hi all, I am using SAS v9.2 for a survival analysis in Proc Phreg. Below is a piece of my syntax: hazardratio 'X for Y=1' X / diff=all at (Y='1') ; hazardratio 'X for Y=0' X / diff=all at (Y='0') ; model delai*censor(0)=X Y / risklimits ties=exact; The results are exactly the same for Y=0 and Y=1, an... 20 Apr 2010 15:59

expanding observation by 1 min time interval
Hi, I have a dataset that has date, time and price. It is supposed to give you a whole 24 hr period in 1 minute interval by date. But as you can see, the value in the time variables skips.(ex. 00:00:00 ---> 00:03:00) What I am trying to do is to output all 24 hr period in 1 minute time interval by date without s... 20 Apr 2010 15:59

residual check for multilevel level model
Hi everyone. I fitted a 3-level model something like below: proc mixed data=out covtest cl ic method=reml; class plant worker; model log_exp= A B C B*C / ddfm=satterth solution; random int / subject=plant solution; random int / subject=plant*worker solution; run; And may I please ask how should I chec... 20 Apr 2010 15:59

SAS / SQL help with arrays & joins
I have what I think is a pretty easy question. I have two medical tables that I'm working with. Table1 has one record per patient and each patient's record contains 15 diagnosis fields (DX1-DX15). Table2 contains extra information about the patients and could have multiple records per patient. (both tables use ... 27 Apr 2010 16:47

convert GMT to CST
Hi, I have a dataset that has Greenwich time (GMT) with GMT_Offset. I need to convert GMT to CST (Central Standard Time) by using gmt_offset var. But I get a problem when gmt is between 00:00 and 05:59, which gives me a negative time,and wrong minute. Could you please help me on this logic ? Thanks, db data tes... 20 Apr 2010 15:59