Hello I have a long table with summary statstics for multiple metrics. I want to create a summary report that put each summary alone and with difference of one row between the reports. Here is how the report should look like- as i said one row gap between reports and column headers in yellow   proc sql; create table t1 as select 'region' as VAR, region as category, 'sales' as metric, count(sales) as nr_obs, sum(sales) as amnt format=best. from sashelp.shoes group by region; quit; proc sql; create table t2 as select 'region' as VAR, region as category, 'net_sales' as metric, count(sales) as nr_obs, sum(sales-returns) as amnt label='Net Sales Ratio' from sashelp.shoes group by region; quit; proc sql; create table t3 as select 'region' as VAR, region as category, 'net_sales_Ratio' as metric, count(sales) as nr_obs, sum(sales-returns)/sum(sales) as amnt format=8.2 label='Net Sales Ratio' from sashelp.shoes group by region; quit; Data all; length metric $100.; set t1 t2 t3; Run; ... View more

Hello Let's say someone sent me the regression formula to calculate PD . I want to check which combination can create  PD   0.104 So I need to run the all possible combinations and then check which of them get OD 0.104 ( can be 0.01 higher or lower than it ) Please note: PD is calculated by : a=sum of coefficents PD=Exp(a) / 1+Exp(a)   The answer to my question is that the following combination provide PD 0.104. My question- How to provide the answer via sas code ?     Data have; input var $ value coefficient; cards; X1 1 -0.1 X1 2 0.25 X1 3 0 X2 1 0.35 X2 2 0 X3 1 0.75 X3 2 0 X4 1 0.95 X4 2 1.45 X4 3 0 X5 1 -1.2 X5 2 0 X6 1 -1.1 X6 2 2.2 X6 3 0 X7 1 -0.7 X7 2 0.8 X7 3 1.6 X7 4 0 X8 1 -1.1 X8 2 0 X9 1 0.6 X9 2 0.9 X9 3 0 INTER 1 -2.5 ; Run;             ... View more

Hello I want to write macro abbreviation(It is a code that I write and then by type the code name I can get it) In tools tab I cant see it ( macro abbreviation)   ... View more

Lets sat that I have 2 programs open. Lets say that in program 1 I created data set called XXX Lets sat that now in program 2 I try to create also data set called XXX Then I get error---ERROR: You cannot open WORK.XXX.DATA for output access with member-level control because WORK.XXX.DATA is in use by you in resource environment IOM ROOT COMP ENV.     In my older sas version this error never occur.   What is the way to prevent this error???   ... View more

Hello I created a small data set How can I send it to excel? In the older version of SAS there was send----send to Excel.... How can I sent it to excel here too? (not via proc export but by click bottom)   ... View more

Hello I am new into sas Enterprise guide 8.3 Here is the interface I see . Some questions- I cant see STOP tab if I want to stop run  I cant see the libraries list where I can see WORK library with all data sets that were created there I want  also to have bigger fonts in program code. IS there also other recommended setting?     ... View more

Hello. I am new in sas enterprise 8.3. I can't see server bottom where I can see the libraries ... View more

Hello I am new with ses enterprise 8.3. I opened a sas program and run it. I see a message- sas enterprise guide detected a sas studio enterprise edition 3.6 but requires 3.7 or greater to display sas studio tasks. What does it mean? Is there any bad results for this problem? What action should I do? ... View more

Hello I am new with sas enterprise 8.3 . I can't see tools tab . Please see photo of my layout. I also want to do view and reset to default but can't see it ... View more