I'm still having some trouble getting used to the EG interface.   I have a project where I'm importing data from an Excel spreadsheet.  I recently moved some folders around on my LAN, so the Excel file is now in a new location.  Nothing else about the Excel data has changed.  However, when I try to open the "Modify Import Data" task so I can point it to the new location, EG freaks out, says that it can't find the data, and ends the process.   Are there any other solutions besides starting from scratch (and hoping that I remember all the settings from the last time I imported the data)?   ... View more

I just want to double check my thinking on this...  When using multiple set operators in SQL in a single SQL statement, are the actions performed incrementally?   For example, I have in my code:     proc sql; select distinct vv.naics_code from eds.pt_naic_codes as vv union select distinct loc.naics_code from eds.pa_location as loc union select distinct qcew.naics_code_pt_naic_codes as naics_code from eds.ps_qcew_data as qcew except select sched.naics_code from eds.ps_scheduling_naics as sched; quit;   and I want it to work so that it appends the first three tables before excluding the fourth table.     As written, will I be getting what I expect?     ... View more

Hey all!   Long time SAS programmer still getting used to the EG environment...   I have a question about how ODS works in the EG world.  I know that you can automatically set your results settings (Tools > Options > Results > Results General) to display your format in multiple destinations, and I use this for a good chunk of my day-to-day ad hoc work.  However, sometimes the options available are limited, so I want to use ODS code to explicitly get exactly the output that I want.   So, here's the question... If I have my results generator set to automatically create an Excel file, but then I also use ODS Excel to create an Excel file, does it create two separate files with two separate sets of options?  I believe it does, but I wanted to hear from the community with invariably more EG experience than I have...   Tasha     ... View more

Hey all!   I've got some survey data that came out of Qualtrics where the "Check all that apply" options were all put in the same field with commas separating the options.  For example,   We had a question asking what topics people were most interested in (select up to 5) and the results came back like this: Education,Technology Health care,Human services Health care,Human services,Justice and law ,Public safety and emergency ,Workforce and the economy Education,Housing,Human services,Justice and law ,Technology Agriculture,Education,Environment and natural resources,Health care,Workforce and the economy Health care,Human services,Technology,Workforce and the economy Environment and natural resources,Housing,Justice and law ,Transportation and infrastructure,Workforce and the economy Education,Environment and natural resources,Health care,Justice and law ,Technology Finance, accounting and procurement,Justice and law ,Tax and fiscal policy,Technology,Workforce and the economy Education,Environment and natural resources,Housing,Public safety and emergency ,Transportation and infrastructure Agriculture,Energy,Environment and natural resources,Transportation and infrastructure,Workforce and the economy Energy,Health care,Human services,Public safety and emergency ,Workforce and the economy Health care,Justice and law ,Tax and fiscal policy,Technology,Workforce and the economy Environment and natural resources Environment and natural resources,Health care,Justice and law ,Transportation and infrastructure,Technology     Clearly I'd like to split all this data up so that I can get summary counts of each topic.  Any thoughts on how I can do this quickly and easily?  I'm mostly stumped.  I don't even mind if I have a separate data set with one column where each row is a single response.  I'm totally cool with that.  Just don't know how to get there...     I found one option that sort of looks like what I want, if only I could get it to work for the entire dataset...  If you check out the SAS Documentation for the SCAN function (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm) under Example #2 there's a piece where it uses a do loop to split apart each word in a string.  However, when I tried this with my dataset (see sample code below) it only gave me the data for the first observation.  It's late in the day and I can't figure this one out.  Thoughts?     data split; set results; keep word; do until(word=' '); count+1; word = scan(Q6, count); output; end; run;       ... View more