Hello!   I am using SAS Enterprise Guide 7.1.   I am concatenating multiple datasets together, however there isn't a date in any of the datasets, only the title. Is there a way to create a new column per dataset that I am concatenating?   My current code without the extra columns is (for visibility I've kept just 3 months that I actually need):   data cues; set cue_201603 (keep= id cue5 cue8 where=(ID IN (&c1.))); cue_201604 (keep= id cue5 cue8 where=(ID IN (&c1.))); cue_201605 (keep= id cue5 cue8 where=(ID IN (&c1.))); run; I was hoping there was a way to create a column called month per dataset and have it output 201603, 201604 and 201605, so that it is all under the same column.   I also only want to select certain columns to speed it up, so would like to keep the keep statement, and also the where statement, to only select the specific ids in a macro variable.   Can this be done?   Thank you! ... View more

Hello!   I am using SAS Enterprise Guide 7.1.   I am trying to create a macro that automatically pulls ids from a dataset and then the next bit of code selects the data associated with those ids. The current macro works fine, but only selects 1 id. How do I tweak it to allow multiple values?   On a separate note, I know how to create a list of ids in a macro, but it is manual, by using:   %let id = ('123', '456', '789')   I then add this into my code:   WHERE id IN &id. Is it possible to do something similar but automated?   The above code I use in PROC SQL. The code that I am using currently is a data step:   data _null_; set test; call symput('id1',id1); run; %put _user_; data test2; set Cues (where=(id = &id1.)); run; Not sure if it possible, maybe there is a different way?   Thanks in advance! ... View more

Hello,   I am using SAS EG version 7.1.   I am trying to build a bit of code where it can be used for the last 6 years. I am selecting the same fields, no matter the month. Unfortunately my piece of code has an error, due to the field not being in previous datasets where the field was added into the file. The 2 errors are as follows:   ERROR: Column Cue5 could not be found in the table/view identified with the correlation name B. ERROR: Result of WHEN clause 2 is not the same data type as the preceding results.   PROC SQL; CREATE TABLE Data AS SELECT a.* ,b.Cue1 ,b.Cue2 ,b.Cue3 AS Cue3_Old ,b.Cue4 AS Cue4_Old ,(CASE WHEN Version < '4' THEN . WHEN Version >= '4' THEN b.Cue5 ELSE . END) AS Cue5_Old FROM File AS a LEFT JOIN extra_data AS b ON a.id = b.id; QUIT; On the File that I am joining on the extra_data to, Cue5 doesn't exist before version 4, so I thought in the case when statement, it would put a missing value. It seems that it is failing due to Cue5 not existing in the dataset extra_data. All fields are numeric. The code works perfect for version 4 and above.   Does anyone know how to fix it? Any help would be greatly appreciated!   Thank you!       ... View more