topic Re: SAS DI Studio setting specific value on all rows for certain column in SAS Data Management

SAS DI Studio setting specific value on all rows for certain column

strsljen — Fri, 01 Dec 2017 08:49:53 GMT

Hi,

Within mapping part I need to introduce new column and to set its value for all rows (for example set it to string "test").

I presume I set it in "expression" part when defining that new column, but I didn't find the right way to do that.

Can someone give me a hint how to do that?

Thanks!

Re: SAS DI Studio setting specific value on all rows for certain column

LinusH — Fri, 01 Dec 2017 14:02:26 GMT

That is the "right" way, or what do you mean?

Re: SAS DI Studio setting specific value on all rows for certain column

strsljen — Mon, 04 Dec 2017 07:08:37 GMT

Hi,

The one that will give me the result I need.

Re: SAS DI Studio setting specific value on all rows for certain column

LinusH — Mon, 04 Dec 2017 07:11:42 GMT

DI Studio generates SAS code.
In SAS programming (and most other languages) character constants should be within single or double quotes.
What have you tried?

Re: SAS DI Studio setting specific value on all rows for certain column

strsljen — Mon, 04 Dec 2017 09:46:22 GMT

So ... My bad. 🙂

I tried to set string with single quotes and needed double quotes (in "expression" field when I defined new column).