SAS Interview Questions
Questions Answers Views Company eMail

how to delete the duplicates by using proc sql?

Genpact,

3 7590

what is the difference between proc means and proc summary?

Accenture,

2 6605

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

2 4465

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 10406

/* 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 4188

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

Satyam,

2 4548

how do u validate the program which u have written.

TCS,

1 5009

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,

1673

what is AE onset date and what is RDS?

Accenture,

4 8600

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

Cognizant,

4 6897

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

2275

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 4417

what is washout period?

Cognizant,

3 21757

What is the differnce between SDTM 3.1.2 to 3.1.1 version

Wipro,

4589

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 6306


Post New SAS Questions

Un-Answered Questions { SAS }

Approximately what date is represented by the SAS date value of 730?

726


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

1568


How would you invoke a macro? : sas-macro

536


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

635


Are you involved in writing the inferential analysis plan? Tables specfications?

1726






How to limit decimal places for variable using proc means?

573


What commands are used in the case of including or excluding any specific variables in the data set?

579


I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1308


What are SAS/ACCESS and SAS/CONNECT?

618


What is PROC in SAS?

589


How do you add a number to a macro variable? : sas-macro

535


What is the difference between %local and %global? : sas-macro

652


how does sas handle missing values in assignment statements? : Sas programming

558


What are common programming errors committed in sas

655


how to remove duplicates using proc sql?

620