Curriculum Vitae In Tabular Form Curriculum Vitae In Tabular Form Will Be A Thing Of The Past And Here’s Why
This area contains accomplishments advice on concepts and accoutrement that are accepted to abounding abject SAS procedures.
Many abject procedures crave an ascribe SAS abstracts set. You specify the ascribe SAS abstracts set application the DATA= advantage in the action statement, for example,
If you omit the DATA= option, the action uses the bulk of the SAS arrangement advantage _LAST_=. The absence of _LAST_= is the best afresh created SAS abstracts set in the accepted SAS job or session. _LAST_= is declared in detail in SAS Accent Reference: Dictionary.
Prior to Version 7, SAS procedures that produced printed achievement (that is, achievement that was destined for the action achievement file) generated achievement that was advised for a acceptable line-printer. This blazon of achievement has limitations that anticipate users from accepting the best bulk from their results:
Beginning with Version 7, action achievement became abundant added flexible. The Achievement Delivery Arrangement (ODS) has been advised to affected the limitations of acceptable SAS achievement and to accomplish it accessible to accomplish new formatting options accessible to users. ODS is a adjustment of carrying achievement in a array of formats and of authoritative the formatted achievement accessible to access. Important appearance of ODS accommodate the following:
In addition, ODS removes albatross for formatting achievement from alone procedures and from the DATA step. The action or DATA footfall food raw abstracts and the name of the table analogue that contains the formatting instructions, and ODS formats the output. Because formatting is now centralized in ODS, the accession of a new ODS destination does not affect any procedures or the DATA step. As approaching destinations are added to ODS, they will automatically become accessible to all procedures that abutment ODS and to the DATA step.
This area briefly illustrates these features. For added advice about the Achievement Delivery System, see The Complete Guide to the SAS Achievement Delivery System.
Note: The examples in this area use filenames that may not be accurate in all operating environments. To auspiciously run the archetype in your operating environment, you may charge to change the book specifications. See Appendix 1, “Alternate ODS HTML Statements for Active Examples in Altered Operating Environments,” in The Complete Guide to the SAS Achievement Delivery System.
You do not charge to change your SAS programs to actualize Advertisement output. By default, the Advertisement destination is open. Unless you accurately abutting the Advertisement destination with the ODS LISTING CLOSE statement, you will abide to actualize Advertisement output.
If you accessible the Printer destination, you can actualize achievement that is formatted for a high-resolution printer. The aboriginal ODS PRINTER account in the afterward SAS affairs opens the Printer destination and directs the formatted achievement to the book odsprinter.ps. The added ODS PRINTER account closes the Printer destination. You charge abutting the Printer destination afore you can book the file.
The abstracts set STATEPOP is created in a DATA footfall . The REGFMT. architecture is created in a PROC FORMAT footfall . The printer achievement appears in Achievement Created by the Printer Destination .
Output Created by the Printer Destination
If you accessible the HTML destination, you can actualize achievement that is formatted in HyperText Markup Accent (HTML). You can browse these files with Internet Explorer, Netscape, or any added browser that absolutely supports the HTML 3.2 tag set.
The ODS HTML statement, which generates the HTML files, can create
For example, the aboriginal ODS HTML account in the afterward SAS affairs generates four HTML files. ODS routes the after-effects of the PROC UNIVARIATE footfall to the anatomy book as able-bodied as to the Advertisement destination. ODS additionally creates the associated contents, page, and anatomy files. The added ODS HTML account closes the HTML destination. You charge abutting the HTML destination afore you can browse the HTML files.
Frame Book Created by the ODS HTML Statement.
For added advice about creating HTML output, see the altercation of the ODS HTML Account in Chapter 3, “The ODS Statements” in The Complete Guide to the SAS Achievement Delivery System. You can see abounding examples of HTML achievement in SAS Procedures Guide online documentation.
Note: Procedure options that affect presentation may not affect HTML output. For instance, the DOUBLE advantage in PROC PRINT, which inserts a bare band amid observations, has no aftereffect on HTML output.
Several of the appearance of the Achievement Delivery Arrangement (such as selecting and excluding achievement altar to accelerate to ODS destinations or creating a abstracts set from an achievement object) crave that you specify one or added accurate achievement altar for the arrangement to process. You analyze an achievement article by its name, its label, or its path. To apprentice what these are, run your SAS affairs preceded by this statement:
As continued as the archetype affection is on, advice about anniversary achievement article that is created appears in the SAS log.
Use this account to stop sending the advice to the log:
For example, the afterward SAS affairs produces the SAS log that is apparent in SAS Log Produced by the ODS TRACE Account :
SAS Log Produced by the ODS TRACE Statement
If you analyze this SAS log to the After-effects Binder that appears in Appearance of the After-effects Binder , you can see that the cord that identifies the achievement in the After-effects binder is its label.
For added advice about the trace record, see the altercation of the capacity of the trace almanac in the affidavit for the ODS TRACE account in “The ODS Statements” in The Complete Guide to the SAS Achievement Delivery System.
Some procedures, such as PROC UNIVARIATE, aftermath assorted achievement objects. Any action that uses ODS produces assorted achievement altar back you use BY-group processing. ODS enables you to baddest which of these achievement altar go to the accessible ODS destinations. ODS destinations accommodate the Advertisement destination, the HTML destination, the Printer destination, and the Achievement destination. For added advice about ODS destinations, see “Basic Concepts about the Achievement Delivery System” in The Complete Guide to the SAS Achievement Delivery System.
You accept the altar to accelerate to destinations with the ODS SELECT or the ODS EXCLUDE statement. To baddest alone achievement objects, use this anatomy of the ODS SELECT statement:
where anniversary bulk of accession can be a abounding path, a name, or a characterization (see the trace almanac in
). You can additionally use a fractional path. A fractional aisle consists of any allotment of the abounding aisle that begins anon afterwards a aeon (.) and continues to the end of the abounding path. For capacity about referencing achievement objects, see the altercation of allegorical an achievement article in the affidavit of the ODS SELECT account in “The ODS Statements” in The Complete Guide to the SAS Achievement Delivery System.
For example, to baddest aloof the achievement altar that accommodate the basal measures and the quantiles from the PROC UNIVARIATE output, use the afterward program.
The anatomy book appears in
. The affairs additionally creates Advertisement output, which is not shown. The Advertisement achievement contains the aforementioned advice as the HTML anatomy file, but it is formatted with the acceptable SAS monospace font.
Frame Book for Alleged Achievement Objects
For added advice about selecting achievement objects, see the affidavit for the ODS SELECT account in “The ODS Statements” in The Complete Guide to the SAS Achievement Delivery System.
The Achievement Delivery Arrangement enables you to actualize a abstracts set from an achievement object.
To actualize a abstracts set, use the ODS OUTPUT statement. In this statement, you identify
To actualize a distinct achievement abstracts set, use this simplified anatomy of the ODS OUTPUT statement:
Specify the achievement article as you do in the ODS SELECT statement: with a path, a name, a label, or a fractional path. For example, to accomplish and book an achievement abstracts set from anniversary achievement article that contains the basal measures that PROC UNIVARIATE produces, use the afterward SAS program.
You can use the consistent abstracts set as ascribe to accession SAS program. This affairs artlessly prints the abstracts set to allegorize its structure. The HTML achievement from PROC PRINT appears in PROC PRINT Address of the Abstracts Set Created by PROC UNIVARIATE and ODS .
PROC PRINT Address of the Abstracts Set Created by PROC UNIVARIATE and ODS
For added advice about creating achievement abstracts sets, see the altercation of the ODS OUTPUT account in “The ODS Statements,” in The Complete Guide to the SAS Achievement Delivery System.
When you run a action that supports ODS, SAS automatically food a articulation to the ODS achievement in the After-effects binder in the After-effects window. It marks the articulation with an figure that identifies the achievement destination that created the output.
Consider the afterward SAS program, which generates Listing, HTML, and Printer achievement as able-bodied as an achievement abstracts set (Output output). The abstracts set STATEPOP contains advice about the administration of the United States’ citizenry in city and nonmetropolitan areas for 1980 and 1990. A DATA footfall creates this abstracts set.
The After-effects binder (see
) shows the folders and achievement altar that the action produces.
View of the After-effects Folder
Many procedures that absolutely abutment ODS accommodate table definitions that accredit you to adapt anniversary achievement article that the action produces. You do so by creating an alternating table analogue for the action to use. This area illustrates how to accomplish an accession table definition. The account actuality focuses on the anatomy of the table. For abundant explanations of all the statements and attributes that the affairs uses, see the area on the TEMPLATE action in The Complete Guide to the SAS Achievement Delivery System.
For example, the afterward SAS affairs creates a customized table analogue for the BasicMeasures achievement article from PROC UNIVARIATE. (The trace almanac provides the name of the table analogue that anniversary article uses. See SAS Log Produced by the ODS TRACE Account .) In the customized version
The customized output, from both the HTML and the Advertisement destinations, appears in
. The customized Printer achievement appears in
Customized Advertisement Achievement from PROC UNIVARIATE
Customized Printer Achievement from PROC UNIVARIATE (page 1)
Customized Printer Achievement from PROC UNIVARIATE (page 2)
This area illustrates the HTML and Printer achievement that you can get from acquisition alleged examples from the affidavit on alone procedures through the HTML and Printer destinations. Anniversary allotment of HTML achievement was created by active the authentic archetype with this ODS HTML account above-mentioned it:
If Printer achievement is shown, the authentic archetype was run with this ODS PRINTER account above-mentioned it:
You charge assassinate the afterward account afore you can appearance the consistent HTML files in a browser:
You charge assassinate the afterward account afore you can book Printer output:
The SAS affairs that produces this achievement is in
HTML Achievement from PROC TABULATE
Printer Achievement from PROC TABULATE
The SAS affairs that produces this achievement is in
HTML Achievement from PROC FREQ
Printer Achievement from PROC FREQ (page 1)
Printer Achievement from PROC FREQ (page 2)
The SAS affairs that produces this achievement is in
HTML Achievement from PROC PRINT
The SAS affairs that produces this achievement is in
HTML Achievement from PROC REPORT
A appearance analogue determines the all-embracing attending of the certificate that uses it. Anniversary appearance analogue is a accumulating of appearance elements, anniversary of which affects a accurate allotment of the document. Procedures may use altered appearance elements in altered genitalia of their output. For example, a action can use one appearance aspect for cavalcade headers and accession for data. Anniversary appearance aspect is, in turn, a accumulating of attributes and values. The attributes actuate the size, face, and weight of the blazon that is used, the blush of the alpha and background, and added such features.
For a account of the attributes, see What Appearance Attributes Can Abject Procedures Specify? .
SAS Institute ships a cardinal of appearance definitions with the SAS System. To see a account of these styles,
Operating Ambiance Information: For advice on abyssal in the Explorer window afterwards a mouse, see the area on “Window Controls and Accepted Navigation” in the SAS affidavit for your operating environment.
You can also, abide this PROC TEMPLATE footfall to see the SAS cipher for a appearance definition:
where style-name is the aisle to the appearance from the arrangement abundance (for archetype styles.default or styles.beige).
The HTML destination uses the appearance that is alleged Absence unless you specify an accession appearance with the STYLE= advantage in the ODS HTML account (see the affidavit for the ODS HTML account in The Complete Guide to the SAS Achievement Delivery System). The Printer destination uses the appearance that is alleged Printer unless you specify an accession appearance with the STYLE= advantage in the ODS PRINTER account (see the affidavit for the ODS PRINTER account in The Complete Guide to the SAS Achievement Delivery System).
In best cases, if you appetite to adapt the appearance of a book that ODS produces, you charge accomplish a archetype of the appearance that is used, adapt that copy, and abundance it so that ODS will acquisition it and use it afore it finds the appearance that SAS Institute provides. (For advice on this process, see The Complete Guide to the SAS Achievement Delivery System.)
A action uses one or added table definitions to aftermath achievement objects. These table definitions accommodate definitions for table elements: columns, headers, and footers. Anniversary table aspect can specify the use of one or added appearance elements for assorted genitalia of the output.
However, procedures that body letters that are based on advice that the user provides do not use the aforementioned templates. Two of these procedures, PROC REPORT and PROC TABULATE, accommodate a way for you to adapt the HTML and Printer achievement anon from the PROC footfall that creates the report. Advice on how to do this is provided with the syntax for these procedures.
The afterward account describes the appearance attributes that you can specify from the TABULATE and REPORT procedures. Procedures that abutment the Achievement Delivery Arrangement can architecture their achievement for HTML or for a high-resolution printer. Their achievement is in collapsed form. Some of the appearance attributes administer to the table as a whole; others administer to alone beef in the table. The action affidavit tells you which appearance attributes you can set from which statements in the procedure.
Note: The absence bulk that is acclimated for an aspect depends on the appearance analogue that is in use. For advice on examination the attributes in a style, see What Appearance Definitions Are Shipped with the Software? . The accomplishing of an aspect depends on the ODS destination that formats the output. In addition, if you are creating HTML output, the accomplishing of an aspect depends on the browser that you use. Many ethics for appearance attributes are one of the following:
Note: In Version 8 of the SAS System, alone the Printer destination supports units of admeasurement on dimensions. However, if you specify CSS in the ODS HTML statement, the HTML destination supports units of measure. The CSS advantage is alpha in Version 8.
Note: The Achievement Delivery arrangement aboriginal tries to bout a blush with a SAS/GRAPH color. Thus, although amber and orange are changeable in the table, if you use them as blunt hues, they are different. The acumen for this is that ODS treats them like SAS colors, which are mapped to altered colors.
You can additionally specify hues that are average amid two adjoining colors. To do so, amalgamate one of the afterward adjectives with one of its adjoining colors:
Later, you can ensure that accession appearance element, NEWCELL, uses the aforementioned accomplishments blush by defining it this way:
Similarly, accept that you actualize a appearance aspect alleged HIGHLIGHTING that defines three attributes this way:
Note: In the aboriginal example, the appearance aspect BACKGROUND= is a predefined appearance attribute. Therefore, back you advertence it, you do not put it in citation marks. However, in the added example, “go” is a user-defined attribute. You ascertain it with citation marks, and back you advertence it, you charge use citation marks. (This area describes all the predefined appearance attributes that are available.)
You can use a adapted anatomy of advertence to get a bulk for a appearance aspect from the macro table at the time that the appearance aspect is used. For instance, the afterward STYLE account uses the accepted bulk of the macro capricious bkgr for the accomplishments blush of the appearance aspect cell:
font-size specifies the admeasurement of the font. font-size can be a ambit or a cardinal afterwards units of measure. If you specify a dimension, you charge specify a assemblage of measure. Afterwards a assemblage of measure, the cardinal becomes a admeasurement that is about to all added chantry sizes in the document.
keyword-list specifies the weight, chantry style, and chantry width. You can accommodate one bulk for each, in any order. The afterward table shows the keywords that you can use:
TABLE NOTE 1: *Most fonts do not account these values.
Note: You can use the bulk _UNDEF_ for any appearance attribute. ODS treats an aspect that is set to _UNDEF_ as if its bulk had never been set, alike in the ancestor or beyond.
In the account of appearance attributes that follows, any aspect that is not accurate as applying to a accurate destination applies to all destinations that abutment the STYLE= advantage in the ODS account that opens the destination. In Version 8 of the SAS System, the two destinations that abutment STYLE= are the HTML destination and the Printer destination.
You cannot be abiding what fonts are accessible to addition who is examination your achievement in a browser or press it on a high-resolution printer. Best accessories support
RUN-group processing enables you to abide a PROC footfall with a RUN account afterwards catastrophe the procedure. You can abide to use the action afterwards arising accession PROC statement. To end the procedure, use a RUN CANCEL or a QUIT statement. Several abject SAS procedures abutment RUN-group processing:
See the area on the alone action for added information.
Note: PROC SQL executes anniversary concern automatically. Neither the RUN nor RUN CANCEL account has any effect.
BY-group processing uses a BY account to action observations that are ordered, grouped, or indexed according to the ethics of one or added variables. By default, back you use BY-group processing in a action step, a BY band identifies anniversary group. This area explains how to actualize titles that serve as customized BY lines.
When you admit BY-group processing advice into a title, you usually appetite to annihilate the absence BY line. To abolish it, use the SAS arrangement advantage NOBYLINE.
Note: You charge use the NOBYLINE advantage if you admit BY-group advice into titles for the afterward abject SAS procedures:
If you use the BY account with the NOBYLINE option, these procedures consistently alpha a new folio for anniversary BY group. This behavior prevents assorted BY groups from actualization on a distinct folio and ensures that the advice in the titles matches the address on the pages.
The accepted anatomy for inserting BY-group advice into a appellation is
This fractional achievement shows two BY groups with customized BY lines:
This archetype inserts the name of a BY capricious and the bulk of a BY capricious into the title. The program
This fractional achievement shows one BY accumulation with a customized BY line:
This archetype inserts the complete BY band into the title. The program
This fractional achievement shows two BY groups with customized BY lines:
The SAS Arrangement does not affair absurdity or admonishing letters for incorrect #BYVAL, #BYVAR, or #BYLINE specifications. Instead, the argument of the account artlessly becomes allotment of the title.
Several statements in procedures acquiesce assorted capricious names. You can use these adjustment notations instead of allegorical anniversary capricious name:
Note: You cannot use shortcuts to account capricious names in the INDEX CREATE account in PROC DATASETS.
See SAS Accent Reference: Concepts for complete documentation.
Typically, back you book or accumulation capricious values, abject SAS procedures use the formatted values. This area contains examples of how abject procedures use formatted values.
The afterward archetype prints the formatted ethics of the abstracts set PROCLIB.PAYROLL. (A
creates this abstracts set.) In PROCLIB.PAYROLL, the capricious Jobcode indicates the job and akin of the employee. For example, TA1 indicates that the abettor is at the alpha akin for a admission agent.
This is a fractional press of PROCLIB.PAYROLL:
The afterward PROC FORMAT footfall creates the architecture $JOBFMT., which assigns anecdotic names for anniversary job:
The FORMAT account in this PROC MEANS footfall briefly assembly the $JOBFMT. architecture with the capricious Jobcode:
PROC MEANS produces this output, which uses the $JOBFMT. format:
Note: Because formats are appearance strings, formats for numeric variables are abandoned back the ethics of the numeric variables are bare for algebraic calculations.
PROC MEANS produces this output:
If you appetite to accessory a architecture with a capricious temporarily, you can use the FORMAT statement. For example, the afterward PROC PRINT footfall assembly the DOLLAR8. architecture with the capricious Bacon for the continuance of this PROC PRINT footfall only:
PROC PRINT produces this output:
If a capricious has a abiding architecture that you do not appetite a action to use, briefly abstract the architecture from the capricious application a FORMAT statement.
In this example, the FORMAT account in the DATA footfall assuredly assembly the $YRFMT. capricious with the capricious Year. Thus, back you use the capricious in a PROC step, the action uses the formatted values. The PROC MEANS step, however, contains a FORMAT account that dissociates the $YRFMT. architecture from Year for this PROC MEANS footfall only. PROC MEANS uses the stored bulk for Year in the output.
PROC MEANS produces this output, which does not use the YRFMT. format:
When a action processes a abstracts set, it checks to see if a architecture is assigned to the BY variable. If so, the action adds observations to the accepted BY groups until the formatted bulk changes. If nonconsecutive centralized ethics of the BY variable(s) accept the aforementioned formatted value, the ethics are aggregate into altered BY groups. This after-effects in two BY groups with the aforementioned formatted value. Further, if altered and after centralized ethics of the BY variable(s) accept the aforementioned formatted value, they are included in the aforementioned BY group.
If SAS cannot acquisition a format, it stops processing and prints an absurdity bulletin in the SAS log. You can abolish this behavior with the SAS arrangement advantage NOFMTERR. Back you use NOFMTERR, and SAS cannot acquisition the format, SAS uses a absence architecture and continues to process. Typically, for the default, SAS uses the BESTw. architecture for numeric variables and the $w. architecture for appearance variables.
Note: To ensure that SAS can acquisition user-written formats, use the SAS arrangement advantage FMTSEARCH=. How to abundance formats is declared in Storing Informats and Formats .
You can use the SAS Macro Ability to run the aforementioned action on every abstracts set in a library. The macro ability is allotment of abject SAS software.
Printing All the Abstracts Sets in a SAS Library shows how to book all the abstracts sets in a library. You can use the aforementioned macro analogue to accomplish any action on all the abstracts sets in a library. Artlessly alter the PROC PRINT allotment of the affairs with the adapted action code.
Several abject SAS procedures are specific to one operating ambiance or one release.
contains a table with added information. These procedures are declared in added detail in the SAS affidavit for operating environments.
identifies accepted anecdotic statistics that are accessible in several abject procedures. See
for added abundant advice about accessible statistics and abstract information.
The afterward requirements are computational requirements for the statistics that are listed in
. They do not call recommended sample sizes.
Statistics are appear as missing if they cannot be computed.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
Curriculum Vitae In Tabular Form Curriculum Vitae In Tabular Form Will Be A Thing Of The Past And Here’s Why – curriculum vitae in tabular form
| Delightful to be able to my own blog, in this particular period I’ll teach you regarding keyword. And after this, this is the very first picture: