SAS On Demand for Academics (ODA) uses a server provided for SAS Institute. When you logon into ODA a request for a server is made, so you are demanding a server for academical use. That's the reason for it's name: On Demand for Academics.    The server runs SAS Studio, that is a kind of a source code editor where you can use SAS Base language. This code is compiled and processed in a server provided by SAS Institute.   After log on SAS ODA you can see which server you are demanding for use at the upper right.   SAS ODA   ... View more

I haven't tried this code, but it something like that... If A < B or A < C then A = .; If A gt B or A gt C then A = .;   Those variables are numerical? What kind of values do you have on each column? May you will have some problem when calculating the values. ... View more

Nesse caso vc está falando de identação. A sua identação, ao meu ver, está praticamente perfeita, de modo que a manutenção e continuidade do código pode ser feita com facilidade por qualquer um que tenha conhecimento em SAS BASE. A dúvida do carinha do tópico estava relacionada c/ fazer várias PROC SQL ou apenas um com variáveis/macros (% let) para tornar o processamento mais rápido.   No demais, parabéns pela identação. Vou aderir hahaha ... View more

Hi,   Try doing a LEFT JOIN instead of MERGE. Use the column ID for doing the JOIN function.     ... View more

I can't imagine some error during debugging process. At Enterprise Guide you must press the F5 key at your keyboard. It will open the Data Step Debugger. After this, you should see something like the picture below.   The Enterprise Guide compiles your code in real time, during the execution process. The debugger runs your code at the same time that reads your tables and their data.   You also can write some conditionals (e.g. if/else) statements to interact with your data using the _N_ and the _ERROR_  for checking something at the code, for example.   Anyway, could you post a picture from the error? ... View more

Actually I was doing the risk solution/management classes for banking industries. I guess that the correct name is SAS Asset Liability Management Solution.   We used to use SAS Enterprise Guide, SAS Infrastructure for Risk Management, SAS High Performance Risk and some other SAS Softwares. At that moment the instructor gave to me a lifetime license to SAS Enterprise Guide and the client installer but unfortunately I lost it.   I also have done SAS Programming 1 and SAS Programming 2 courses.   I'll check with the SAS Administrators at the company that I've worked. ... View more

They gave me a access for the online training but also gave me the installer of EGuide. I used to use SAS EGuide for some calculations that at the future are supposed to be deployed in charts. ... View more

I've done some courses in the SAS Office at Sao Paulo, Brazil. At that moment they give to the students a version of SAS EGuide Client installer but I lost my hard disk... I tried SAS Studio but it isn't the same thing. ... View more

It seems that you don't have access to replace the Access database.    Isn't the file being used for your SAS process? This could be a reason for your problem.   Try creating a new file and then merge with the previous file. ... View more