Scribd Logo
Upload

Welcome to Scribd!

  • 43 views

    Paul D. Mcdonald, Spikeware, Inc., Schaumburg, Il: Paper 222-25

    Uploaded by

    Albin Jose
    This document summarizes how to use the "IF _N_=1 then SET" feature in SAS to merge a one-record dataset onto multiple-record datasets. It provides an example code showing how to attach one record from an AVGSALES dataset to every record in a TOTSALES dataset. It also discusses some variations on how this code would work depending on the value of <value> and the number of observations in each dataset.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Paul D. Mcdonald, Spikeware, Inc., Schaumburg, Il: Paper 222-25

    Uploaded by

    Albin Jose
    43 views1 page
    This document summarizes how to use the "IF _N_=1 then SET" feature in SAS to merge a one-record dataset onto multiple-record datasets. It provides an example code showing how to attach one record from an AVGSALES dataset to every record in a TOTSALES dataset. It also discusses some variations on how this code would work depending on the value of <value> and the number of observations in each dataset.

    Original Description:

    It explains about how we can _n_ in an assignment statement.

    Original Title

    how to use _n_

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes how to use the "IF _N_=1 then SET" feature in SAS to merge a one-record dataset onto multiple-record datasets. It provides an example code showing how to attach one record from an AVGSALES dataset to every record in a TOTSALES dataset. It also discusses some variations on how this code would work depending on the value of <value> and the number of observations in each dataset.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    43 views1 page

    Paul D. Mcdonald, Spikeware, Inc., Schaumburg, Il: Paper 222-25

    Uploaded by

    Albin Jose
    This document summarizes how to use the "IF _N_=1 then SET" feature in SAS to merge a one-record dataset onto multiple-record datasets. It provides an example code showing how to attach one record from an AVGSALES dataset to every record in a TOTSALES dataset. It also discusses some variations on how this code would work depending on the value of <value> and the number of observations in each dataset.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    Posters

    Paper 222-25

    If _n_=1 then SET


    Paul D. McDonald, SPIKEware, Inc., Schaumburg, IL

    Web: http://www.SPIKEware.com/
    ABSTRACT
    This paper and its accompanying poster is prepared for SAS Users Table: Variations on normal application of “If _n_=1 then SET”
    and SAS Programmers of any experience level. They review basic <value> Nobs1 = 1 1 < NOBS1 < NOBS1 >=
    applications of the “IF _N_=1 THEN SET dsname” feature of the NOBS2 NOBS2
    SAS Data Step. It allows merging one record-datasets to multiple- 1 Normal Uses first Use first
    record datasets Operation record of record of
    DATA1 only DATA1 only
    INTRODUCTION Greater than Skips the first Skips the first Initializes all
    1 and less _n_ _n_ variabels in
    Ever have a one-record SAS dataset and you want that one record than nobs2 observations observations DATA1 for
    attached to every record of another dataset? This idea is for you! and uses the final dataset
    first record of and records
    HOW IT WORKS DATA1 only them as
    missing
    THE CODE (EXAMPLE) Greater than Initializes all Initializes all Initializes all
    Simply put, you have two “set” statements. The first one is nobs2 variables in variables in variables in
    encountered only on the first record (if _n_=1) and is for the data set DATA1 for DATA1 for DATA1 for
    of one record—in the example, AVGSALES. The second is the final dataset final dataset final dataset
    main dataset that you want to add the one observation of the first on and records and records and records
    to every observation—in the example, TOTSALES. them as them as them as
    missing missing missing
    data national;
    if _n_=1 then set avgsales;
    set totsales;
    run;

    There is a real good description of this example in the SAS


    Language Guide (Reference) Version 6 First Edition on page 487.
    WHAT IT DOES
    The conditional SET statement creates an implied RETAIN
    statement for every variable in the dataset AVGSALES. The data is
    then “retained” across every observation of TOTSALES. That’s it!
    VARIATIONS--JUST IN CASE SOMEONE ASKS (AND
    SOMEONE PROBABLY WILL…)
    The table shown reflects the expected results from the following
    source code:
    data out ;
    if _n_ = <value> then set data1 ;
    set data2 ;
    run ;

    CONCLUSION
    The conclusion summarizes your paper and ties together any loose
    ends. You can use the conclusion to make any final points such as
    recommendations predictions, or judgments.

    REFERENCES
    SAS Language Guide (Reference) Version 6 First Edition, page 487.

    CONTACT INFORMATION

    Your comments and questions are valued and encouraged. Contact


    the author at:
    Paul D. McDonald
    SPIKEware, Inc.
    1450 East American Lane Suite 1400
    Schaumburg, IL 60173
    Work Phone: (847) 330-4460
    Fax: (847) 798-0732
    Email: PDM@SPIKEware.com

    You might also like