Hello EG Users, I am running into very standard issue of converting variables that represent into format that my code likes. In this snippet, I intend to create just one observation in TemporaryDays dataset that represents February 3 2014, however I need it to be in this format 03FEB2014 data work.TemporaryDays; input MDay $ 1-9; MDay = input(MDay, DDMMMYY9.); datalines; 03FEB2014 ; run; quit; Error: NOTE 485-185: Informat DDMMMYY was not found or could not be loaded. How do I go about making changes so that observation stored in TemporaryDays is of type date and not character; that matches what it would look like if I were doing: MDay = '03FEB2014'd; Thank you very much! Dhanashree ... View more

Hello EG Users, As I understand, it is possible to accept input from user by means of Prompts in Enterprise Guide and use it as dynamic variable in queries to pull only relevant data. Once the output is ready and charts are designed, if Analyst wants to add comments to the chart, is it doable? Is there a way to give analyst prompt so that their insights can be embedded in the final report? What I am looking for is simple text field that accepts text from analyst and embeds it in the report. In summary, final report is hybrid version of what the numbers tell the story as well as additional findings from wealth of experience that analyst has accumulated over several years? Thank You, Dhanashree ... View more

WrninHello EG Users, I intend to check for variable value before I decide if I would like to append the two datasets. Pseudocode: If CurrentDate = PreviousDate + 1 Then append two datasets Else let user know that there are missing observations for dates from (PreviousDate + 1) through (CurrentDate - 1) Is it possible to write PROC SQL or DATA APPEND code inside THEN clause of above conditional IF statement. Essentially access two entirely different datasets? IF CurrentDate = PreviousDate + 1 THEN PROC SQL CREATE TABLE WORK.TABLEC SELECT ActualDate, Total FROM TABLEA INNER JOIN TABLEB ON ActualDate ORDER BY ActualDate; RUN; ELSE  * Forcibly create empty dataset ; PROC SQL CREATE TABLE WORK.TABLEC SELECT ActualDate, Total FROM TABLEA OUTER JOIN TABLEB ON ActualDate ORDER BY ActualDate; RUN; TABLEA ActualDate Total 01/01/2014 10 01/02/2014 20 01/03/2014 30 TABLEB ActualDate Total 01/04/2014 40 TABLEC ActualDate Total 01/01/2014 10 01/02/2014 20 01/03/2014 30 01/04/2014 40 However if TABLEB contains ActualDate Total 01/06/2014 40 Then I would tell user that observation for 01/04/2014 and 01/05/2014 are missing and will not output appended dataset. Outer Join trick can be used to create empty dataset, just in case it is not possible to have WARNING pop-up. How can user be notified that there are missing observations for some days and two datasets cannot be appended. Is there way to comment it out into Project Log? or pop-up message Thanks, Dhanashree ... View more