What are the difference between sas functions and procedures?
No Answer is Posted For this Question
Be the First to Post Answer
How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal 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.
what is the usage for assigning error=1 in a dataset ?
how could you generate test data with no input data? : Sas programming
what are input dataset and output dataset options? : Sas programming
If a variable contains letters or special characters, can it be numeric data type?
Give e an example of..
What is substr function?
What is SAS informats?
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
Under what circumstances would you code a SELECT construct instead of IF statements?
what is sas metadata server? : Sas-di