topic Re: SAS Query in SAS Programming

Create a new variable with custom text

scb — Wed, 02 Aug 2017 14:30:47 GMT

I have the following codes, may i know how to get the following remarks?

Any idea? Thanks.

data a;
input staff house car;
cards;
1234 1 0
2234 5 1
3234 2 2
;
run;

Desired result

Staff Remarks

1234 1 house and 0 car

2234 5 house and 1 car

3234 2 house and 2 car

Re: SAS Query

PeterClemmensen — Wed, 02 Aug 2017 07:59:31 GMT

This is fairly simple to do in SAS. But I have to ask why you want a variable with a much more complicated string containing information that you already have in your dataset? 🙂

Re: SAS Query

Shmuel — Wed, 02 Aug 2017 08:00:03 GMT

All you need is to concatenate the given data with some literals:

data want;

set have;

remarks = catx(' ',staff,'house and',car,'car');

/* or: remarks = left(staf) || ' house and ' || left(car) || ' car'; */

run;

Re: SAS Query

ChrisBrooks — Wed, 02 Aug 2017 08:01:58 GMT

This is the simplest way

data a;
input staff house car;
cards;
1234 1 0
2234 5 1
3234 2 2
;
run;

data b(drop=house car);
	length staff 8 remarks $17;
	set a;
	remarks=cat(house,' house and ',car,' car');
run;