Good morning everyone. I'm trying to use sas Viya with the sas demo. In the documentation I haven't found many examples or explanations for some key topics, such as the conversion of many proc sql codes into proc fedsql. For example, I haven't been able to convert the CALCULATED clause in any way. I'm reporting the example of proc sql and the related conversion attempt with proc fedql cas mysess;
caslib mycas path="/shared/viya/homes/sasdemo/c_cas";
libname mycas cas;
caslib _all_ assign;
data mycas.class;
set sashelp.class;
run;
/*PROC SQL*/
proc sql;
create table test_sql as
select name,
weight,
height,
sum(height) as sum_height
from sashelp.class
group by name
having calculated sum_height > 50;
quit;
/*FEDSQL VIYA*/
proc fedsql sessref=mysess;
create table mycas.test_fed as
select name,
weight,
height,
sum(height) as sum_height
from mycas.class
group by name
having sum(height) > 50;
quit;
... View more
