interpreting the SAS code

[deleted_user]

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;

[sbb]

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

[Cynthia_sas]

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