In SAS you can run a query builder and it outputs a table. But for some reason lately when I do that the output automatically pops up so to get back to the process flow I have to click on the "process flow" button. Is there a way to change these settings so that the output doesn't keep automatically popping up? I want to be able to run query builders without the window popping up so I can stay on the process flow screen.
... View more
I used "Create Time Series Data" but when I chose "Interval" as "Month (DATE) it still displays Jan Feb March April May as their own values I.ei. (5, 4, 1, 3, 6) instead of 5, 9, 10, 13, 19
... View more
Is it possible to use proc expand with SAS EQ using GUI? I've already built out a large query and don't want to throw a random program in the middle of it. I'm trying to get YTD numbers for example if I have 4 in January and 5 in February then my YTD in February would be 9. Thanks!
... View more
Hello, I have a variable of ID numbers (0001) and there needs to be an A before all of the numbers i.e. I have a variable ID: 0001 and I want it to be A0001. There needs to be an A before all of the numbers in the column I'm sure it's an easy thing but I can't figure it out! Please help!! Thanks
... View more
I also then want the date1 to be ("month of date1' , 1, 'year of date1') If I make a computed column and datepart(date1) then use that in the MDY function: MDY((datepart(date1), 1, (datepartdate1)) then it doesn't work
... View more
Ah I did see that post but forgot to include my other question. Whoops! Is it possible to use both datepart and mdy in the same statement? I.e. creating a computed column?
... View more
I have a variable date1 which shows, for example, 01JAN2010 00:00:00 and want it to show up (1/1/10) Do I do MDY(date1, 1, date1) How can I get it so that I can use the variable to populate to that format?
... View more
So it doesn't slow it down if there is only one END vs multiple ends? My main concern was slowing down the process but if it doesn't seem to make a difference then that's great news
... View more
I have started to get the hang of CASE statements and found that I write them differently than other people. Usually I do something similar to this, Case when Name=Joe 'Yes' else 'NO' when Name=Jane 'Yes' else 'No' end Other CASE statements I've seen use CASE ELSE and then multiple ENDs: Case when Name=Joe 'Yes' else Case when Name=Jane 'Yes' else 'No' end end Is one way more efficient? I find that using only one END makes it feel neat but I don't want to end up slowing the program down by accident. Thanks!
... View more
GOPTIONS ACCESSIBLE; Proc SQL: Create Table Gridwork.Query_B AS SELECT t1.First_Name, t1.Last_Name, (Case when t1.First_Name=t2.First_Name then "Y" end) AS 'Yes_or_No'n FROM Girdwork.Query_A t1 LEFT JOIN GRIDWORK.NewDoc ON (t1.First_Name=t2.First_Name); quit; ERROR: File GRIDWORK.NewDoc does not exist. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. QUIT;
... View more
