BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi Guys,

I have encountered a weird problem in SAS Data Integration Studio.

For instance.

I do an extract transformation to extract a subset of the source table and this is loaded to a temporary table.

Whenever, I change something to the job, my extract transformation will extract all the data columns on top of the the selected columns I have choosen. Then I need to delete the unwanted columns away manually.

Is there a way to solve this problem? I personally find it weird because it is also tedious to do that everytime i made a change to the job.

Can someone help me?

Thanks.

Yours Sincerely,
helphelp
1 REPLY 1
LinusH
Tourmaline | Level 20
In DI Studio 3.4: right click on the transform, and un-check Automap.
In SAS 9.2 (DI Studio 4.2) there is a more intelligent handling of this feature.

/Linus
Data never sleeps
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1032 views
  • 0 likes
  • 2 in conversation