cds data manipulation

hi is this possible in single cds view only if possible how and what syntax i need to use?

table name: tbl_loc

    define view.................
{
// loc1 data must be equal to newyork only
    tbl_loc.location as loc1,
    
    //loc2 data must be equal to canada only
    tbl_loc.location as loc2

}