SAS

How to get the last non-missing variable value
Abebe - With this structure it looks like the last date should be the maximum date. lastdate=max(of date1-date4); - Tom On Feb 21, 9:46 am, abebegashaw...(a)GMAIL.COM (Abebe Gashaw) wrote: Hi friends. I have a dataset which contains records with variables with contents and missing values as fol... 21 Feb 2010 12:37

How to get the last non-missing variable value
Hi friends. I have a dataset which contains records with variables with contents and missing values as follow: Data Test1; Input Name $ Action1 $ data1 $ Action2 $ Date2 $ Action3 $ data3 $ action4 $ date4$; Cards; Name1 read 02Feb10 write 03Feb10 name2 read 01Feb10 write 05Feb1... 21 Feb 2010 10:22

Macro variable and do loop
I think you are asking if you could just iterate ovar a list of dataset names? Similar to what you can with DATA step DO loop like this: do name = 'p_one','p_two','p_three' ; ... end; I do not know of a way to do that with macro logic, but you could use a delimited list of names in a macro variable ins... 22 Feb 2010 12:58

Data step Do loop to change the value of Macro Variable
data a; array x x1-x10; do i=1 to 10; x(i)=i; end; run; On Feb 21, 8:52 am, kuh...(a)126.COM (Clark An) wrote: %macro a;    data a;       %do i=1 %to 10;          X&i=&i;          output;       %end;    run; %mend a; If I dont wanna use macro %do,just u... 27 Feb 2010 19:53

Oracle Clinical: table RXC_DCI_BOOK_PAGES
Hi Denise, It has been a few years since I have poked around inside of OC, and I'm a bit fuzzy on some of the terminology, but have you tried: proc sql; connect to oracle(path=MYPATH user='MYuser' pass=XXXX); create table view as select * from connection to oracle (select * from RXC$DCI_BOOK_PAGES); ... 22 Feb 2010 15:16

How to remove BOTH duplicates in sort
Hi, proc sort nodup removes the second duplicate record but still keeps the first record. In my opinion, the duplicate data are highly suspicious and I wish to remove BOTH of the duplicates. How to do that? --- news://freenews.netfront.net/ - complaints: news(a)netfront.net --- ... 24 Feb 2010 09:43

Can one access result of sql feedback option?
On Sat, 20 Feb 2010 13:00:30 -0500, Arthur Tabachneck <art297(a)NETSCAPE.NET> wrote: While investigating one of this morning's posts, I was playing around with proc sql's feedback option. The original question was whether one could use a variable list in sql. Thus given data like: data have; input... 20 Feb 2010 16:52

Concordance logistic regression SAS
Dear All, Can someone help me with the following output while building a mode using logistic regression: Association of Predicted Probabilities and Observed Responses Percent Concordant 66.5 Somers' D 0.335 Percent Discordant 32.9 Gamma 0.337 Percent Tied 0.6 Tau-a 0.115 Pairs 497522982 c 0.668 I want to ... 22 Feb 2010 23:09

Can one access result of sql feedback option?
While investigating one of this morning's posts, I was playing around with proc sql's feedback option. The original question was whether one could use a variable list in sql. Thus given data like: data have; input qtr Col1 Col2 Col15676 Col15677 Col15678 Col15679 Col15680 Col15681 Col15683 ColX... 20 Feb 2010 14:38

SAS 9.2 CHAR to NUM
Dan, I presume you meant "rather than the old INPUT() method." I'm not on 9.2 yet but, regardless, you might be interested in the macro (from SAS) that can be found on Paul Dickman's page: http://www.pauldickman.com/teaching/sas/char_to_num.php HTH, Art -------- On Sat, 20 Feb 2010 09:46:23 -0500, Dan Ab... 20 Feb 2010 17:59