How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
HSBC,
2 6854How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
HSBC,
2 9606I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
2257Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
ACC,
5 4809Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
1570I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
TCS,
5 9408
Difference between informat and format?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
If a variable contains only numbers, can it be a character data type?
what is intially documentation in sas?
how can you import .csv file in to sas? : Sas programming
how to change the execute of macro
How to convert a numeric variable to a character variable?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What are the functions which are used for character handling functions?
What is program data vector (pdv)?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
How to sort in descending order?
What is Linear Regression?
How many ways to overcome a missing values???
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.