SAS Output help

nickspencer — Thu, 10 May 2018 01:49:22 GMT

I have a SAS dataset as follows

ID    main_city    city1 city2   city3   city4
123 Newyork        Dallas    Chicago    SF Atlanta
234 Dallas    Chicago Newyork   Dallas Atlanta
345 Chicago Newyork Atlanta Austin Boston
456 Denver Denver Baltimore Miami Chicago

I want a field called city in the output which should have the value of null if none of city1-city4 matches with main city but will have the value of main city if it matches with any of the values of city1-city4.The example output should be as follows.

ID City Value1 Value2 Value3 Value4

123 Dallas Chicago SF Atlanta

234 Dallas Chicago Newyork Dallas Atlanta

345 Newyork Atlanta Austin Boston

456 Denver Denver Baltimore Miami Chicago

Re: SAS Output help

ChrisNZ — Thu, 10 May 2018 02:29:57 GMT

Like this?

city=ifc(whichc(main_city, of city1-city4), main_city, ' ');

Re: SAS Output help

novinosrin — Thu, 10 May 2018 02:30:56 GMT

data want;
set have;
array t(*) city1-city4;
if main_city in t then city=main_city;
run;

topic Re: SAS Output help in SAS Programming

SAS Output help

Re: SAS Output help

Re: SAS Output help