topic Re: Need Help for SAS Data Integration Studio 3.4 in SAS Procedures

Need Help for SAS Data Integration Studio 3.4

deleted_user — Tue, 04 Aug 2009 06:32:47 GMT

Hi,

I have just getting started to use SAS Data Integratino Studion 3.4 I have a question to ask.

Problem:
The length of the target column is shorter than the source column. A derived mapping is required between these columns. Do you wan to create an expression?

Eg src data field: student_id; data type numeric; data size 8
target data field: student_id; data type numeric; data size 7

How can I overcome this problem?

Thanks. 😃

Yours Sincerely,
helphelp

Re: Need Help for SAS Data Integration Studio 3.4

DanielSantos — Tue, 04 Aug 2009 07:41:02 GMT

Actually this is quite wrong.
You are trying to populate a variable that is shorter in size (1 byte less) than the source expression, so truncation may occur.

The right way to avoid this, would be resize BOTH variables to a desired value.
What is the range of values of the student_id var?

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.

Re: Need Help for SAS Data Integration Studio 3.4

deleted_user — Tue, 04 Aug 2009 08:28:26 GMT

Thanks for the reply.

What if there is a situation like this, what should be done when you are mapping the source column to the target column? Is there any function to change the data size?

Thanks.

Yours Sincerely,
helphelp

Re: Need Help for SAS Data Integration Studio 3.4

DanielSantos — Tue, 04 Aug 2009 09:17:06 GMT

Yes there is.

Check the online documentation for the TRUNC function:
http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000245963.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.

Re: Need Help for SAS Data Integration Studio 3.4

GertNissen — Tue, 04 Aug 2009 09:42:30 GMT

When mapping you can create an expression using i.e. trim(), strip(), substr() or another function to change the length.

But remember to look into why you wan't to change the length on your target table.

Re: Need Help for SAS Data Integration Studio 3.4

DanielSantos — Tue, 04 Aug 2009 11:19:43 GMT

> When mapping you can create an expression using i.e.
> trim(), strip(), substr() or another function to
> change the length.
>
> But remember to look into why you wan't to change the
> length on your target table.

True for alphanumeric variables, which is not the case.

Of course you could always convert them to alpha, trim, then back to numeric. But, a little bit confusing to do.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.

Re: Need Help for SAS Data Integration Studio 3.4

GertNissen — Tue, 04 Aug 2009 12:32:42 GMT

ups, sorry your right - had not seen it was a numeric variable - my fault.

Re: Need Help for SAS Data Integration Studio 3.4

deleted_user — Wed, 05 Aug 2009 03:11:05 GMT

Is there a function to cahnge the data size of the numeric data type without changing the data?

E.g. student id = 12345678 data size 7 (source)

same as

student id = 12345678 data size 8 (target)

Thanks

Yours Sincerely,
helphelp

Re: Need Help for SAS Data Integration Studio 3.4

Peter_C — Wed, 05 Aug 2009 12:50:02 GMT

it is not a function that sets a numeric variable's length, but the data definition.
In the mapping where the variable is first defined, see if you can set its properties, including its length.

PeterC

Re: Need Help for SAS Data Integration Studio 3.4

DanielSantos — Wed, 05 Aug 2009 14:11:46 GMT

Have you tried this?

> Yes there is.
>
> Check the online documentation for the TRUNC
> function:
> http://support.sas.com/documentation/cdl/en/lrdict/617
> 24/HTML/default/a000245963.htm
>
> Cheers from Portugal.
>
> Daniel Santos @ www.cgd.pt.

Re: Need Help for SAS Data Integration Studio 3.4

Peter_C — Wed, 05 Aug 2009 16:50:49 GMT

nope
looking at it now, it is interesting and useful outside of DI, but...
but in the DI environment, you need to register such column attributes, or you lose them.. Possibly the same will happen in E.G.

PeterC

Re: Need Help for SAS Data Integration Studio 3.4

DanielSantos — Wed, 05 Aug 2009 17:10:07 GMT

Hello Peter.

I was actually asking HelpHelp, because he/she had already posted the question before, and that was my answer.

From my SAS DI Studio experience there is nothing wrong mapping different variable sizes (bigger to smaller, which is the case), IF an expression is specified to convert/truncate the source value. SAS DI Studio uses the same principle, as stated in the error message.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.

Re: Need Help for SAS Data Integration Studio 3.4

LinusH — Mon, 10 Aug 2009 10:10:59 GMT

The easiest way I found in these situations is just to map using a derived expression, and just pick/print the source columns name.
As discussed earlier, you need to be sure that truncation (loss of numeric precision) will not occur, but going from 8 to 7 bytes should in most cases be safe, at least if only integers is to be stored.

/Linus

Re: Need Help for SAS Data Integration Studio 3.4

deleted_user — Tue, 11 Aug 2009 05:31:44 GMT

Hi Guys,

Thanks for helping me out.

the trunc function only allows you change from a smaller size ( i.e from a data size 8 to 7)

What if I am needed the other way round ( E.g. from a data size 7 to data size 😎
the trunc function will not allow me to do that.

So, is there any function that allows me to do this kind of upsizing the data size? )

Thanks

Yours Sincerely,
helphelp

Re: Need Help for SAS Data Integration Studio 3.4

LinusH — Tue, 11 Aug 2009 07:46:12 GMT

To "upscale" a column, numeric or char, you don't need any function, both SAS programming wise and in DI Studio, you just map the columns 1:1.
/Linus

Re: Need Help for SAS Data Integration Studio 3.4

deleted_user — Thu, 13 Aug 2009 02:01:43 GMT

Thanks so much for the help you all have given me.

Thank you very much

Re: Need Help for SAS Data Integration Studio 3.4

deleted_user — Thu, 13 Aug 2009 02:02:54 GMT

Hi,

Do you know how am I able to read a foriegn language data into SAS Data Integration studio?

THanks.

Yours Sincerely,
helphelp

Re: Need Help for SAS Data Integration Studio 3.4

LinusH — Thu, 13 Aug 2009 07:19:07 GMT

I'm not aware of any complications when working with different language data in the DIS application. There are some concerns that you may have when setting up system options etc in Foundation. See National Language Support in on-line doc.
If you like to discuss this in further detail, I suggest that you post a new thread.

/Linus