SAS Interview Questions
Questions Answers Views Company eMail

how to delete the duplicates by using proc sql?

Genpact,

3 7559

what is the difference between proc means and proc summary?

Accenture,

2 6580

How to get the repeated values by using sql in sas ?

2 4443

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

Quintiles,

9 10347

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

Emerio,

1 4171

what is the usage for assigning error=1 in a dataset ?

Satyam,

2 4527

how do u validate the program which u have written.

TCS,

1 4967

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

Cognizant,

1665

what is AE onset date and what is RDS?

Accenture,

4 8571

how to rearrange the data as our wish by using dataset block?

Cognizant,

4 6857

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2267

Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 4376

what is washout period?

Cognizant,

3 21724

What is the differnce between SDTM 3.1.2 to 3.1.1 version

Wipro,

4574

i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.

Cap Gemini,

2 6271


Post New SAS Questions

Un-Answered Questions { SAS }

How to create list output for cross-tabulations in proc freq?

599


What is a pdv and what are its functions?

574


How to include or exclude specific variables in a data set?

618


what are validation tools that are used in sas? : Sas-administrator

573


What do you understand by the term Normal Distribution?

544






What are the difference between sas functions and procedures?

611


Mention the category in which sas informats are placed?

603


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

513


What are symget and symput? : sas-macro

695


List down the reasons for choosing sas over other data analytics tools.

783


how would you create multiple observations from a single observation? : Sas programming

547


How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

1919


Intern stastical programmer written test

259


explain the use of % includes a statement in sas? : Sas-administrator

527


What are the uses of sas?

676