How to find out no. of business days in a month using
macros.???(excluding weekends and holidays).
Answer Posted / oanhntt
first of all, identify the last day of month (using this
intnx('month',d,1)-1). after that make a loop through 1 to
end of month, check if day in loop is weekend or not, using
another variable to count this number.
Regarding to the holidays, except some popular holidays which
I suggest using an external file/dataset to track it, use
this file to identify holidays.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Mention the validation tools used in SAS?
What is the use of function Proc summary?
describe about metadata object? : Sas-di
what is hierarchy flattening? : Sas-di
Why and when do you use proc sql?
Do you need to know if there are any missing values?
Are you involved in writing the inferential analysis plan? Tables specifications?
Give an example where SAS fails to convert character value to numeric value automatically?
How will you generate test data with no input data?
How do you delete duplicate observations in sas?
what is ae onset date n what is RDS
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
Are you involved in writing the inferential analysis plan? Tables specfications?
What Proc glm does?