i want to create labels for a dataset  using proc sql. i used the code proc sql; select PRODUCT_ID label="Line number" from a6.SMB; quit; but in the result the column name product_id is changed to line number. In the original smb data-set the label has not been modified . Why is it not working ? ... View more

Hi, i am using ods pdf and i have 5 tables in total , i want the first two tables in the same page and the next three on separate pages. How to do it? ... View more

  Question 1 --In i my data i have the columns - probability and Budget. I want to group the data by probability and get sum of budget = Total budget for each probability level. I also want a variable named foretasted Budget which which has product of total budget and probability  how do i get this with proc means.? My half written code- proc means data = c1.od noprint nonobs; var Total_Media_Value ; class _probability___/ descending; output out=data (drop = _TYPE_ _FREQ_) sum = Total_Budget n= num_of_optys; run; Question 2-- in the output i am getting a row which gives me total of columns. I want to give  that row a name - Total , how do i do that? eg- my result looks like this -                 probability  total budget  num 1 . 3200531 361 2 100 68100 7 3 90 56000 4 4 70 23200 8 5 50 156500 18 6 30 112000 5 7 10 2784731 319 i want the first row at the end and have it named total ... View more

I am creating a report where i am grouping by probability but i dont want the row with probability=0 to be included. How to do that? proc report data= c1.o; columns probability____ probability____=opp Total_Media_Value Forecasted_Budget ; define probability____ / group descending 'Probability'; define Total_Media_Value / SUM 'Total Budget' format= dollar30. ; define Forecasted_Budget/ computed 'Forecasted Budget'format= dollar30.; compute Forecasted_Budget; Forecasted_Budget= (Total_Media_Value.sum)*(probability____); endcomp; define opp/n 'Num_of_optys'; rbreak after/ ol summarize style=[backgroundcolor= grrp color=aliceblue ]; title 'London Olympic Pipeline As of 17th November 2012'; run;  right now i have groups for probability 1, 0.9,0.8,0.7 till 0. But I want groups from 1 till 0.1 , and exclude the group with probability 0 ... View more

I am trying to create a report using proc report where in I have grouped by a variable named probability and inside the groupped variable is another variable Account_name which is a character variable. I want to the frequency of this variable for each group of probability  eg- probability Accounts 1                 3 0.9              4 0.8             6 and so on, but i am not able to do that because it displays all the account_Names inside each probability rather than the freuency/count of the column what i am getting is probability  accounts 1                LG                   max                   LF 0.9            GH                  PL and so on following is the code I used- proc report data= c1.o; columns probability____ Account_Name Total_Media_Value Forecasted_Budget; define probability____ / group order descending 'Probability'; define Account_Name/ n 'Accounts'; define Total_Media_Value /sum 'Total_Budget'; define Forecasted_Budget/ computed 'Forecasted Budget'; compute Forecasted_Budget; Forecasted_Budget= (Total_Media_Value.sum)*(probability____); endcomp; run; in the define Account_Name line i have used display and analysis as well but no use  i get the error ERROR: Account_Name is an ANALYSIS variable but not numeric.   ... View more