here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
2 7896hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
SAS,
5382Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 17141calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
6 8214
Describe a time when you were really stuck on a problem and how you solved it?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
which date functions advances a date time or date/time value by a given interval? : Sas programming
What are the difficulties u faced while doing vital signs table or dataset?
Did you used proc test? when?
What is the difference between the proc sql and data step?
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.
How do you define proc in sas? : sas-grid-administration
what do you mean by data staging area? : Sas-di
What are common programming errors committed in sas
what are the considerations when picking a SAS/STAT procedure?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What is the difference between SAS functions and procedures?
Tell e how how dealt with..
what is SAS OPTIMIZATION?