SAS Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SAS Interview Questions

Questions Answers Views Company eMail

what is intially documentation in sas?

Accenture,

1 5041

what is option year cuttoff in sas

L&T,

2 7779

what is treatment emergent events and treatment emregent adverse event

2396

what is lifetest

Cognizant,

1 5144

How to read the file names of a text files from a shared drive using SAS?

HSBC, WNS,

1 5254

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?

Accenture,

6 11244

what is cummaltive frequency,and varience in proc unviarte

L&T,

1 5395

differnce between 8.2 and 9.1.3

1 4839

what the use of proc glm

Accenture, C Marc,

1 6896

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

Cap Gemini, L&T,

2 8010

WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?

1 4626

in data set200 observation how to take 110,150,170 using sql procedure?

Accenture,

7 12328

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

SAS,

5444

Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?

American Express, Barclays,

5 17351

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 8429

Post New SAS Questions

Un-Answered Questions { SAS }

What is the difference between match merge and one to one merge?

1244

what is study design in while working with SAS? what are screening variables in SAS?

2238

Mention how to limit decimal places for the variable using proc means?

1108

what is sas and what are the functions? : Sas-administrator

982

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

2752

What do the PUT and INPUT functions do?

1334

Explain proc univariate?

1027

what are some differences between proc summary and proc means? : Sas programming

1119

What are the automatic variables for macro? : sas-macro

1244

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

1067

explain about sas business intelligence? : Sas-bi

1136

Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.

2267

What are symget and symput? : sas-macro

1308

What is the maximum and minimum length of macro variable

1246

For clinical entire study how many tables will create approx?

1965

For More Un-Answered { SAS } Questions Click Here