topic Re: Help identifying forum posts in SAS Procedures

Help identifying forum posts

art297 — Tue, 20 Nov 2012 15:34:52 GMT

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

Re: Help identifying forum posts

art297 — Wed, 12 Dec 2012 20:00:04 GMT

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

Re: Help identifying forum posts

Ksharp — Thu, 13 Dec 2012 02:16:07 GMT

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

Re: Help identifying forum posts

art297 — Thu, 13 Dec 2012 03:41:46 GMT

: 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.

Re: Help identifying forum posts

Ksharp — Thu, 13 Dec 2012 05:37:58 GMT

Oh. That is not a good job.

Not fun . Sorry!

Re: Help identifying forum posts

Mirisage — Sun, 30 Dec 2012 01:03:50 GMT

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

Re: Help identifying forum posts

art297 — Sun, 30 Dec 2012 04:56:11 GMT

: 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.

Re: Help identifying forum posts

Mirisage — Sun, 30 Dec 2012 17:36:11 GMT

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

Thanks

Mirisage

Re: Help identifying forum posts

art297 — Sun, 30 Dec 2012 17:57:33 GMT

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.

topic Re: Help identifying forum posts in SAS Procedures

Help identifying forum posts

Re: Help identifying forum posts

Re: Help identifying forum posts

Re: Help identifying forum posts

Re: Help identifying forum posts

Re: Help identifying forum posts

Question that was addressed

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

Re: Help identifying forum posts

Re: Help identifying forum posts

Re: Help identifying forum posts