tnx Tom. I will definitely look forward for that option.
Sheeba when you try to convert bigint to SAS numeric you are going to lose precision as numeric in SAS =floating= that is an implied dataconversion with limitations.
When you replace the bigint type with the char-type you are not changing anything as the identifier of a customer is not meant to do calculations.
Trying to do calculating a mean and variance on those identifier numbers is meaningless.
Would you use Sepa banking-accountnumbers you cannot use bigint as that contain characters (in some countries).
This type of smart compression using numbers within technology is coming of the old hollerith age. I am sorry for that.
Thanks Jaap. I will try to get familiarized with DS2
Hi ,
I have figured another way for reading the bigint column from Teradata. It is possible to cast the column as decimal while making passthrough. Then it is required to merge the temporary table(output of passthrough ) to the original table which requires column addition..
Regards,
Sheeba Swaminathan
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.