topic Re: interpreting the SAS code in SAS Procedures

interpreting the SAS code

deleted_user — Thu, 18 Feb 2010 12:51:34 GMT

Hello ,

could you please guide as to what does the following code mean :

data q2vienna;
set sc.aprtarget (rename=(Flight=FlightID
FClassTar=FTarget
EClassTar=ETarget))
sc.maytarget sc.juntarget;
TotTar = sum(FTarget,ETarget);
TotRev = sum(FRev,ERev);
keep FlightID Destination Date TotTar TotRev;
run;

proc print data=q2vienna;
run;

Re: interpreting the SAS code

sbb — Thu, 18 Feb 2010 13:44:46 GMT

First, there is a SAS DATA step - one that is creating a new file (DATA statement) by inputting multiple SAS files (SET statement), one having variables RENAMEd). Two new SAS variables are computed in assignment statements using the SUM function. Lastly, the KEEP statements tells the SAS system specifically what variables / columns to output to the file specified on the DATA statement.

The DATA step is followed by a SAS PROC step, executing the PRINT procedure, printing all SAS variables in the file WORK.q2vienna.

Scott Barry
SBBWorks, Inc.

Google advanced search argument, this topic/post:

data step programming introduction site:sas.com

Re: interpreting the SAS code

Cynthia_sas — Thu, 18 Feb 2010 14:04:00 GMT

Hi:
And to supplement Scott's reply:
SET statement documentation:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001281588.htm
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001107839.htm

RENAME option and KEEP documentation:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000695119.htm

Expressions:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000998770.htm

PROC PRINT documentation:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000064113.htm

cynthia