Hello, I am using the flowing script to plot var1 vs var2:   proc sgscatter data=mydata; plot  var1*var2 / datalabel=name reg=(degree=1 clm) ; run;   My question is that how I can set the range of the values of x- and y-axis equal, so that the line var1=var2 is a 45-degree line.   Thanks,   ... View more

Hi everyone, I have a wide dataset similar to following table and want to reshape it to long. Variables' formats: name (character), date(date), new_id and original_id(numeric) name Date1 New_id1 Cert_id1 Date2 New_id2 Cert_id2 The columns continue to 5.   I used the following code, however it doesn't work and I think the reason is the different formats I have.    DATA long; SET wide; ARRAY adate(1:5) date1 - date5 ; ARRAY anew_id(1:5) new_id1 - new_id5; ARRAY aoriginal_id(1:5) original_id1 - original_id5; DO change = 1 to 5 ; date = adate(change); new_id =anew_id(change); original_id =aoriginal_id(change); OUTPUT; END; DROP date1 - date5 new_id1 - new_id5 original_id1 - original_id5; RUN;   I appreciate any and all suggestions.   ... View more

Hello everyone, I tried to merge two datasets:       have1 with two common variables: var11 and var12      have2 with two common variables: var21 and var22 So I used the following code: proc sql; create table want  as select L.*, R.*  from have1 as L full outer join have2 as R on L.var11=R.var21 and L.var12=R.var22; quit;   Then I tried to do the same thing in Stata. I change the common variables in both dataset to var1 and var2, and ran the following code: use file1 merge m:m var1 var2 using file2   There is a conflict in the result of these two approaches. The first code gives me a result with 10M observation, but the output of the second code has only 300K observations.  I read the manuals but I couldn't figure out what is the reason that I get two different results by using these methods.  I appreciate if you could help.   ... View more

Hello everyone, In the following table I want to fill the missing value of MSA with non-missing values of those observations whose CBSA values are equal, so that the column MSA_filled be created. I tried retain but it didn't work. Do I need to use coalesce? I appreciate your suggestions. CBSA MSA MSA_filled 111 . 45 111 45 45 111 . 45 111 . 45 222 67 67 222 . 67 333 89 89 333 . 89 333 89 89 555 88 88 555 88 88 555 . 88 555 . 88 ... View more

Hello everyone, I submitted a statement, but then I tried to stop it. So I used the break icon at the top. After that the Log window has not been updated. I have many files in the work library, so I prefer not to close my SAS. I appreciate if you could give me any suggestion. ... View more

Hi everyone, Below is small part of the dataset that I'm working with. The only difference is that my dataset contains many more company_Nm, branch_id, product_id and date. Company_Nm Branch_ID City Product_ID Date Sale Competitors_sale AAA AAA1 Gainesville XX Jan-11 10000 AAA AAA2 Yreka XX Jan-11 8000 AAA AAA3 Yreka XX Jan-11 5000 AAA AAA4 San Francisco XX Jan-11 4000 AAA AAA5 Los Angeles XX Jan-11 7000 AAA AAA6 Donalsonville XX Jan-11 12000 AAA AAA7 Savannah XX Jan-11 80000 BBB BBB1 Yreka XX Jan-11 1000 BBB BBB2 San Francisco XX Jan-11 1000 BBB BBB3 Los Angeles XX Jan-11 1000 BBB BBB4 Donalsonville XX Jan-11 1000 BBB BBB5 Savannah XX Jan-11 1000 For each specific Company_nm and branch_id,each row, I want to find other branches located in the same city, let's say competitors. Then I need to take the average of sales among the competitors for the same product_id and date in that row, and put the value in the competitor_sale column. Previously, I picked only one branch_id as a pilot and did the same procedure for that. I may be able to extend my code to all rows by do loop, but I'm not sure what's the most efficient way. Below is my code, even though I'm think it's so ugly and inefficient.      data AAA1; set have; if branch_id='AAA1'; run;      proc sql; create table comp1 as select * from  have where city in (Select city from AAA1); quit;       proc sql; create comp2 as select * from  comp1 where company_nm not in (Select company_nm from AAA1); quit;      proc sql ; create table comp_rate as select product_id, date,  mean(rate) as Ave_comp format = 5.3 from comp2 group by  product_id, date; quit;      data want; merge AAA1 comp_rate; by product_id date; run; I really appreciate any and all suggestions. ... View more