SAS Interview Questions
Questions Answers Views Company eMail

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

Accenture,

3 10023

in which companies SAS openings are there? List of companies using SAS technology.

MIR-IFCR, TCS,

14 51238

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 17837

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.

1765

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.

1 3999

hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process

HSBC,

2 4739

How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 26673

What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 5435

libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 7598

data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks

3 6307

I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 6875

I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 7197

If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.

1 3901

Which is the best training institute for SAS in hyderabad.

Stansys Software Solutions,

112 200467

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 ;

1 3997


Post New SAS Questions

Un-Answered Questions { SAS }

Explain the use of proc print and proc contents?

532


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1642


What is the difference between nodupkey and nodup options?

572


What are the difference between the sas data step and sas procs?

582


What is the purpose of trailing @ and @@? How do you use them?

590






Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

671


Explain what Proc glm does?

609


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

580


Explain what is the use of proc gplot?

672


Explain the main difference between the sas procedures and functions? : Sas-administrator

514


explain about various caches available in data integrator? : Sas-di

553


how would you determine the number of missing or nonmissing values in computations? : Sas programming

623


what is the difference between nodup and nodupkey options? : Sas programming

595


what is proc Index? and what is proc document?

1972


Where do you use proc means over proc freq?

542