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 |
What is the basic syntax of a sas program?
what is star schema? : Sas-di
Code a PROC MEANS that shows both summed and averaged output of the data.
Where do you use proc means over proc freq?
how can you sort the dataset having millions of OBS(instead of sort procedure?
Where do the database management systems store data and how do u import them.
what is the difference between floor and ceil functions in sas? : Sas-administrator
When you will use nowd option in report???
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
One way of creating a new variable in Macros is by % Let....What is the other way..?
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
what are the validation tools in sas?