I have a table with two columns and I wish to find the weighted mean. So for example, in the following table, I would like my code to generate the following results:  2.4 I got the above value of 2.4 through this:([(3*2) + (3*5) + (4*1) + (1*3) + (2*4)]/15 My actual table has thousands of rows and so I'm wondering what code could deal with this. Help would be appreciated.  I tried the following code but it doesn't work: proc sql; select sum(Rating_a*Weights) / sum(Weights) from have; quit; Weights Rating_a 2 3 5 3 1 4 3 1 4 2 ... View more

I have two columns in a table.  I need to find the number of rows in which the number in Rating_a is bigger than the number in Rating_b and then divide that number by the total number of rows in the table in which the value changes. So when dividing, I won't be taking into account those rows in which the values in Rating_a and Rating_b are the same. For instance, in the following table, the result I'd be looking for is 2/4 = 50%. I divide by 4 instead of 6 because 2 rows have the same values. And in the numerator I wrote 2 because only in 2 rows, rating_a is bigger than rating_b. Help would be appreciated in coming up with a code that deals with this since I'm dealing with 1000s of rows in my table. Thank you. Here's a sample (actual table has 1000s of rows) of how it looks like: Rating_a Rating_b 1 3 2 2 4 2 4 4 2 1 3 4   ... View more

I have two columns in a table.  I need to find the number of rows in which Rating_a is not equal to Rating_b and then divide that number by the total number of rows in the table. Basically, I need to find the percentage of where the values differ. Could someone please help me with this? I think using the COUNT function could work. Help would be appreciated. Thank you. Here's a sample (actual table has 1000s of rows) of how it looks like: Rating_a   Rating_b 1 1 2 3 4 4 4 1 3 3 ... View more

  I have the following code with me. It outputs 3 tables in the "results" section for each data set. Third table in the "results" section has the names of the variables along with other details such as type, length, etc. I need to combine this third table for each of these data sets so that finally, I just have one table which has the names (and type, length, etc.) of all the variables that are there in all of these tables. Basically, my goal is to merge all the third tables in the "Results" section so as to get all this information in just one table. Help would be appreciated. Thank you. libname a meta library="abc" metaout=data; data list; infile datalines4 dlm='|'; format table $32.; input table; datalines4; table_a table_b table_c table_d table_e table_f table_g table_h ;;;; run; data _null_; set list; call execute(' proc contents data=a.'||strip(table)||'; run; '); run; ... View more

The objective of my code is to display the type, number of distinct values, and the number of missing values. And at this point, I'm very close to getting it. In my _smmry_ table, you can see the number of missing values for all the variables. However, by the time I'm done with my left join, the table final_Alpha_ doesn't display the number of missing values for two of the variables and instead just shows ".". What went wrong in the left join? Help would be appreciated. Thank you.     %let set=sashelp.cars; proc transpose data=&set(obs=0) out=names; var _all_; run; proc sql; select cats('_',_name_,'=missing(',_name_,');') into: stmts separated by ' ' from names; run; data missing; set &set; &stmts; keep _:; run; proc summary data=missing; var _numeric_; output out=smry sum=; run; proc transpose data=smry(drop=_type_ _freq_) out=smry_; run; data _smry_(drop = _name_); set smry_; name=compress(_name_, , 'kas'); run; proc sort data=_smry_; by name; run; proc contents data=&set out=con_(rename=(name=TableVar)); run; proc freq nlevels data = &set; ods output nlevels=distinct; run; proc sort data=distinct; by TableVar; run; data _smmry_(rename=(name= TableVar col1 = miss)); retain name col1;set _smry_;run; data final_Alpha (keep=TableVar distinct_ TYPE ); merge distinct(rename=(Nlevels=distinct_)) con_(keep=TableVar type) ; by TableVar; run; proc sql; create table final_Alpha_ as select * from final_Alpha as x left join _smmry_ as y ON x.TableVar=y.TableVar;quit; proc sort data=final_Alpha_ out=_final_Alpha; by descending miss; run; proc freq nlevels data=&set; tables _all_; run;   ... View more

This is the code that I have with me: %let data=sashelp.cars; proc transpose data=&data(obs=0) out=names; var _all_; run; proc sql; select cats('_',_name_,'=missing(',_name_,');') into: stmts separated by ' ' from names; run; data missing; set &data; _BIGN = 1; /*%m_expand_varlist(data=&data,expr=cats('_',_name_,'=missing(',_name_,');'));*/ &stmts; keep _:; run; proc summary data=missing; var _numeric_; output out=smry sum=; run; proc transpose data=smry(drop=_type_ _freq_) out=smry_; run; The goal of this code is to output the number of missing values for both character and numeric variables in the data set. The code accomplishes that objective but I have difficulty in understanding the purpose of certain lines in the code. May I know what the following part of the code does? select cats('_',_name_,'=missing(',_name_,');') into: stmts separated by ' ' from names; I understand that the into part just stores the value into the macro variable stmts but what does "separated by ' ' from names" in the above line mean? data missing; set &data; _BIGN = 1; &stmts; keep _:; run; And in the above portion of the code, what is the purpose of "keep :"? What does the ":" do in that? And is the "_BIGN = 1" necessary? And also in the final output table called smry_, I get underscores before the names of the variables. But I don't need these underscores. What can I do to remove them? When I removed the underscore after the "keep :", the underscores in the smry table went away but I was left with only 10 rows instead of 15. Help would be appreciated. Thank you. ... View more