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: 
Right
‎09-01-2015
  • 9 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Freq cross tabulation

by Calcite | Level 5 in SAS Procedures
‎02-10-2012 11:14 AM
‎02-10-2012 11:14 AM
This is helpful! Looks like  do-loop can also do the job of a DOW-loop, but with more programming and accumulation variables. ... View more

SAS Freq cross tabulation

by Calcite | Level 5 in SAS Procedures
‎02-09-2012 03:19 PM
‎02-09-2012 03:19 PM
Hi Linlin, Thanks again for taking time writing me the neat sql code! ... View more

SAS Freq cross tabulation

by Calcite | Level 5 in SAS Procedures
‎02-09-2012 03:16 PM
‎02-09-2012 03:16 PM
Hi Haikuo, By reading your and other's replies, I think I've just learned how to do loops in SAS. Thanks! ... View more

SAS Freq cross tabulation

by Calcite | Level 5 in SAS Procedures
‎02-09-2012 03:07 PM
‎02-09-2012 03:07 PM
Hi art297, Thank you for the quick reply! It works. ... View more

Re: SAS Freq cross tabulation

by Calcite | Level 5 in SAS Procedures
‎02-09-2012 02:50 PM
‎02-09-2012 02:50 PM
Hi art297, Thanks for the reminder. Suppose this is the dataset. ID Date Price Quantity 1 20001001 1.2 5.6 1 20001002 1.3 8.9 1 20001002 1.3 9.9 2 20101110 2.9 3.3 2 20101111 1.5 2.1 3 19990314 1.6 0.9 3 19990314 1.6 0.8 3 19990315 1.7 0.7 And below is the dataset I want to construct, where I count the duplicated rows (in the 1st two columns): ID Date Price Quantity Frequency 1 20001001 1.2 5.6 1 1 20001002 1.3 8.9 2 1 20001002 1.3 9.9 2 2 20101110 2.9 3.3 1 2 20101111 1.5 2.1 1 3 19990314 1.6 0.9 2 3 19990314 1.6 0.8 2 3 19990315 1.7 0.7 1 Any suggestions? ... View more

SAS Freq cross tabulation

by Calcite | Level 5 in SAS Procedures
‎02-09-2012 02:22 PM
‎02-09-2012 02:22 PM
Hi All, Does any of you know how to store the counts from SAS/Freq cross tabulation in a column and add this column to the original data? I have several duplicated rows in the data, but these rows only duplicate in the first two columns. I need to save the counts in the cross tabulation for the first two columns and add it as a new column for the entire dataset. Thanks! ... View more

SAS SQL data deletion problem

by Calcite | Level 5 in SAS Procedures
‎02-03-2012 07:56 PM
‎02-03-2012 07:56 PM
Thanks, Haikuo! The second method will take me some time to understand, but the first one looks really neat:) ... View more

SAS SQL data deletion problem

by Calcite | Level 5 in SAS Procedures
‎02-02-2012 10:05 PM
‎02-02-2012 10:05 PM
Linlin, Your answer rocks! Thanks:) ... View more

SAS SQL data deletion problem

by Calcite | Level 5 in SAS Procedures
‎02-02-2012 09:27 PM
‎02-02-2012 09:27 PM
Hi All, I am a newbie and have this question in using SAS/SQL: I have two Tables A and B, and they have a common column named ID. Table B has a single column with distinct elements. The ID column inTable A have some repeated elements, some of which also appear in Table B. I want to delete all rows in Table A where the elements in the ID column appear in the ID column of Table B. Any suggestions?  SAS/DATA method will also be helpful. Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links