What do you expect to see if the results cross For example; X Y 0 4 12 4 16 4 is this combination possible ? ... View more

I think your authorization level are different. Are these computers connected to network or private. If not private then ask to system security department. ... View more

You can also use "inner join" or "left join" clauses with proc sql ... View more

you can join these two tables: create first table; proc sql; create table tablo as count(ID) as total, avg(q3) as aver from tablo t1 group by total, aver; ********* then inner join between fist table and given above. (proc summarize also do this but i didnt remember) ... View more

proc sql; select catx(" | ",a.product,b.Med_product) as variab from master a left join child b on strip(upcase(med_product)) contains strip(upcase(product)); quit; ... View more

You can use _n_ and concatanate it with variabli. Data new; Set old; X=_n_; Y="var"||X||"_"||my_variable; Run; You can also use catx, ... View more

Is there a "period" column in your each dataset ? If there is no, then you must create one from the dataset name, before joining all datasets. If you dont do this you cannot compare data each other. Because all of them mixes. If you dont want to understand complex issues or if you do this work for one time, you can create libname statements in excel and then paste it to sas. Then join all and use proc sql drop table statement... Or if there is awant batch work or automatically process i used to write a macro which contains do-loop.and compare and export result. ... View more

Data data2; Set data1; If (month>t) then output data2; Run; ... View more

as i understand "odds ratios" sheet has been already created in excel. firstly change your code and Replace sheet name as "my_data". Then get figures from "my_data" sheet to "odds ratios" sheet in excel by creating cell link. ... View more