About AncaTilea

AncaTilea · ‎10-23-2013

So IML would probably be desired for this. Otherwise, you will need some sort of array to pass through and somehow tell SAS you want the column+1.... Yeah, I don't know. Anca.

AncaTilea · ‎10-23-2013

Thank you! I've never used RSS Feed, but via my email I seem to be able to configure something or other, and now I have a list of "unanswered" topics in my email. Which is ok. But sorting the forum would have been preferred. Thank you! Anca.

AncaTilea · ‎10-23-2013

Hi. Is there a way to display at the top the questions posted that have not received any (zero) answers? I get notifications for certain postings or topics I follow/am interested in, but otherwise, as my routine in the morning is to check the forum...I end up having to go page by page to find the "0" answers ones. Any suggestions? Thank you. Anca.

AncaTilea · ‎10-23-2013

So you coukd do this: data have; input var1 var2 var3 var4 var5; datalines; 1 . . . . . 2 . . . . . 3. . . . . . 4 . . . . . 5 ; data want; set have; var_want = max(of var1--var5); run; proc transpose data = want out = want_tran;var var_want;run; But this is assuming that you have missing on the non-diagonal values.

AncaTilea · ‎10-23-2013

Do you mean data that looks like this: 1 . . . . . 2 . . . . . 3. . . . . . 4 . . . . . 5 To look like this: 1 2 3 4 5 ?

AncaTilea · ‎10-21-2013

Hi SasPro. I wrote a simple code, but the results are slightly different. *sort original data by var1 and var2; proc sort data = have;by var1 var2;run; *create a temp file that flags the observations that have the "19" in your var2; data temp(keep = var1 var2 rename = var2 = required); set have; by var1 var2; flag = ((scan(left(var2),-1,"x")) = "19" ); if flag = 1; if first.var2; run; *merge it back together; data want; merge have temp; by var1; run; As you can see, my final data set doesn't copy var2 info for the last record"A0012E3CA47467275AD0EC12FFFFFFFF" into the second to last record "A0012E3CA47467275AD0EC12FFFFFFFF" (Not sure how you decide that the info from the last record should be populated into the second to last?) Good luck. Anca.

AncaTilea · ‎10-18-2013

Thank you again! Unrelated to this topic, I would like to THANK YOU for your (inspiring) presentation at MWSUG at the Expert Panel discussion (the bank robberies problem), I was very much looking forward to learn from the experts how did they tackle the problem, and with the exception of Art C, I was truly disappointed in the solution given: this data is too dirty! And you made all that go away by showing the most elegant (possible) solution! So I thank you! Anca.

AncaTilea · ‎10-17-2013

Very nice, This code I can understand. I would give you Correct Answer. Anca.

AncaTilea · ‎10-17-2013

How elegant! Thank you! If it's not too much trouble, would you mind describing the _INFILE_ line in the code...? Anca.

AncaTilea · ‎10-17-2013

Lekha, You have modified the way the data was given. I needed for that specific data records,you aligned the age and score so that name takes up to 8 characters. Thanks by had the solution I was hoping for. Cheers! Anca.

AncaTilea · ‎10-17-2013

Hi. How can I modify this snippet of code such that it reads the name as "John Doe"? data foo; input name $ age score; datalines; John Doe 23 25 Mike 23 26 Meow 1 4 ; Thanks. Anca.

AncaTilea · ‎10-14-2013

However, my senior supervisor told me there is no real need for me to combine these data sets, and may just use them individually. So, I thank you. Sincerely. Anca.

AncaTilea · ‎10-14-2013

Thank you, MIT. I will certainly try your code. Thank you. Anca.

AncaTilea · ‎10-14-2013

It varies, from ID to ID, as this is a followup over ~10 years...and the visits could be weekly,monthly...anyly.

AncaTilea · ‎10-14-2013

