Yes! Thank you very much! ... View more

Thank you so much! ... View more

Hi,   Good point. I can't share my actual data, but can provide the used query(s). DATA geo_events2; SET WORK.GEO_EVENTS; x = lon; y = lat; rownum = _n_; RUN; proc gproject data=work.geo_events2 out=projected parmin=mapsgfk.projparm parmentry=world; id rownum; run; proc ginside data=projected map=mapsgfk.world out=countries; id id idname segment; run;   So with this code I rename my lat long to x and y and create and eventid (rownumber). With the next step the 'Projected' set contains an x and y. With proc ginside I can find the country(s) belonging to de gps-data.   Although I can see the Netherlands now, it's not providing me with the province in Netherlands (duh... It's not in mapsgfk.world)   So I looked for the Netherlands in the same library. There's a sets with lat long and x and y. BUT non of the x and y's in the previeus set is near/close to the province x and y. So another ginside has no point because all the x and y are outside the x and y in the mapsgfk.netherlands set.   Perhaps there's a simpler way of getting my question answered then the above code. What I want is to add country and province to my latlong data in geo_events.   p.s Also tried the code below... Same results, different library goptions reset=global border; data gpscounties; set work.geo_events; x=long*arcos(-1)/180; x=x*(-1); y=lat*arcos(-1)/180; run; proc ginside data=gpscounties map=mapssas.world out=gpscounties; id id cont; run; ... View more

Thank you for your time!   That's just what I did. I used the code in the link and tested what worked and what didn't. The list attrs  works fine when I use it in the PROC IOMOPERATE.   proc iomoperate uri=&connection.; list attrs cat='Information'; quit;   But running the following code results in the error /* Get a list of processes */ proc iomoperate uri=&connection.; list spawned out=spawned; quit; /* Use DOSUBL to submit a PROC IOMOPERATE step for */ /* each SAS process to get details */ /* Then use PROC TRANSPOSE to get a row-wise version */ data _null_; set spawned; /* number each output data set */ /* for easier appending later */ /* TPIDS001, TPIDS002, etc. */ length y $ 3; y = put(_n_,z3.); x = dosubl(" proc iomoperate uri=&connection. launched='" || serverid || "'; list attrs cat='Information' out=pids" || y || "; quit; data pids" || y || "; set pids" || y || "; length sname $30; sname = substr(name,find(name,'.')+1); run; proc transpose data=work.pids" || y || " out=work.tpids" || y || " ; id sname; var value; run; "); run;          ... View more

We're running on 9.04.01M2P072314   ... View more

I love this task..... At least what I can see in the blogpost 🙂   When I run the task, I'm getting an error: ERROR: Requested function is not implemented. ERROR: Unsupported function ERROR: The LIST ATTRIBUTES command failed.   I've narrowed it down to the dosubl-function. The list attributes works on it's own. What's wrong..... Do I have to do something special to use this function?   ... View more

Thank you for your time and effort.   When I run your code it skips a couple off detects_dates --> 31mar2001 for instance. ... View more

Thank you for your time and effort.   In this solution I have to determine and 'name' the dates that are exceptions. In Kurts solution I don't have to do that. But again, thank you for taking the time! ... View more

Thank you very much! This is very helpfull. ... View more