For questions i want answers please help me

For questions i want answers please help me

Post by krishn » Thu, 21 Sep 2006 21:17:44

Under What Circumstances would you code a SELECT construct
of IF statement ?

2. What Statement do you code to tell SAS that it is to write to
external file ? What statement do you code to write the record to the
file ?

3. If reading an external file to produce an external file, what
is the
shortcut to write that record without coding every single variable on
the record?

4. If you are not wanting any SAS output from a data step, how
you code the data statement to prevent SAS from producing a set ?

5. What is the one statement to set the criteria of data that can
coded in any step ?

6. Have you ever linked SAS code? If so, describe the link and any

required statements used to either process the code or the step itself

7. How would you include common or reuse code to be processed along
with your statements ?

8.When looking for data contained in a character string of 150 bytes ,
which function is the best to locate that data : SCAN , INDEX , or

9. If you have a data set that contains 100 variables , but you need
only five of those , what is the code to force SAS to use only those
variable ?

10. Code a PROC SORT on a data set containing state, District, and
Country as the primary Variables, along with several numeric variables.


11. How would you delete duplicate observations?

12. How would you delete observations with duplicate keys?

13. How would you code a merge that will keep only the observations
that have matches from both sets.

14. How would you code a merge that will write the matches of both to
one data set , the non-matches from the left most data set to a
second data set, and the non-matches of the right-most data set to a
third data set.


15. What is the Program Data Vector(PDV) ? What are its functions ?

16. Does SAS 'Translate' ( compile ) or does it 'interpret' ?
Explain .

17. At compile time when a SAS data set is read, what items are created


18. Name statements that are recognized at compile time only?

19. Identify statements whose placement in the DATA step is critical.

20. Name Statements that function at both compile and execution time.

21. Name Statements that are execution only.

22. In the flow of DATA step processing, What is the first action in a
typical DATA step ?

23. What is _N_ ?

Base SAS ::

24. What is the effect of the OPTIONS statement ERRORS=1 ?

25. What's the difference between VAR A1-A4 and VAR A1-A4 ?

26. What do the SAS log messages "numeric values have been converted
to character " mean ? What are the implications ?

27. why is a STOP statement needed for the POINT = option on a SET
statement ?

28. How do you control the number of observations and/or variables read

or written ?

29. Approximately what date is represented by the SAS date value of 730


30. How would you remove a format that has been permanently associated
with a variable ?

31. What does the RUN statement do ?

32. Why is SAS considered self-documenting ?

33. what areas of SAS are you most interested in ?

For questions i want answers please help me

Post by RolandR » Thu, 21 Sep 2006 21:20:07

t looks like you are asking people to do your assignment for you or
your sas test.

krishna wrote:


For questions i want answers please help me

Post by cymraegeri » Thu, 21 Sep 2006 21:27:04

ey ... these are some of the questions we ask when we are
interviewing SAS programmers and we can't think of anything more
interesting to talk about...

++ Guido

On 20/09/06, krishna < XXXX@XXXXX.COM > wrote:

For questions i want answers please help me

Post by gerhard.he » Thu, 21 Sep 2006 22:15:57

what do you expect us to do now? Are you really sure, that all the answers
you'll get are the RIGHT ones? E.g.
1. I use never SELECT because it has 6 chars and IF has only 2...

For sure you'll get help, if you don't find the answer for 2 or 3 questions.
But you should try to do 99% of the work for yourself. How did you get your
drivers license? Did you send your daddy or your mom?

Good luck!

On Wed, 20 Sep 2006 05:20:07 -0700, RolandRB < XXXX@XXXXX.COM > wrote:


For questions i want answers please help me

Post by gerhard.he » Thu, 21 Sep 2006 22:22:07

k, that was question 1. Now what about 2.?

On Wed, 20 Sep 2006 08:34:24 -0400, Jeo Kurian < XXXX@XXXXX.COM > wrote:


For questions i want answers please help me

Post by ajs200 » Thu, 21 Sep 2006 22:45:59

Ref earlier discussion on this topic -

and see
'The Ultimate Match Merge: Hiring the Best SAS Programmers'

For questions i want answers please help me

Post by jfh » Fri, 22 Sep 2006 07:27:52

uoting krishna < XXXX@XXXXX.COM >:

There are some bad questions here.

There's more than one way to do this.

There are at least two ways to do this.

There is no such statement.

There are at least two possible meanings to the word LINK.

Thre are at least two ways to do this.

There are additional ways to do this besides the ones listed.

"Use" is probably not the appropriate verb here.

There are at least four ways.

There are at least two ways, and may not be a good idea to delete records with
duplicates unless every variable is a key.

Sometimes it compiles, sometimes it interprets, and sometimes it does
both in a
single step.

In the data step, all of them. Perhaps the question should be "Name
that are not executed at run time."

Beside DATA, none. Of course, with some statements you might not get the
results you want they're not placed properly, but you'll get the results you
asked for.

Depends on your definition of "typical".

In PROC COMPUTAB, it's the number of the current observation within the
BY group.

Was there supposed to be a double-dash in there?

It means your code is in error and should be rewritten.

Poorly worded. It's not, necdessarily.

Lots of ways.

Remove the format from the format library, or remove the association
between the
format and the variable?

Depends on where it's located. Sometimes, nothing.

It isn't.

There are at least two common uses.

If you need to know this, find somewhere else to work.

There's no contest there.

This has been asked already.

There are at least two functions which will increment a datetime value by a
number of days.

Someone needs to write a PROC MERGE.

At least two ways to answer this ambiguous question.

This is not an either/or.

Why does the person who wrote these questions think that the # can't be used
with a data _null_?

In the very next statement. But you have to know what you're doing.

This message was sent using IMP, the Internet Messaging Program.