大神们,请问PDV 是只针对data步吗? proc sql 语句有PDV吗?
如果有的话,请问下面两个sql 语句的PDV是怎样的? 谢谢大神们~~
proc sql;
create view sql.view1 as
select *
from oilinfo.reserves as newreserves
using libname oilinfo oracle
user=username
pass=password
path=’dbms-path’;
proc sql outobs=10;
title ’Populations and/or Coordinates ofWorld Cities’;
select coalesce(Capital,City,Name)format=$20. ’City’,
coalesce(Name,Country) format=$20. ’Country’,
Population,Latitude, Longitude
from sql.countries full joinsql.worldcitycoords
on Capital = City and Name = Country;