aravind rangaraj


{ City } hyderabad
< Country > india
* Profession *
User No # 19334
Total Questions Posted # 2
Total Answers Posted # 5

Total Answers Posted for My Questions # 9
Total Views for My Questions # 17041

Users Marked my Answers as Correct # 34
Users Marked my Answers as Wrong # 0
Questions / { aravind rangaraj }
Questions Answers Category Views Company eMail

how do you validate sas program?

Accenture,

6 SAS 11781

define table lookup and how may ways it can be done...explian

3 SAS 5260




Answers / { aravind rangaraj }

Question { 18048 }

How would you code the criteria to restrict the output to be
produced?


Answer

use _null_ in data statemnet when u dont want to create
dataset.to restrict the output to be produced, close the
ods listing destination and this is default destination
and you can also restrict the output using no print option
in some procs such as means,sql,etc...

Is This Answer Correct ?    12 Yes 0 No

Question { 12180 }

how do u identify a macro variable


Answer

ampersand(&) followed by non blank character.

Is This Answer Correct ?    8 Yes 0 No


Question { 10219 }

How would you code a macro statement to produce information
on the SAS log? This statement can be coded anywhere.


Answer

%put stament is used to print the information about macro
variable references and this statemet is
global.mprint,mlogic symbolgen are system options and used
to print the information in the log to debug the macros

Is This Answer Correct ?    3 Yes 0 No

Question { Parexel, 10195 }

what is picture format? give any one example?


Answer

picture format is used to Create a template for printing
numbers.
ex:
proc format ;
picture nozeros low - -1 = '00.00' (prefix='-')
-1< - < 0 = '99' (prefix='-.' mult=100)
0 - < 1 = '99' (prefix='.' mult=100)
1 - high = '00.00';
run;

Is This Answer Correct ?    5 Yes 0 No

Question { TCS, 26875 }

how to display duplicated observations in a data using base
sas.


Answer

two ways u can do ot.
1. proc sort with dupout option.
2. data step:
data nodups dups;
set sample;
by x;
if first. and last. then output nodups;
else output dups;
run;
proc print data=dups;
run;

Is This Answer Correct ?    6 Yes 0 No