@Ronein  Here is another paper has very relevant examples to your processing scenario Data movement issues: Explicit SQL Pass-Through can do the trick     ... View more

Here is a paper about uploading SAS data set/table into Teradata  https://support.sas.com/resources/papers/proceedings11/142-2011.pdf   ... View more

Check this paper https://www.lexjansen.com/pharmasug-cn/2017/AD/PharmaSUG-China-2017-AD07.pdf for examples ... View more

Shouldn't you use connect using tr; if your libname reference is TR, then you should use TR for your connection ... View more

@Ronein  I don't think I said this "export the TeraData result into txt file and import it into sas and then work on SAS"!! In SAS, you can directly create a SAS data set from the result sets of you Teradata query. This is the native functionality of the SAS/ACCESS Interface to Teradata. There is no need to export to txt and import from txt!   I guess, we need to clearly understand your definition on "Can't it all be done in SAS????" to make sure we are on the same page - You have data/tables stored in Teradata  - You have data /tables stored as SAS data set (*.sas7bdat) files   What we have been saying (on this thread and your other thread) - You can use SAS software to submit queries, but these queries will perform much better if you kept the tables where they and only move the subsets where it made sense.   Say you have 1. Teradata table with 10 millions records in it, and another table with 5 million records --> Joining them would result in 3 million records 2. SAS data set with 1 million records --> Joining it with the 3M result set generates 1.5 million records   It would make no sense to download these two large tables (10M, 5M) from Teradata into SAS data sets to do the join!!   You are better off - Uploading the 1M SAS data set to Teradata, Perform the join with the 3M result set - Download the 1.5M result set into SAS data set   Hope this clarifies things for you, Ahmed   ... View more

Hi @Ronein  Typically you want to keep the processing close to where most of your data resides! Depending on the size (Records count, and columns count) of your intermediate query result sets in comparison to your SAS data sets. Teradata results sets larger than SAS data sets --> Use SAS Bulkload to upload your SAS data sets to temporary (Volatile) tables in Teradata and let Teradata query it. Teradata results set smaller than SAS data sets --> Download the results sets from Teradata and use native SAS Data/Proc Step(s) to process and manipulate the data. Generally these are best practices we have been taught to follow. Check this 2007 paper for reference: Super Size It!!! Maximize the Performance of Your ETL Processes      Hope this helps, Ahmed ... View more

@Ronein  Have you considered using CTE(s) instead of Volatile Tables in Teradata? https://support.teradata.com/community?id=community_question&sys_id=c258c3671b97fb00682ca8233a4bcba2 https://support.teradata.com/community?id=community_question&sys_id=45d68bef1b57fb00682ca8233a4bcb55   If you only want to derive subset of data based on information held in another derived table/query, CTE might be a better option!? The above two links might provide you with some insight. Disclaimer: I have used CTE(s) before with Snowflake but not Teradata.   Hope this helps, Ahmed       ... View more

Hi @Jeff_DOC  Typically when starting PROC SCAPROC, you would specify the recording file along with some options * Start recording info to a text file ; proc scaproc ; record "<FileName>" attr opentimes expandmacros ; run ; In order to capture your macro programs logic and parameters, ensure to have at least the following options in effect before starting the recording  options symbolgen mprint mprintnest msglevel=i ; All the macro debugging information should be captured in the source code section with the recording output file.   Hope this helps, Ahmed  ... View more

Hi @AnirbanJD1  If I may add to @Quentin , @SASKiwi responses. I would highly advice you to: 1. Learn how to integrate these technologies and use the best of their combinations where possible. Both SAS 9.4 and SAS Viya provide integration with Python, R, Lua, and Java. Their level and method of integration do vary, but you do with what they offer. 2. Do not listen to the old line of "Open Source Software such as R & Python can not handle large data"!, Whoever repeat that line to you, knows nothing about the recent advancements in the OSS universe.   OSS is becoming the mainstream right now, and no one can stop its wave! So you'll be better served riding it rather than ignoring it and getting subsided by it.   just my two cents, Ahmed    ... View more

Hi @Genta20201  Depending on which version of SAS software you are trying to learn/use. SAS Institute has two offerings for students! This video should help with your decision making https://www.youtube.com/watch?v=8v8Z5QVcRMs, and the video description has a lot more links to explore Good luck with your learning journey   Hope this helps, Ahmed ... View more

Hi @robinkp456  You'll need to examine your SAS software deployment. Support for Double-Byte Character Sets (DBCS) which includes UTF-8,  has to be explicitly set during the installation/deployment step. Depending on your Operating System platform (Windows/Linux), if MBCS has been selected during the install, then - Windows: You could see multiple SAS Shortcuts with corresponding/supported Character Sets  - Linux: You should see multiple SAS executables (sas_en, sas_u8, sas_dbcs) under the <SASHome>/SASFoundation/9.4/bin directory   Hope this helps, Ahmed ... View more

Hi @Anita_n  Have a look at this paper https://support.sas.com/resources/papers/proceedings16/2500-2016-poster.pdf by my friend @AndySmith  His presentation tackled/addressed similar issue back in 2016.   Hope this helps, Ahmed ... View more

Hi @Demarchi83  SAS Proc SQL which I think is based on SQL 1992 standards does not support SQL windowing analytical functions. You alternatives are :  - Data Step with the DOW loop --- Fully Customizable  - Proc Report --- Fully Customizable  - Proc Freq  --- Limited Customizable  - Proc summary/means --- Limited Customizable   Hope this helps, Ahmed ... View more

Hi @odrisco4    You'll need to fix your use of the folder separator and macro definition %let home = /home/<my username>; * Remove trailing /; filename Totals “&home/Totals.csv”; * Use / instead of \; ... View more