Please read the replies already provided above. ... View more

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas   Use PROC MEANS. See the documentation for details.    Vague questions get vague answers. If you want example code, you need to provide example data.    Good Luck.   @Hope18 wrote: I am calculating the adult equivalency for each household and would like to find the total value for all the members of the household.   ... View more

Hello @rava12, Your question requires more details before experts can help. Can you revise your question to include more information?    Review this checklist: Specify a meaningful subject line for your topic.  Avoid generic subjects like "need help," "SAS query," or "urgent." When appropriate, provide sample data in text or DATA step format.  See this article for one method you can use. If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message. It also helps to include an example (table or picture) of the result that you're trying to achieve. To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message.  From there you can adjust the title and add more details to the body of the message.  Or, simply reply to this message with any additional information you can supply.   SAS experts are eager to help -- help them by providing as much detail as you can.   This prewritten response was triggered for you by fellow SAS Support Communities member @sld . ... View more

1. Do you want uncorrelated or correlated observations? It looks like you are trying to use the RANDNORMAL function. If so, see the program below for the correct syntax. 2. The second argument to the SAMPLE function is the sample size, which is the number of indices in the range 1:n*p. This value must be greater than zero. proc iml; mean={0 0}; cov={1 0, 0 1}; p = ncol(mean); /* number of variables */ m=20; /* number of observations */ X=randnormal(m,mean,cov); /* multivariate normal */ t= 1:(m*p); /* 2nd argument is not a probability, it is the number of times to sample from t. Therefore the second argument must be an integer > 0 */ missIdx= sample(t, round(0.1*m*p) ); X[missIdx]=.; If you want to allow the possibility that no elements are set to missing, you can use a different method for generating the missing values. In the following statements, an nxp random matrix is generated where each cell has probability=0.01 of being 1.   /* Different approach: Each cell has 0.01 probability of being missing. */ B = j(m, p); call randgen(B, "Bernoulli", 0.01); missIdx=loc(B=1); if ncol(idx)>0 then X[missIdx]=.; ... View more

Thanks guys. I could download the SAS Studio after loading the java software. No problem. Regards Subramanian ... View more

Product Apr May Jun Jul  Aug Sep Oct Nov Dec Cur_month ROY A 1 2 1 4 2 1 1 2 1 1 15 B 2 3 1 4 2 1 1 2 1 2 17 C 2 3 1 4 2 1 1 2 1 2 17 D 2 3 1 4 2 1 1 2 1 2 17     Column Named "Cur_Month" and "ROY" is what I want to calculate.   As I have already mentioned, this table is dynamic...next month I will have data starting from May to Dec, in which case it will have to store May numbers in the Cur_Month and the rest of the months in ROY as a Sum(Jun+July+Aug+Sep+Oct+Nov+Dec)   Please note : I am using SAS Enterprise guide 7.1....I an use the program window to write the code or macro.   Thanks Ramaa ... View more

Homework? If you need help you need to provide more information, specifically, what are you trying to do, what do you have and what have you tried so far.      @elsalam wrote: Three questions:   1. convert all consonants in the values for country and state variable to uppercase all vowels to lowercase   2. use the variable super to indicate winner, runner up, and non - contenders notes:  winner for river, runner up for fox, non contenders for other teams   3. assign variable conference for each team: Bills belong to conference South River belong to conference SW   Thx           ... View more

@Danchek7 Making A LOT of assumptions what you're asking for below code could be an option. data have; input DATE :date9. YEARS_TO_END MONTHS_TO_END; format date date9.; datalines; 31MAR2016 03 3 ; run; data want; set have; format end_date date9.; end_date=intnx('month',date,12*years_to_end+months_to_end,'e'); run;   In EG you'd create a calculated column in a Query via a formula like: intnx('month',date,12*years_to_end+months_to_end,'e')   ... View more

SAS tech support said that mobile and desktop clients have multiple know bugs with nesting html via iframe.  I’m looking into report links inside VA.  Is there a way to create a landing page similar to html using report links.  I’m trying to create a menu bar with groups and sub groups. ... View more

- Yes crsp.dsf is currently ordered by permno and I will order it by cusip if I am using cusip. -For accuracy, I would prefer 90 records for each event (and the event dates are pretty disperse so making 15 days groups might be unnecessary) -they are the latest cusip form the master table. I thought of using gvkey which is unique but it shouldn't be big issue if there's change or split as I cut off the events that are not consistent of the first filling date and last filling date. - ... View more