BookmarkSubscribeRSS Feed
art297
Opal | Level 21

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

4 REPLIES 4
art297
Opal | Level 21

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

Mirisage
Obsidian | Level 7

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

art297
Opal | Level 21

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

Mirisage
Obsidian | Level 7

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1082 views
  • 0 likes
  • 2 in conversation