Help using Base SAS procedures

Help identifying forum posts

Reply
PROC Star
Posts: 7,363

Help identifying forum posts

I'm currently working on a project where everyone's expertise would be of enormous help.

To date, together, we've contributed more than 80,000 posts to the forum.  I am currently mining those posts to come up with a framework that, hopefully, will make it easier for everyone to tap those posts in order to quickly find the answers to their questions if those questions have already been answered on the forum.

That is where you come in.

Please send me as many examples as you can.  For each example, I need a statement of the question that was addressed, and links to posts that provided good answers to the question.

You can either post them as replies to this question, or send them to me, directly, at art297@rogers.com.

Thanks in advance,

Art

PROC Star
Posts: 7,363

Re: Help identifying forum posts

Other than a response from LinLin, I haven't received ANY other responses.  However, I just discovered that art297@rogers.com was blocking most email addresses.  I think the problem has been resoved but, just to be sure, please send your links to atabachneck@gmail.com

TIA,

Art

Super User
Posts: 9,681

Re: Help identifying forum posts

Hi. Arthur.T

I think you can use a software like Offline Explorer to download a entire forum, and then use filename + url to extract the information you want. But anyway, I have no time to do such a job yet.

Good Luck.

Ksharp

PROC Star
Posts: 7,363

Re: Help identifying forum posts

: This one can't be done automatically without adding bias to the task.  TextMiner's algorithm can statistically identify clusters of documents by itself, but the clustering can be enhanced with models that can be obtained from Content Categorization Studio.  Those models, in turn, are developed by stipulating a category (i.e., a question like "how can I obtain the previous and next record") and running the program using up to 20 documents/posts/blog entries that experts have identified as representing a correct answer to the question.

For this purpose, all SAS users are experts

What I'm looking for from SAS users, is simply a question and a link to a post/web page/blog entry/paper that provides a correct answer to the question.  Obviously, the less noise included in the link the better (e.g., the full SAS reference manual would NOT be as good of a source as a post that specifically provides a direct answer to the question).

So, what I'm looking from experts like you, a list of questions (one or more) and, for each question, a link that provides an answer to the question.

Super User
Posts: 9,681

Re: Help identifying forum posts

Oh. That is not a good job.

Not fun . Sorry!

Super Contributor
Posts: 338

Re: Help identifying forum posts

Hi Art,

I am repeating here what I have posted in EG forum in response to your querry regarding the "SAS Posts Mining Project".

Please find some inputs from me. These are some of the examples that I have enormously benefitted from this forum.

Thank you

Mirisage

Note: When you go to the real posting, you might see the phrase “this question not answered” but it has been answered.

Question that was addressed

Link to post that provided good answers

1

Can we convert numeric variable into a character var in the sql extraction process ?

https://communities.sas.com/message/134443#134443

2

Can we find the next value of a longitudinal dataset is different from the previous value?

https://communities.sas.com/message/136159#136159

3

How to change the datetime format to date9. in a SAS data set  imported from MS Excel?

https://communities.sas.com/message/133170#133170

4

How to identify incomplete rows and when incompleteness occurred in a dataset?

https://communities.sas.com/message/130409#130409

5

Proc tabulate problem?

https://communities.sas.com/message/139453#139453

6

Why frequency bands jump here and there?

https://communities.sas.com/message/131821#131821

7

Why I cannot export this sas data file to Excel (ver 2003)

https://communities.sas.com/message/136864#136864

8

How to quickly identify variables that distinguish records uniquely

https://communities.sas.com/message/127033#127033

9

An Index variable problem?

https://communities.sas.com/message/138337#138337

10

call symput problem

https://communities.sas.com/message/134725#134725

11

Conditional processing of a longitudinal dataset

https://communities.sas.com/message/140824#140824

12

Controlling the order of column & row titles in proc format?

https://communities.sas.com/message/140853#140853

13

Do “subsetting if” and “where” clauses do the same thing?

https://communities.sas.com/message/135007#135007

14

