BookmarkSubscribeRSS Feed
nayab_shaik
Calcite | Level 5

 

Hi Team,

 

data ds1;
infile datalines;
input id age;
cards;
101 23
102 56
103 45
104 25
105 21
106 47
;
run;

how to find out 101 and 102 by using monotonic by using proc sql

 

Advance Thanks

 

2 REPLIES 2
Kurt_Bremser
Super User

You seem to suffer from a severe reading issue. Or you don't give a ******* **** about our advice.

 

PLEASE USE A DESCRIPTIVE SUBJECT!

 

You have been asked several times now.

ballardw
Super User

@nayab_shaik wrote:

 

Hi Team,

 

data ds1;
infile datalines;
input id age;
cards;
101 23
102 56
103 45
104 25
105 21
106 47
;
run;

how to find out 101 and 102 by using monotonic by using proc sql

 

Advance Thanks

 


Find out what about 101 and 102? A display of the expected result might help here.

 

Why is the use of monotonic, an undocumented feature subject to change, required?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 2 replies
  • 331 views
  • 2 likes
  • 3 in conversation