Hi,   This is a rather strange question but hopefully someone has an answer or thought. I've been exporting data to a specific file location multiple times a day, overwrite the data and export it to Salesforce. Throughout the year there have been multiple edits to values, columns etc. and the export has always shown the changes.   There was an issue with logic in the query where new calculations were needed for two weeks in the year that I edited yesterday. For example, for the week of 5/24 instead of the Sum of Column 1 being 8 it needs to be 16. When I filter the final data table in SAS it shows as 16, however, when I export the data then re-import it into a new SAS query the value shows as 8.     Are there any thoughts/reasons why the value changes from the final data table vs the export? ... View more

Hello, I am working on taking code from a program and building it out in GUI format for other SAS users who have limited understanding with reading programs.   I came across code similar to the following: proc sql; CREATE TABLE Gridwork.Test AS  SELECT t1.ID1                 t2.ID2                 t1.First_Column,                 t2.Second_Column FROM Gridwork.Dataset1 t1 LEFT JOIN Gridwork.Dataset2 v2 ON (t1.ID=t2.ID) AND (t2.ID <> "0") WHERE t1.First_Column not is missing QUIT;   My question is in regards to the "AND" within the Left Join statement.  Is it the same as just taking t2.<>"0" and putting it in the where statement similar to below?   CREATE TABLE Gridwork.Test AS  SELECT t1.ID1                 t2.ID2                 t1.First_Column,                 t2.Second_Column FROM Gridwork.Dataset1 t1 LEFT JOIN Gridwork.Dataset2 v2 ON (t1.ID=t2.ID) WHERE t1.First_Column not is missing AND t2.ID<>"0" QUIT;   I'm unsure of how to make that "t2.ID<>"0" distinction within the "Tables and Joins" section of SAS EG.  There only seems to be the ability to pick the join, join order and that's it. Any "and" functionality without programming seems to lead itself to a "Where" clause but that looks different than the code.   Hope I explained this well and thanks for any help!   ... View more

I was recently told that to schedule SAS jobs the project has to be in program form but my project is currently in GUI form. Is there a way to run the full project and then gather all of the background code and just use that as the program? ... View more

Hi, I'm trying to create new columns so that my data can fit into a single row instead of having multiple rows.  I need this data to show this way because I'm trying to see what states at what times using the ID field. I'm unsure how to go about doing this and have shared an excel document that might make more sense. ... View more

Hello, There are different string variables from different months of data that I'm trying to pull to create one sheet of data where there aren't duplicate rows of data.  When I do this through a case statement or joining data a blank row shows up for where it does not agree. For example, if someone has two different managers in October and November I want the employee to show only one row of data and have an "October Manager" column and a "November Manager" column.  I know that when using numbers you can simply sum the info but with string variables it's proving to be more challenging. I've included a picture that will hopefully shed some light on what I'm looking for.   Thanks for any help.     ... View more