proc options option=rsasuser; run;
libname sasuser "/folders/myfolders/certprep";
certprep
.
If you use another filename, substitute the name that you created
for certprep
.
From SAS Software
|
|
---|---|
Help
|
For SAS®9,
select Help>SAS Help
and Documentation
SAS Enterprise Guide,
select Help>SAS Enterprise
Guide Help
|
Documentation
|
For SAS®9,
select Help>SAS Help
and Documentation
SAS Studio, select
|
On the Web
|
|
---|---|
Bookstore
|
|
Training
|
|
Documentation (including
SAS Enterprise Guide)
|
|
Certification
|
|
SAS Global Academic
Program
|
|
SAS OnDemand
|
PROC SQL;
SELECT column-1<,...column-n>
FROM table-1|view-1<,...table-n|view-n>
<WHERE expression>
<GROUP
BY column-1<,
... column-n>>
<ORDER
BY column-1<,...
column-n>>;
PROC SQL
invokes the SQL procedure.
SELECT
specifies the column(s)
to be selected.
FROM
specifies the table(s)
to be queried.
WHERE
subsets the data
based on a condition.
GROUP BY
classifies the data
into groups based on the specified column(s).
ORDER BY
sorts the rows that
the query returns by the value(s) of the specified column(s).
|