topic Re: Output in Data Step in SAS Programming

Output in Data Step

KevinC_ — Thu, 29 Jan 2009 21:00:55 GMT

Hello,

The code below comes from a data step. Can someone tell me what the 'output' does?

IF STAFFID1 ¬= ' ' THEN DO;
CNTL = ENTITYID||STAFFID1;
STAFF = STAFFID1; OUTPUT; END;

Thank you so much!

Re: Output in Data Step

Cynthia_sas — Thu, 29 Jan 2009 23:31:02 GMT

Hi:
I'd suggest you look for this documentation topic:
STATEMENTS: Output Statement which explains (in short) that the OUTPUT statement: "Writes the current observation to a SAS data set." The doc has a lengthy explanation and at least 4 examples of using the OUTPUT statement.

If the OUTPUT statement is placed inside an IF statement, then the OUTPUT statement will be executed conditionally (and, thus, write observations conditionally). Depending on how many OUTPUT statements you have inside IF statements in the whole program, you might see a different number of observations coming OUT of the DATA step program than the number of observations that are being read INTO your program.

cynthia

Re: Output in Data Step

K_rn_tiR_jesh — Fri, 30 Jan 2009 04:38:08 GMT

Hi Kevin,

The If statement take the STAFFID1 variable values is blank values and in the output it will creates the two variables are CNTL and STAFF , and the values of the STAFF is Blank and CNTL variable contains the concate vaules of ENTITY and STAFFID1.Here You will get the ENTITY values only.

bye..

Thanks & Regards
RAJESH.K

Re: Output in Data Step

KevinC_ — Fri, 30 Jan 2009 14:15:12 GMT

Thank you both.

Cynthia,
Are you refering to any particular documentation on this site ?

Thank you!!

Re: Output in Data Step

Cynthia_sas — Fri, 30 Jan 2009 18:34:04 GMT

Hi:
Sorry, I always think that folks know that the doc is organized by topics and that they know the topics can be searched from the search box at the top of the support.sas.com page. I mean this documentation:
http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000194540.htm

cynthia

( you may need a profile in order to navigate the on-line doc)

Product Documentation
--> SAS 9.2 Documentation
--> SAS(R) 9.2 Language Reference: Dictionary
--> Dictionary of Language Elements
--> Statements
--> OUTPUT Statement