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
- 8 Answers
- 13310 Views
- CitiGroup, I also Faced
- E-Mail Answers
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 purpose of the trailing @? The @@? How would you use them?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
how can u convert this 25-jul-2010 from numeric to charcter?
how to delete the duplicate columns permanently in SQL
What are the default statistics that proc means produce?
What is the maximum length of the macro variable? : sas-macro
how to generate means for every subject;
How would you identify a macro variable? : sas-macro
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
Describe a time when you were really stuck on a problem and how you solved it?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
What is the difference between where and if statement?
Teradata 
