1. What is the use of Varnum option in Proc Contents ?
2. Missover & Truncover can only be used in infile statement. ?
- True
- False
3. Difference between DO While & DO Until ?
4. Difference between NoDup Key & NoDup out in SAS ?
5. Does Scan function works on word only ?
- True
- False
6. Give the syntax for to clear the Log window?
7. Difference SAS DATA Step & SAS Proc step.
8. What is the difference Put as function & Put as a statement?
9. By Class statement in in Put means what we tells the SAS.?
10. How does the SAS Processor works ?
- It compile
- Interpret
11. Difference between nodupkey & nodup in SAS ?
12. What is difference between Single Dash (A1-A4) & Double Dash (A1– A4) in SAS?
1. Can we have the data from the table into the Input Buffer. By using the set statement.
- True
- False
- Tell various ways to limit the observation the from the Table and also write the syntax fot that assuming the 8 observation to processed out of 16 observation.
- What will be the output of this :-
data formatchek ;
format sal dollar. ;
input sal id;
cards ;
10.000 2
12,000 3
;
Run;
- Missing Value
- $10
- No output showing error
- Proper values with only $ in sal column
- Which one is fast ?
- keep, drop as a option
- keep, drop as a statement
- Which one is slow ?
- Keep/Drop use in Set Statement.
- Keep/Drop use in Data Statement.
- Syntax of which date format is wrong, if wrong then write the correct syntax ?
- 19/10/1989 – ddmmyy10.
- 01Mar2014 – ddmmyy9.
- What are Blue words in SAS ?
- LAG Function in SAS Store the value in ?
- Give example of Summary Function ?
- In which substr can’t work ?
- ASDIRF
- 11245
- AOIT.D
- It work in all of the options.
11-13.
data studentDetails;
Infile datalines DLM =’,’;
input Studentid Name $ SubjectId;
datalines;
100, Vijay ,1001
104, Amaresh,1003
105, Abhishek,1005
103, Rohit,1004
102, Sandeep,1005
;
run;
data SubjectDetails;
Infile datalines DLM =’,’;
input SubjectId subject $ Maxmarks;
datalines;
1001, Maths ,144
1003, Hindi, 107
1004, sans, 15
1002, eng, 76
1007, eng, 82
;
data abc;
merge Studentid(in=V) SubjectDetails(in=U) ;
by SubjectId ;
run;
- If we want the Student id which is not common in table abc . What is the correct syntax for t that
- . V=1
- . V=1 & U=0
- . V=1 & U=1
- .V=0 & U=1
- If we want the common records of Studentid & Subject Details . Then what is the syntax for that?
- a.V=0 and U=0
- b.V ne 1 or U ne 1
- c.V =0 or U =0
- d.V=1 and U=1
- If we want the non common records of Studentid & Subject Details . Then what is the syntax for t that?
- V=0 and U=0
- V ne 1 or U ne 1
- V =0 or U =0
- V=1 or U=1
- Is it needed to use the By statement in 1 to 1 merge. ?
- Yes
- No
- What is the purpose of Retain Statement ?
- What is the name Default Library in SAS ?
- What is the Syntax for Proc Transpose ?
- The default statistics that Proc Freq for one variable produce ?
- Freq, Percent, Cummulative Freq, Means
- Freq, N, Cummulative Freq, Means
- Freq, Percent, Cummulative Freq, Cummulative Percent
- Freq, Percent, means,N
- Difference between Proc Means & Proc Summary .
- Give example of Global Functions in SAS?
- When PDV Executed in compilation phase then what does the crawler first check ?
- Syntax
- Format
- Give example of Execution types of Error.?
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.