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 |
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What is the order of application for output data set options, input data set options and SAS statements?
What is the use of stop statement?
how can u extract,transform and loading?
How to write duplicate records into a separate dataset using sort?
What is SAS informats?
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
what is the formula to measure Baseline
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
If a variable contains letters or special characters, can it be numeric data type?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
How would you code the criteria to restrict the output to be produced?