Intervals you can use in INTNX, from the documentation https://documentation.sas.com/doc/en/pgmmvacdc/9.4/leforinforref/n0pxq4af0hx60nn1i1x3xn41mc3c.htm#n0zn1re74n6pfvn170g9us41coho   For custom intervals, scroll down in the documentation to "Multi-Unit Intervals"   Regarding weeks that go from Saturday to Friday, you can scroll down to "Shifted Intervals" ... View more

How about that, the code marked correct had a typographical error.   This is the correct code   SAS_date = input(Excel_date,32.) + '30DEC1899'd ; format SAS_date date9.;     @ChrisHemedinger can this be fixed on the old post at https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Conversion-from-Excel-Date-to-SAS...  ? ... View more

Excel dates are different than SAS dates when PROC IMPORT is used. In fact, they are off by 60 years and 1 day.   See  https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/068-29.pdf https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Conversion-from-Excel-Date-to-SAS-Date/m-p/781804#M205 ... View more

Have you tried re-starting SAS and then running the code again? ... View more

Turn on the macro debugging tools by running this command.   options mprint;   Then run your code again.   Show us the log all the way down to the ERROR (all of it down to the error), pasted into the </> window.   ... View more

I asked to see 100 lines in the LOG before the error, you didn't show that. You showed the  code.   I said: "Now this is extremely important, do not skip this step. Copy the log as text and then paste it into the window that appears when you click on the </> icon. "   and you didn't perform this step. ... View more

Do not double post.   Please show us the part of the log that has the error. Let's see for example 100 lines before the error and of course the error itself.   Now this is extremely important, do not skip this step. Copy the log as text and then paste it into the window that appears when you click on the </> icon.  ... View more

In general, your question to sort all variables doesn't make sense. Once you sort by variable V1, this may make V2 out of sort order, and if you sort by V2, this may make V1 out of sort order.   So, when @Kurt_Bremser asks "What is your intended result?", I also want to know in words what you mean by "sort all variables". Showing us for this extremely small data set may not be sufficient. (And by the way @pavank you should always explain in detail what you want, and give examples of the desired output, in your first post, without us having to ask). ... View more

In general the solution to having disparate scales is to change the scale of the Y axis. One was to do this is to use a logarithmic scale. This will fail if some of the data values are actually zero — and I also don't know if it will work for VBOX because I never tried it.   There are many options in PROC SGPLOT for creating logarithmic scales. For example:   proc sgplot data=long noborder; vbox Value / category=Variable; yaxis type=log logbase=10 logstyle=logexpand; run;       ... View more

In other words, if the visit (DB1) occurs in the range Range1-Range2 of DB for each patient (ID) then it will be reported in DB to obtain DB2.   I don't understand what this means. Can you walk us through the logic, step-by-step? ... View more

Here's one way for N=5   data intermediate; set sorted_string; array letter $ letter1-letter5 _temporary_; last5letters=substr(str,length(str)-4); do i=1 to 5; letter(i)=substr(last5letters,i,1); end; call sortc(of letter:); last5letters_sorted=cats(of letter:); sorted_string=cats(substr(str,1,length(str)-5),last5letters_sorted); drop i; run;   For general N, you could replace 5 with a macro variable. ... View more

Ok, I don't see what is wrong with the code you are showing. (Why does everything have to be in the same WHEN statement?) Is there an error message? If so show us the log for this PROC SQL (all the lines in the log for PROC SQL, not just the lines with the error). Are you getting incorrect output? If so, please provide (a portion of) the input data and show us the incorrect output. ... View more

@yabwon  Can you explain why this works? ... View more