Proc Sql; Select * from <dataset name> where _n

There are 200 observations in a dataset, i want to pull out
the observation no's 100, 150,180,190 by using Proc SQL? How
you can get it?

Question Posted / vipin choudhary

Answer Posted / vipin choudhary

Proc Sql;
Select * from <dataset name>
where _n_ in (100,150,180,190);
quit;

Is This Answer Correct ?

12 Yes

29 No

Please Help Members By Posting Answers For Below Questions

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1219

Describe the ways in which you can create macro variables?

1249

what is data access? : Sas-di

1178

Give an example where SAS fails to convert character value to numeric value automatically?

1132

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3632

Describe the function and untility of the most difficult SAS macro that you have written.

2167

do you need to know if there are any missing values? : Sas programming

1121

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1180

Mention few capabilities of sas framework.

1237

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1309

What do the put and input function do?

1108

What is program data vector (pdv)?

1387

For what purpose would you use the RETAIN statement?

1580

What is the basic syntax style in SAS?

1226

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

1331