topic Help identifying forum posts in SAS Enterprise Guide

Help identifying forum posts

art297 — Tue, 20 Nov 2012 15:36:58 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 19:59:39 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

Mirisage — Mon, 24 Dec 2012 18:04:13 GMT

Hi Art,

Sorry I could not respond to this as I was v. busy.

I am a SAS Data Analyst who has been immensely benefitted from this forum.

Could you please let me know if this kind of table would work for your project needs?

If so, I can go ahead and fill this table up.

Please let me know.

Thanks

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

Re: Help identifying forum posts

art297 — Mon, 24 Dec 2012 18:17:55 GMT

: Exactly what I am looking for and very much appreciated!

Everyone else: Please send me as many links, like Mirisage did, as you can. The quality of the resulting product, which we intend to make available (for free) to everyone once completed, will be dependent upon the number and scope of the links received.

Everyone: Best wishes for the holidays from me and mine to you and yours!

Re: Help identifying forum posts

Mirisage — Sun, 30 Dec 2012 00:53:04 GMT

Hi Art,

Please find some inputs towards your project which will eventually benefit us.

BTW, have you also posted this same query in “SAS Procedures” forum which is the one I frequently use.

Wish you a Happy New Year!

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

topic Help identifying forum posts in SAS Enterprise Guide

Help identifying forum posts

Re: Help identifying forum posts

Re: Help identifying forum posts

Question that was addressed

1

2

3

4

5

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