Please provide som additional information (including, not limited to): - SAS version/products in use - OS - Scheduler used - Definition of "active user" ... View more

@narfaoui please create a new post for your inquiry. When doing that, make your system topology clear (an update in the test environment should't affect the production unless they share the same infrastructure). ... View more

Can you please provide some more information, like: - SAS version - What SAS/Access module your are using - options used in your libnmae statement - topography of your set-up Usually bulk-load is the fastest way to load an external DB, that might be available depending on the answers to the questions above. Using these options might give some clue on the processing: options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;   ... View more

This sounds insanely slow. A corresponding join in PROC SQL would be done in under lets say 20 seconds. What happens if you try the query in SAS Compute? ... View more

Is there a question here? If you need assistance, specify in what way, and state what you have tried so far. ... View more

Since it doesn't work outside SAS either, I would start by contacting the DBA's, and next som networking/infra team. Ping doesn't say much, sometimes ping can reach through even if the road is blocked. ... View more

Depends on how that multiple choice is represented in the data that SAS accesses. Example above give you the option to import the data in one cell, but have SAS logic to split them up into separate columns. ... View more

For context, what SAS version/operating environments are you migrating from and to? And you are saying a few flows migrated successfully with a correct time event, but the rest is missing that? ... View more

SAS Help Center: ROUND Function ... View more

One way of getting the min and max. Still, please elaborate what you mean by "curve". %let ref_dttm = 20NOV20:15:00:00; %let Dttm_min_1hr = %sysfunc(intnx(DTHOUR,"&ref_dttm"dt,-1 ),datetime16.); %let Dttm_plus_1hr = %sysfunc(intnx(DTHOUR,"&ref_dttm"dt,+1 ), datetime16.); %put &Dttm_min_1hr &Dttm_plus_1hr; proc sql; create table work.want as select participant_id, min(case when dttm > "&ref_dttm"dt then . else Measure end) as min_prev_hr, max(case when dttm < "&ref_dttm"dt then . else Measure end) as max_next_hr from work.have where dttm between "&Dttm_min_1hr."dt and "&Dttm_plus_1hr"dt group by participant_id ; quit; ... View more

So how do you wish? Are these columns to be generated later in the data step? And how will this be flexible? Flexibility can be built using macro variables or arrays. ... View more

The connection is dropped at the end of the PROC SQL step. Try to issue the LIBNAME statement before the PROC SQL's. Another work-around is to extract the data to SAS in the same/last PROC SQL. ... View more

I suggest that you read through the documentation for a better understanding: https://documentation.sas.com/doc/en/lrcon/9.4/n1kbstf7vw0qcjn1ibfc8c78a9lc.htm ... View more

All syntax within an EXCUTE or ..FROM CONNECTION TO blocks need to be in RDBMS specific. Anything outside these blocks should be SAS PROC SQL syntax. ... View more