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
Answers were Sorted based on User's Feedback
Answer / priyanka
1a) 9 ways to create macro variables
1.into clause of proc sql
2.%local
3.%windows
4. %input
5.%let
6.%do
7.call symput
8.
9.
2a)confidence limit means in statics procedure to get
confidence limit means for certain degree to get statics to
analyse the data
3a
4a).sas7dbat
5a)proc copy in= dataset out=output dataset;
select dataset;
run;
6a)double option is used in proc print procedure to leave a
blank line between two consecutive rows in an listing
output and does not show any effect on html output
7a)proc report produce summary tables with plenty options
8a)where statement is used to select the particular records
from the input tables/data
9a);
10a)sumput is to write a value to macro variable
symget is to read the value is symput into sas
11a)variables created in macrodefintions are identified as
local variables or use %put _LOCAL_;
variables created in OPENCODE are identified as GLOBAL
variables or use %put _GLOBAL_;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ravinder.arakati
9 ways we create a macro varisbles are
1)%let
2)macro parameter(a,b)
3)%do
4)call symput
5)sql into clause
6)%window
7)%global
8)%local
9)automatic
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Answer / myself
Any way i got the answer the answer for the 4'th question is
.sas7dbat
for versions7,8 and 9 the file extension is .sas7bdat.
For the version 6 on UNIX it has the file extension .ssd01
and on windows it has .sd2.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / vijayaragunathan.r
9th question ans
ENDSAS; is used to terminate the SAS program.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vemula
5. Proc datasets procedure and proc copy procedure where
proc we can copy.
6. double options gives space between coumns
10. symput to store or assigna a value and symget to get a
value.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / no need
3. We can create datsets from rawdata files.
manipulate the datasets, merging, appending,concatinatig,
all we can.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / mallikarjuna raju
For 10 :
callsymput: We can create macro variable from the dataset
variable during the datastep execution time.for
this process the data set variable must be
existed.
symget: using with symget function you can create data set
variable from the macro variable. for this process
macro variable must be existed.
| Is This Answer Correct ? | 0 Yes | 1 No |
How we can call macros with in data step? : sas-macro
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
how does sas handle missing values in sort order? : Sas programming
What is program data vector (pdv)?
What are Dashboard reports?And significance of these in analysis?
how do u test a pros sql(works or not) without executing it?
How does the internal authentication work in sas? : sas-grid-administration
code the tables statement for a single level frequency?
How would you delete duplicate observations?
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
wt is a-z and a--z?