hi, this is my code;   Data Olympics.case7; set Olympics.Case1; label Probability____="Probabilty"; label Total_Media_Value="Tot_Budget"; label Opportunity_Owner="Champ"; label Account_Name="Client"; label Stage="Nbr_of_optys"; rename Probability____=Probabilty; rename Total_Media_Value=Tot_Budget; rename Oppurtunity_Owner=Champ; rename Account_Name=Client; rename Stage=Nbr_of_optys; run; proc report data=Olympics.Case7 nowd headline headskip; column Probabilty nbr_of_optys tot_budget tot_forecast; define Probabilty/group width=12 descending "Probabilty"; define tot_budget/analysis sum format=dollar15.2 "tot_budget"; define nbr_of_optys /"nbr_of_optys"; define tot_forecast / computed format=dollar15.2; compute tot_forecast; tot_forecast=tot_budget.sum*Probabilty*0.01; endcomp; rbreak after/summarize ; run; i am not able to get the output   output should be like this : London Olympic Pipeline As of 17th November 2012                 Probability Nbr_of_Optys   Tot_Budget Tot_Forecast 100   7   $171,675,000 $171,675,000                 90   4   $205,000,000 $184,500,000                 70   8   $264,000,000 $184,800,000                 50   20   $127,040,000 $63,520,000                 30   3   $2,450,000 $735,000                 10   319   $333,729,670 $0                       361 $1,103,894,670 $605,230,000   ... View more

Hi, This is my code : Proc report data=Olympics.Case7 nowd headline headskip; Column Probability Nbr_of_optys Tot_Budget Tot_Forecast; define Probability/Group width=12 descending"Probabilty'; define Tot_Budget/Analysis SUM FORMAT=Dollar15.2"Tot_Budget"; define N/"Nbr_of_optys"; define Tot_Forecast/Computed format=Dollar15.2; Tot_Forecast=Tot_Budget.sum*Probabilty*0.01; endcomp; rbreak after/summarize ; run;  i am getting a error: : Statement is not valid or it is used out of proper order. ... View more

Hi, Identify words in a list supplied as macro parameter. Start with the first word and continue as long as more words are found. if no further word is found,display a message .*/ what should be the code ? ... View more

hi, what should be the code ? In the SMB Usage data create a another column to identify churners by using Product_id as key variable (check if the key variable is Unique ID in this case).The list of churners is given in the 'churners and labels' along with churn month. use Left join or right Join ? ... View more

hi,   what should be the code ? In the SMB usage data create another column to identify churners by using Product_ID as key variable (check if the key variable is unique ID in this case ).The list of churners is given in the 'Churners and labels' along with churn month .Use left join or Right Join? ... View more

hi,  what should be the code for this  question ? In the SMB usage data, create another column  to identify churners by using product_ID as key variable (check if the key variable is uniqueID  in this case ).the list of churners is given in the 'Churners and labels' along with churn month .use LEFT JOIN OR Right Join . ... View more

hi, what should be the code for this question ? In the Grocery_coupons categorize the respondents i) into 3 categories based on their spending (below 100, 100-200 and above 200) ii) count the number of unique customers in each group ( using Select case when )? using proc sql ... View more

hi, what should be the code ? Calculate the average Call duration ,count of local calls, and total usage charge for churners and non churners for all the 6 months i) for year 2011ii) for year 2010 and where average call duration is less than 60 seconds . using proc sql ? ... View more

HI, what should be the code for this question ?   Create a sub-set of the SMB Usage data only with usage variables for July,August,september rather than all the 6 Months using Proc sql ?     ... View more

hi , what should be the code for this question ?   select Product_ID, Age on Network fields and calculate Average,MIN,MAX age of network ,using PROC SQL ? ... View more

   hi, this is the data set  name: Nicholas,KregFL Reddy,RamanBT Strehle,FlorainGE Debergh,ChristopherFL   MY CODE IS : Data First_name3; set Starting_position; First_name=SUBSTR(Name,Starting_postion,","); Run; i am not getting the first name from this code. please help ?  how to create a new variable first name from  name variable using SUBSTR function ?       ... View more

hi, My Question is : USING WHEN-SELECT STATEMENTS,how can we  define a new variable providing the country of origin for each model based on the manufacturer .?? what should be the code ? ... View more