This would be a good application for SAS/Share if I understand your need properly.   With SAS/Share, you'd define the libref inside the SAS/Share server's configuration. Users would the do their libname to the SAS/Share server refering the "alias" libref instead of the actual location.     Thanks, ... View more

Hi Alexio,   That is why I'm recommending the use of INTNX, your ensure that the "day" part of each date is set to 1 (beginning of the month). This way, when you do the PROC SORT NODUPKEY, all dates in a given month will be dedupped.   With INTNX you should be able to perform that vast majority of your date transformations.   The format you apply on a colum does not change the content. Thus, even if you took a date column and applied a format that does not display the day, the actual data still contains the information about the day. This is where the use if INTNX is important.   Thanks, ... View more

Maybe I misunderstand what you're trying to do...   The following code is a very straightforward way of "stripping" the DAY of in a date. After that, you can run proc sort nodupkey to remove duplicates if you need.   It effectively "extracts" the Year and Month part if you want.   With larger datasets, going back and forth to a character string is not very efficient...   data dates; input date ANYDTDTE.; format date date2 DATE.; date2 = intnx('month', date, 0, 'b'); datalines; 2018MAY01 2018MAY02 ; run; ... View more

If you start with the date as a date, why don't you simply use the INTNX function to remove the "day" part, that would be much easier that trying to do format/informat gymnastic... ... View more

You could create the table with an explicit pass-through and the use a simple proc sql insert statement to populate it. ... View more

Have you tried using an explicit pass-through? Usually, this is the best way to use Database specific functionnalities.   See this URL: http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a003113595.htm   Thanks, ... View more

Hi vkrishna,        Have you considered open a ticket with SAS Technical Support? I am pretty sure that they can help you address this "time out" issue. We have multiple instances of the Web Application server here and I never had this error. So while it may not cause any problem, I would not call this normal behavior.        For this kind of stuff, while forum member may try to do their best to help you. My experience is that SAS Tech Support is the best way to go.   Thanks, ... View more