Hi, I have two data sources (one and two), Simple and straight forward/; id,year,month and day of a given visit. What I would like, is to merge the files by id AND match the dates (month,day,year) as close as possible, If it's a perfect match, that's easy. If it's within few days, I want to keep the closest date. SO if there are dates 2 and three days apart from another date I want to keep the one record that is 2 days apart. At the end, I want everything from both sources. I tried PROC SQL, full join,create a diff_Date, then using a having clause, I tried data step merges... If you think you can help, I'd appreciate it, Thank you!!!!! data one; input id day month year; datalines; 1 2 12 2003 1 18 12 2003 1 14 4 2004 1 7 5 2004 1 26 5 2004 1 3 6 2004 1 18 6 2004 1 23 6 2004 1 9 7 2004 1 23 7 2004 1 18 8 2004 1 20 8 2004 1 25 8 2004 1 20 9 2004 1 20 10 2004 1 29 10 2004 1 3 11 2004 1 28 11 2004 1 28 11 2004 1 11 12 2004 1 11 12 2004 1 24 12 2004 1 19 1 2005 1 9 2 2005 1 23 2 2005 1 5 5 2005 1 17 5 2005 1 18 5 2005 1 20 6 2005 1 7 7 2005 1 13 7 2005 1 16 8 2005 1 1 9 2005 1 1 9 2005 1 12 9 2005 1 16 9 2005 1 12 10 2005 1 9 11 2005 1 30 11 2005 1 30 11 2005 ; data two; input id day month year; datalines; 1 14 4 2004 1 7 5 2004 1 21 5 2004 1 18 6 2004 1 9 7 2004 1 23 7 2004 1 17 8 2004 1 18 10 2004 1 28 11 2004 1 29 11 2004 1 30 11 2004 1 1 12 2004 1 2 12 2004 1 3 12 2004 1 4 12 2004 1 12 12 2004 1 13 12 2004 1 14 12 2004 1 15 12 2004 ; data want; infile datalines missover; input id day month year day_2 month_2 year_2; datalines; 1 2 12 2003 1 18 12 2003 1 14 4 2004 14 4 2004 1 7 5 2004 7 5 2004 1 26 5 2004 21 5 2004 1 3 6 2004 1 18 6 2004 18 6 2004 1 23 6 2004 1 9 7 2004 9 7 2004 1 23 7 2004 23 7 2004 1 18 8 2004 17 8 2004 1 20 8 2004 1 25 8 2004 1 20 9 2004 1 20 10 2004 18 10 2004 1 29 10 2004 1 3 11 2004 1 28 11 2004 28 11 2004 1 28 11 2004 29 11 2004 1 30 11 2004 1 1 12 2004 1 2 12 2004 1 3 12 2004 1 4 12 2004 1 11 12 2004 12 12 2004 1 11 12 2004 13 12 2004 1 14 12 2004 1 15 12 2004 1 24 12 2004 1 19 1 2005 1 9 2 2005 1 23 2 2005 1 5 5 2005 1 17 5 2005 1 18 5 2005 1 20 6 2005 1 7 7 2005 1 13 7 2005 1 16 8 2005 1 1 9 2005 1 1 9 2005 1 12 9 2005 1 16 9 2005 1 12 10 2005 1 9 11 2005 1 30 11 2005 1 30 11 2005 ;

Online Status	Offline
Date Last Visited	‎11-18-2024 07:33 PM

Re: Crosstab Dates

Re: why repeated observations??

Re: why repeated observations??

Re: why repeated observations??

Re: Add rivers to US map

Re: Add rivers to US map

Add rivers to US map

Re: # of months between two date vars

Re: ODS Tagsets ExcelXP Creating Multiple Workbooks

Re: Histogram with different fill colors beyond a specified point

Re: Add rivers to US map

Re: Spliting a string into variable

Re: Spliting a string into variable

Re: Histogram with different fill colors beyond a specified point

Re: Anagrams Within Words

Re: Default "view" preferences at startup of SAS

Re: Turn off title in BoxPlots

Re: How to use "labels" (Excel column headers) instead of SAS "names" ...

Re: Residuals in logistic regression

Re: Adding a Variance column in a table

Re: Diagonal as horizontal

Re: Sort through the Forum questions

Sort through the Forum questions

Re: Diagonal as horizontal

Re: Diagonal as horizontal

Re: How to copy cell value to other cell within the group

Re: Read in data

Re: Read in data

Re: Read in data

Re: Read in data

Read in data

Re: Merge many to many, in a way

Re: Merge many to many, in a way

Re: Merge many to many, in a way

Merge many to many, in a way