cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
manjo
‎09-01-2015
  • 7 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: help

by Calcite | Level 5 in SAS Programming
‎04-13-2014 05:45 PM
‎04-13-2014 05:45 PM
Thank you ... View more

Re: help

by Calcite | Level 5 in SAS Programming
‎04-13-2014 11:33 AM
‎04-13-2014 11:33 AM
If i run that above codes the output is this eid     name     age     order_nu 100     ppp     26     112 102     qqw     31     119 but instead of that i need an out put of eid name age order_nu 100 ppp 26 112 100 ppp 26 113 100 ppp 25 116 102 qqw 31 119 102 qqq 32 120 102 xxx 51 121 like this all the records expect the person who made order only once ... View more

Re: help

by Calcite | Level 5 in SAS Programming
‎04-13-2014 10:11 AM
‎04-13-2014 10:11 AM
Thank you Ksharp If in case i want to create a table containing only the id and name of any people and THEIR ORDERS who have made two or more orders means how can i alter this? ... View more

Re: help

by Calcite | Level 5 in SAS Programming
‎04-13-2014 03:47 AM
‎04-13-2014 03:47 AM
*order table; data abc1; input eid name$ age order_nu; cards; 100 ppp 26 112 100 ppp 26 113 100 ppp 25 116 101 qqq 32 114 102 qqw 31 119 102 qqq 32 120 104 yyy 53 121 102 xxx 51 121 ; *person table; data abc; input eid name$ age; cards; 100 ppp 26 101 qqq 32 102 qqw 31 104 yyy 53 ; ... View more

help

by Calcite | Level 5 in SAS Programming
‎04-12-2014 02:24 PM
‎04-12-2014 02:24 PM
Hi Thanks all in advance for your answers My Question I have 2 tables, a person table containing 1 record per person, and an orders table with many orders per person, with a key on person_id. Using proc sql, how would you create a table containing only the id and name of any people that have made two or more orders? ... View more

Re: Help

by Calcite | Level 5 in SAS Programming
‎04-12-2014 02:17 PM
‎04-12-2014 02:17 PM
Thank you PGStats ... View more

Help

by Calcite | Level 5 in SAS Programming
‎04-12-2014 01:00 PM
‎04-12-2014 01:00 PM
Hi all; Thanks in advance for your answers My question is how to choose the rows where eid occurring more than once? data abc; input eid name$ age; cards; 100 ppp 26 100 ppp 26 100 ppp 25 101 qqq 32 102 qqw 31 102 qqq 32 104 yyy 53 102 xxx 51 ; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
Quick links