Answer / bharath

data abc1;
set qqq end=a;
if _n_=1 or a=1;
proc print data=abc1;
run;

Answer / vishal

proc sort data=qqq;
by name;
run;

data f;
set qqq;
by name;
if first.name=0;
run;

Answer / alok karan

data qq;
do i=1 to n by n-1;
set qqq point=i nobs=n ;
output;
end;
stop;
proc print data=qq;
run;

/*Above is more efficient program to know the first and last observation */

Answer / ashish

data op;
set qqq end=last;
if _n_=1 or last=1 then output;
run;

Answer / bharath

data qqq;
input name $ total;
cards;
qq 22
ww 33
qq 22
ee 44
rr 33
ww 44
;
run;


data abc;
set qqq;
if total in (22,44) and name in ('qq', 'ww');
proc print;
run;

data abc1;
set abc;
by name;
if first.name;
run;
proc print;
run;

Answer / singh.naveen409

proc sort data=qqq;
by name;
run;
options mlogic;
data www;
set qqq;
by name;
if first.name then serial=1
run;
data wwq (drop=serial);
set www;
if serial ne '1';
run;

How do i read multiple spaces in datasets?

4 Answers   Quintiles,

I have a dataset concat having variable a b & c. How to rename a b to e & f?

0 Answers  

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  

What is criteria for adverse events and treatment-emergent adverse events?

2 Answers   Accenture,

what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.

1 Answers   TCS,

How do you add a number to a macro variable?

2 Answers  

what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?

36 Answers   Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,

Define run-group processing?

0 Answers  

What data sets do you need to produce the report?

2 Answers   Novartis,

What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;

3 Answers  

why is sas considered self-documenting? : Sas programming

0 Answers  

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

5 Answers