Creating a Project Control Table

After you have planned the projects and models that you want to have in your portfolio, you must create a project control table that contains the segment identifiers, projects, and models. The project control table is then used to create the hierarchy of your portfolio when you create a new portfolio. The variable names that are required in the project control table are at least one segment identifier (for example, segid), project_name, and model. All variables other than project_name and model are treated as segment identifier variables. The segment identifier variables do not have a required naming convention.

data control_Table;
 length segid project_name model $20;
 infile datalines dsd dlm=',' missover;
 input segid project_name model; 
 datalines;
 seg01,US,reg1.spk
 seg02,Canada,tree1.spk
 seg03,Germany,hpf_class.spk
 ;
 run;