BookmarkSubscribeRSS Feed
SandeepAmte
Calcite | Level 5

Hi,

 

How to select observation between 10 to 20 using proc sql?

 

3 REPLIES 3
stat_sas
Ammonite | Level 13

Please provide a sample data set.

Jagadishkatam
Amethyst | Level 16

Please try firstobs and obs options

 

here sas applies the formula

 

(obs - firstobs) + 1 = resulting obs number

 

proc sql;
create table test as select * from sashelp.class(firstobs=10 obs=20);
quit;

Thanks,

Jag

 

 

 

Thanks,
Jag
LinusH
Tourmaline | Level 20

Even if the solution provided by https://communities.sas.com/t5/user/viewprofilepage/user-id/12151 is feasible, SQL is not by nature a row oriented language. The data step is.

Why SQL? What is the underlying requirement?

Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 457 views
  • 1 like
  • 4 in conversation