Hi all,
Hope you had a lovely festive season.
I am studying for the Base programming certification exam and was wondering if
we need to know all the differences between the SAS / Access engines?
Are all the differences and nuances between them examinable?
Thank you very much, appreciate the help!
Bhagya
It’s not listed in the topics covered at all.
https://www.sas.com/content/dam/SAS/en_us/doc/other1/certification/exam-content/base-programmer.pdf
Basically, they are older to newer developments, as Excel changed, SAS had to modify how to read and write Excel files.
Excel is is used for older Excel files, xls.
PCFILES is for when your version of SAS and Excel differ, ie 64 bit SAS and 32 bit Excel
XLSX is the newest option to create and read XLSX files. It’s designed to work on Unix SAS well.
Thank you for replying Reeza, that's really helpful!
Appreciate the help 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.