Answer / sheetal

using noprint

Answer / guest

WE CAN USE WHERE CLAUSE TO RESTRICT THE OUT PUT.

Answer / dupe

Various datestep options, can be use to restrict number of
observations
obs=;
firstobs=;
point=obsnum

Answer / shirisha

using ods

Answer / selvi

by if exp=codn; - restrict the output to be produced

Answer / harish

with out proc print statement we can block the out put.

Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?

2 Answers   Oracle,

Do you know the features of sas?

0 Answers  

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

1 Answers   Accenture,

Explain why double trailing @@ is used in input statement?

0 Answers  

Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

6 Answers   HSBC,

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

0 Answers  

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 Answers  

how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,

Differences between where and if statement?

0 Answers  

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

0 Answers   Wipro,

Name statements that are recognized at compile time only?

3 Answers   Accenture,

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers