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 SAS statements would you code to read an external raw data file to a DATA step?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
what other SAS features do you use for error trapping and data validation?
What are _numeric_ and _character_ and what do they do?
What is the purpose of trailing @ and @@? How do you use them?
What are the data types does SAS contain?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What function CATX syntax does?
wt is a-z and a--z?
What are the limitations for memory allocation for SAS variables