yanjiemaomao's articles:

Items(3) /1

How to subscribe this site to non-gmail account? 2 394 (3/28/2011 2:54:53 PM) comp.soft-sys.sas I would like to subscribe this to my company email....But how could I do that? I tried to subscribe SAS-L. But I don't like the format...It is kind of messy to me..Google groups seems better. Thanks. ... palapara

Question about transpose 2 197 (3/18/2011 5:29:05 PM) comp.soft-sys.sas Hi all, I have a question about the transpose. Say I have a data as following: ID PA1 PA2 PA3 PB1 PB2 PB3 1 29 86 41 24 85 29 2 34 70 31 79 60 8 3 6 31 76 30 88 8 4 68 24 90 30 80 90 5 99 99 74 39 5... palapara

How to specify a var is null in SAS? 6 467 (1/11/2011 3:15:09 PM) comp.soft-sys.sas Hi there, I think I have messed up the programming languages.. How to specify a var is null in SAS? Say I want to have a command: if id is null then id=lag(id); is the above correct or should be ... palapara

yanjiemaomao's replies:

Items(6) /1

Re: skip and fill logic in macro #2 2 24 (5/12/2009 3:06:16 PM) comp.soft-sys.sas There was an error in what I sent; here is a corrected version. data test; infile cards missover; input num_admissions admiss1_var1 admiss1_var2 admiss2_var1 admiss2_var2 admiss3_var1 admiss3_var2; cards; 1 20... mlhoward (1825)

Re: Deleting columns #6 1 18 (8/14/2009 6:10:04 PM) comp.soft-sys.sas I looked a second time at your post. A simpler approach is DATA one; input X; retain Y 0 ; if mod( x, 3 ) = 1 then y + 1; cards; 1 2 3 4 5 6 7 8 9 run; proc print data = one ; run; -----Original Message-----... nathaniel.wooding (1453)

Re: Date format #53 2 25 (8/17/2009 1:56:01 PM) comp.soft-sys.sas bobo, If you want that in a title or footnote, which seems not unlikely, you might not need the datstep after all... You can use the Funk in SysFunc, like this: title "Your datetime: %sysfunc(putn(%sysfunc(da... dirk.vk (59)

Merge with duplicates 4 23 (8/17/2009 6:44:12 PM) comp.soft-sys.sas Hello, I am trying to do the following. -Compare two data sets and flag every entry that occurs in BOTH data sets. However, I only want to output the rows in the first data set -- so if something is in th... behrens900 (2)

How to generate a unique numeric key variable from several columns 3 26 (8/18/2009 2:52:25 PM) comp.soft-sys.sas Hi All, I wonder if there is better way or function that I can generate a unique numeric key from several numeric keys. For example, Obs k1 k2 k3 k4 k5 1 1 1 11 4 9 2 1 1 1 14 9 Rig... chenming (26)

Cumulate y variable based on X variales 1 33 (8/21/2009 9:06:02 PM) comp.soft-sys.sas /* I want to cumulate my y variables until value of Xs reach 2 or less (include the time point when x <=2) for the first time. If x never reach 2 or less, set y as missing. In other words, how can I compute ... heidi.shea55 (6)