ravi


{ City } salem
< Country > india
* Profession *
User No # 12714
Total Questions Posted # 0
Total Answers Posted # 12

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 48
Users Marked my Answers as Wrong # 52
Questions / { ravi }
Questions Answers Category Views Company eMail




Answers / { ravi }

Question { Genta, 5326 }

Can you excute a macro within a macro? Describe.


Answer

yes we can excute the macro with in the macro ,it is possiple

Is This Answer Correct ?    5 Yes 0 No

Question { Accenture, 12818 }

Under what circumstances would you code a SELECT construct
instead of IF statements?


Answer

when ever we want check with more than condition we may use
if condition rather than select one

Is This Answer Correct ?    1 Yes 7 No


Question { Accenture, 9382 }

What is the one statement to set the criteria of data that
can be coded in any step?


Answer

option statement

Is This Answer Correct ?    4 Yes 0 No

Question { Accenture, 17006 }

If you have a data set that contains 100 variables, but you
need only five of those, what is the code to force SAS to
use only those variable?


Answer

data set name ;
set old data set name ( keep = a b c d e);
run;

By using above concept u can read what r the variables u
want to read ,first create data set having many variables ,
then try to read from some variables

Is This Answer Correct ?    9 Yes 0 No

Question { CitiGroup, 13303 }

1.How many ways are there to create variables?
2.What is CLM,how can we use it?
3.what are the advontages of data step?
4.what is the extension of editor window in SAS 9.1.3?
5.How do you copy a particular data set from one library to
another?
6.what is the use of double option?
7.Advontages of Proc Report?
8.what is the basic use of where statement?
9.How do you terminate the statments in SAS Programming?
10.What is the difference between symput and symget?
11.How would a identify the local and global variable?

can any one answer for the 4'th question


Answer

ans for 8'th one

by using where statement no need to read all the
observations in data step only we can read the mentioned
variable or observation

Is This Answer Correct ?    1 Yes 0 No

Question { CitiGroup, 6170 }

describe about joins? briefly?


Answer

we can use the set and merge commands to join the datas,use
merge if u like to joining data tables that has similar
observation and diff observation and relatted variable mean
use SET ,V can also use proc sql joing the data tables ,i am
beginner on sas so if any one have differ with my ans just
post to my mail kumarravi111@gmail.com

Is This Answer Correct ?    3 Yes 1 No

Question { 6713 }

How the date 04oct1994 is stored in SAS,not only give the
answer explain in brief?


Answer

i do not know the exact answer ,but read the date in this
format date mmddyyyy10.then it will give the result

Is This Answer Correct ?    0 Yes 15 No

Question { 18718 }

Approximately what date is represented by SAS date value of
730


Answer

it may be dec 31 1961 or jan 1 of 1962

Is This Answer Correct ?    7 Yes 4 No

Question { TCS, 21030 }

how we can create optional or required parameters in SAS
macro...


Answer

By using macros we can crate optional or required parameters

Is This Answer Correct ?    4 Yes 14 No

Question { Accenture, 7600 }

What report output formats can you generate using SAS?


Answer

we can generate many types of reports by using sas like RTF,
HTML. PDF , TABULATE FORMAT ,

Is This Answer Correct ?    12 Yes 1 No

Question { HSBC, 16397 }

Can you calculate the mean, median and mode of the following data set
using data step logic? Don't use any function or procedure.
data a;
input age @@;
datalines;
22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46
56 19 20
;
run;
I have calculated the mean which i have posted in the answer section.


Answer

Answer:

data new;
set a end = last;
count+1;
age_n+age;
if last then do;
mean = round(((age_n)/(count)),.8);
median = ((count+1)/2);
end;
run;

By the above program we can calculate the mean and median.
lets us know me, if anybody find the logic for find mode

Is This Answer Correct ?    0 Yes 6 No

Question { Quintiles, 10408 }

1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900

how to read the above data using input statement
consider the above data is in txt format externally
u have to use infile and input statement.


Answer

Answer:

data cityrank;
input rank 1-2 @3 city $13. @16 amoutnt comma15.;
datalines;
1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
;
run;

Is This Answer Correct ?    2 Yes 4 No