How come SAS Accepts Sum = Sum (Sum, Age) ; ?

https://communities.sas.com/message/141026#141026

15

How could I identify and remove accounts whose arrears bands remain as NPNA?

https://communities.sas.com/message/142840#142840

16

How to categorize income zero as 0

https://communities.sas.com/message/131838#131838

17

How to chop a long Excel cell string

https://communities.sas.com/message/129263#129263

18

How to merge two tables while giving variable values

https://communities.sas.com/message/133652#133652

19

How to merge two tables while giving variable values_II

https://communities.sas.com/message/138335#138335

20

How to monitor the succession of observations in a longitudanal series?

https://communities.sas.com/message/128272#128272

21

How to select last n rows of input records using SQL?

https://communities.sas.com/message/134930#134930

22

How to separate subjects with multiple occurrences that satisfy a certain condition?

https://communities.sas.com/message/138346#138346

23

How to subset a dataset when multiple records exist per subject

https://communities.sas.com/message/129451#129451

24

Is there any method to control decimals and introduce 1000 separators in “proc summary output” ?

https://communities.sas.com/message/136818#136818

25

Ordering the values in a cross tab output?

https://communities.sas.com/message/144349#144349

26

Longitudinal data question using proc SQL

https://communities.sas.com/message/129906#129906

27

How to merge two tables while giving variable values_II

https://communities.sas.com/message/138335#138335

28

Why this hash code works for a single bank but not for 2 banks ?

https://communities.sas.com/message/136070#136070

29

How to change the datetime format to date9. in a SAS data set  imported from MS Excel?

https://communities.sas.com/message/133170#133170

30

How to get rid of these warnings in concatenation!

https://communities.sas.com/message/137048#137048

31

How to use diff function for character variables ?

https://communities.sas.com/message/134891#134891

32

How to identify incomplete rows and when incompleteness occurred in a dataset?

https://communities.sas.com/message/130474#130474

33

Ordering the values in a cross tab output-data set is attached

https://communities.sas.com/message/144089#144089

34

Why cannot I control row title headings of this table?

https://communities.sas.com/message/139741#139741

35

Help to convert this hard coding to a macro

https://communities.sas.com/message/139743#139743

36

How to read a clue less text file into SAS

https://communities.sas.com/message/126893#126893

37

Reading an Excel file without using menu-driven "File....Import Data"?

https://communities.sas.com/message/134779#134779

38

Removing "direct jumping" customers in a time series?

https://communities.sas.com/message/131143#131143

39

Can we use proc univariate for getting a clue on group cut off lines

https://communities.sas.com/message/131946#131946

40

Why cannot I get distinct number of subjects with this code?

https://communities.sas.com/message/140396#140396

41

Why cannot I merge these two tables?

https://communities.sas.com/message/138334#138334

42

Why cannot read this file?

https://communities.sas.com/message/130199#130199

43

Why duplicate records vary depending on “first.variable”?

https://communities.sas.com/message/135584#135584

44

Why this date variables are not converted into date9. format using datepart function

https://communities.sas.com/message/142253#142253

45

How to identify the “worst ever” delinquency band each customer ever fallen?

https://communities.sas.com/message/130476#130476

PROC Star
Posts: 7,363

Re: Help identifying forum posts

: Very much appreciated!  If everyone provides the same kind of feedback as you did, my project will be a piece of cake.

Can you still identify the correct answer for #8 or at least let me know which one you chose?

Regardless, best wishes from me and mine, to you and yours, for a very Happy New Year.

Super Contributor
Posts: 338

Re: Help identifying forum posts

Tom's second answer posted on May 17, 2012 12:25 PM is the one which I choose for #8.

Thanks

Mirisage

PROC Star
Posts: 7,363

Re: Help identifying forum posts

Very much appreciated!  Of course, I can't give credits for correct and helpful responses to this thread, but the responses are greatly appreciated indeed.

Ask a Question
Discussion stats
  • 8 replies
  • 364 views
  • 0 likes
  • 3 in conversation