SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

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

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!

--
Mario

Accepted Solutions
Solution
2 weeks ago
Occasional Contributor
Posts: 10

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

So ... My bad. Smiley Happy

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

 

--
Mario

View solution in original post


All Replies
Super User
Posts: 5,493

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

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

Data never sleeps
Occasional Contributor
Posts: 10

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

Hi,

 

The one that will give me the result I need.

 

 

--
Mario
Super User
Posts: 5,493

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

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?
Data never sleeps
Solution
2 weeks ago
Occasional Contributor
Posts: 10

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

So ... My bad. Smiley Happy

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

 

--
Mario
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 145 views
  • 0 likes
  • 2 in conversation