muthia.kachirayan's articles:

Items(574) /58 Next >> Last >|

Re: calculating variables across repeated ids #8 0 30 (3/8/2010 8:56:03 PM) comp.soft-sys.sas Based on the output of Ya, I guess you can as well do by a data step using double Dow-loop. As you are new user, read a paper on DOW. Search for Paul Dorfman. data need; do until(last.id); set allfilled; ... muthia

Re: calculating variables across repeated ids 0 162 (3/8/2010 6:56:44 PM) comp.soft-sys.sas Does the sql solution help you? If you show the expected output for the data set shown here it will replace several lines of explanation and there will be several ways of doing it in SAS! Muthia Kachirayan... muthia

Re: calculating variables across repeated ids #2 0 32 (3/8/2010 5:51:09 PM) comp.soft-sys.sas On Mon, Mar 8, 2010 at 1:14 PM, Katy Seib wrote: > **Intro > First, thanks To Ron for posting the SAS-L wiki this morning- very helpful! > I too am relatively new to posting at the listserv but have enjoyed ... muthia

Re: Ranking by State #5 0 29 (3/4/2010 4:44:43 PM) comp.soft-sys.sas It is not unique colors but state. On Thu, Mar 4, 2010 at 12:40 PM, Muthia Kachirayan wrote: > I was late to read this thread. Mike Zdeb has given a solution based on > proc summary and proc rank. I was thin... muthia

Re: Ranking by State #4 0 26 (3/4/2010 4:40:12 PM) comp.soft-sys.sas I was late to read this thread. Mike Zdeb has given a solution based on proc summary and proc rank. I was thinking to use hash objects. It looked difficult at first to incorporate all the needs of the OP in a h... muthia

Re: Picking a value from one variable based on values in another #2 0 37 (2/26/2010 9:05:00 PM) comp.soft-sys.sas How about a double DoW-loop ? data sample; input Student time var $char1.; cards; 1 1 M 1 2 0 1 3 0 1 4 1 1 5 1 2 1 0 2 2 0 2 3 0 3 2 M 3 3 1 4 2 0 4 4 1 4 5 1 ; run; data need; do until(last.student); ... muthia

Re: sample random selection problem #4 0 30 (2/16/2010 11:44:08 PM) comp.soft-sys.sas The following changes are required to generate random number for selecting the Controls.. [1] add the statement num_Controls =3D num; between the following 2 statements. tot_num =3D num; CC_Flag =3D 1; [2] C... muthia

Re: sample random selection problem #3 0 37 (2/16/2010 10:27:15 PM) comp.soft-sys.sas df ss, The following data sets have been used. data controls; input ID age sex race; cards; 20 18 2 2 49 18 2 2 51 18 2 2 ; run; data cases; input ID age sex race; cards; 1 18 2 2 2 18 2 2 3 18 2 2 4 20 1 1 ... muthia

Re: How to attach a numeric index to column names for use in a 0 32 (2/9/2010 2:44:46 PM) comp.soft-sys.sas You can use array to represent all numeric variables of the data set with _NUMERIC_ and character variables with _CHARACTER_ and can process them to your heart's content loop-body. The efforts to make a list of... muthia

Re: Getting variables into Proc Report dynamically #6 0 32 (2/7/2010 12:15:56 AM) comp.soft-sys.sas How about having macro var for each variable of interest to achieve dynamic input to the Proc Report? %let var1 = sex; %let var2 = height; %let var3 = weight; proc report data = sashelp.class nowd; columns &v... muthia

muthia.kachirayan's replies:

Items(108) /11 Next >> Last >|

Condensing a data-set 3 273 (12/29/2009 5:27:09 PM) comp.soft-sys.sas Hi, I have a data set anlt lb aaa 1 aaa 2 aaa 3 bbb 2 bbb 4 bbb 5 ccc 1 ccc 2 ccc 3 ccc 4 ccc 6 I would like to summarise it in excel as anlt lb aaa 1,2,3 bbb 2,4,5 cc... Sandhya

Array sizes 1 241 (12/30/2009 12:19:28 PM) comp.soft-sys.sas Hello, I would like to if there is a maximum number of elements a one dimensional numeric array can have in sas. Similarly whats the max size for a one dimensional string array. Thanks ... oowar (18)

Passing a non-temporary array to a proc fcmp function 2 392 (1/6/2010 10:19:56 PM) comp.soft-sys.sas Hi there, I just learned about creating functions using proc fcmp that can be called in the data step. I would like to pass a non-temporary array to a function, but I do not think that this is allowed. P... kim.fernandes (3)

Comparing a value to a range to create a cut point 5 191 (1/11/2010 3:23:03 PM) comp.soft-sys.sas I have a data table with variable 'b'. I want to compare variable 'b' across a range of 9 values using a do loop. Depending on where varible 'b' falls I will create a new variable called add_months. I can ... rharvey3015 (2)

Creating Matrix Array 5 146 (1/18/2010 6:22:47 PM) comp.soft-sys.sas Hi, I have data that looks like the following: PERSONID DRUGIDS LENGTH 12 01411 4 12 01687-04337 14 12 01891 8 ... mike_green123

Reading in pre-fixed file layout 4 222 (1/20/2010 3:33:05 PM) comp.soft-sys.sas Hello: I have a .txt file that has been zipped that I am trying to read into SAS.... The layout is this: File Layout Length || From || To || Datatype* || Format || Description & Comments 1 || 1 || 1 || ... stats112 (342)

how to transpose two varaibles in datastep by using arrays? 3 277 (1/21/2010 11:04:43 AM) comp.soft-sys.sas Hi To all; I have datalike patid vrd seq hs ms 1001 0 1 100 229 1001 0 2 101 341 1001 0 3 ... hymadsk (80)

Find the position of max/min value in an unsorted array 6 865 (1/22/2010 2:05:10 AM) comp.soft-sys.sas Just come across this in my mind. MAX/MIN function in SAS is able to find the Max or Min value of a given array. If we want to position this max /min value in the array, we probablly have to do something like... dynamicpanel (219)

Ranking by State 6 276 (3/2/2010 11:14:10 PM) comp.soft-sys.sas I need help figuring out how to rank my results by state.For each color what is the rank(based on SumVal) for all states .. I have this SAS dataset State sumval Color AK 10 Red AK ... sdlentertd (64)

calculating variables across repeated ids 7 98 (3/8/2010 5:14:41 PM) comp.soft-sys.sas **Intro First, thanks To Ron for posting the SAS-L wiki this morning- very helpful! I too am relatively new to posting at the listserv but have enjoyed reading for a while. I'm a guest researcher at CDC an... uralva (9)