Procedure
|
Description
|
---|---|
PROC PRINT
|
|
PROC SQL
|
|
PROC PRINT
|
PROC SQL
|
---|---|
proc print data=company.products; var product_id product_name supplier_name; run; |
proc sql; select product_id product_name supplier_name from company.products; quit; |
PROC PRINT
|
PROC SQL
|
---|---|
proc print data=company.products; var product_id product_name supplier_name; where supplier_country='SE'; run; |
proc sql; select product_id product_name supplier_name from company.products where supplier_country='SE'; quit; |
PROC PRINT
|
PROC SQL
|
---|---|
proc sort data=company.products out=product; by supplier_country; run; proc print data=product; var product_id product_name supplier_name; run; |
proc sql; select product_id product_name supplier_name from company.products order by supplier_country; quit; |
PROC PRINT
|
PROC SQL
|
---|---|
proc sort data=company.products (keep=Product_ID Product_Name Supplier_Name Supplier_Country) out=product; where supplier_country='SE'; by supplier_name; run; proc print data=product; var product_id product_name supplier_name; run; |
proc sql; select product_id product_name supplier_name from company.products where supplier_country='SE' order by supplier_name; quit; |