Can I use external SAS files as input?
I have a separate SAS file that contains formatting rules. How can I pull that into my main program so I don't have to rewrite the formats every time? I want to modularize my code so I can use it for ...
Are there specific books you recommend for the SAS Base exam?
I am a visual learner and I prefer reading a physical book rather than just scrolling through online documentation. What are the 'bibles' of SAS base programming that cover everything needed for the c...
Why am I seeing different results in SAS vs SQL?
I was trying to replicate a logic I used in standard SQL inside SAS. The grouping and aggregation seem to be returning slightly different numbers, especially with missing values. Does SAS handle NULLs...
How do I handle errors in a macro variable?
I keep getting warnings that a macro variable is not resolved, but I know I defined it earlier. It happens inside a conditional loop. Is there a scope issue I am running into? How can I ensure my macr...
Are there specific syntax conventions for SAS programming?
I am starting a new job and want to write code that looks professional and is easy for others to maintain. Are there standard style guides for SAS? For example, how should I indent my data steps or us...
What is the best way to handle library assignments?
I am working on a team where we use different folders for different projects. I keep having to manually write out long file paths in my LIBNAME statements. Is there a way to make this more dynamic? I ...
What are the common formats for SAS multiple choice questions?
I want to know more about the format of the exam questions. Is it mostly 'fix this code' type questions, or is it more about knowing the definitions of specific procedures? I have heard there are code...
Are there specific syntax traps to look out for on the SAS certification?
I hear people mention that the SAS Base exam has 'trick' questions where a missing semicolon or an extra space can change the whole output. Does anyone have experience with these? I want to make sure ...
Is there a recommended naming convention for Salesforce metadata?
Our current Salesforce org has custom fields named things like 'Field 1' or 'New Temp'. It is impossible to tell what they do or who created them. I want to implement a strict naming convention before...
Are there any pitfalls to using managed packages in custom architecture?
We are considering buying an AppExchange package for inventory management, but I am worried about the long-term impact on our org architecture. What happens if the package hits its own governor limits...
