About may0423

may0423 · ‎04-17-2017

Thank you so much @ballardw!! I will play around with your codes.

may0423 · ‎04-12-2017

Hi @ballardw, Thank you very much for the details. But I don't quite understand the first question. Would you please give me more details of the statement? The related variables in question one is phonenum, address, email and comments. Thank you again!

may0423 · ‎04-12-2017

Hello everyone, I am learning how to get and organize some online information by using SAS macro, and need some help. Thank you very much in advance. Question 1: How to generate links which include two parts (1) & (2)? In part (2), "???" refers to more than 10,000 usernames saved in another other dataset named work. reviewers. The "..." is codes for grabing data wanted and has been tested for grabing information in individual page already (so I omitted it here). The ideal outcome is that SAS goes into the profile of each reviewer's page and combine their information in one file. I have no idea how to incorporate work. reviewers into this macro and make it work...... (1) %let urlbegin=https://www.websites.com/name=; (2) %let urlend=???; %let savename= test; %macro reviewers(firstcounter,pages,site,reviewers,run); %let counter=&firstcounter; %do %until (&counter>&pages); filename indata url "&urlbegin&counter&urlend"; ...... %let counter=%eval(&counter+1); %end; %mend reviewers; %allbags(1,1,reviews,test,1to1); Question 2: How to sum up records? Suppose dataset work.fees contains several records of the same reviewer regarding the membership fees he/she paid in the past 5 years, how could I create a file which just has the name of the reviewer and the total amount they paid? Some reviewers are new, so they may have only one record; while some are senior and have more than one records......

may0423 · ‎01-04-2017

@Reeza your code worked! I did something wrong when amending. thank you a lot!!

may0423 · ‎01-04-2017

@Reeza I amended your code a little bit, but it still didn't add up at the last record. Actually, what doesn't " " mean in your code value=catx(" ", value, x)? I might do something wrong to this part..... Thank you.

may0423 · ‎01-04-2017

Hi @Reeza, Thank you for the code. My original source is from a website (actually it could be from any website as it is just for practice). I saved the records in a dataset which have 8k records, then started statements. As for the Junior Member thing, it could sometimes be Senior Member or something else member. I am not sure if the x= in your code would work as I could not go through 8k records to specified the type of members. Please advise.

may0423 · ‎01-04-2017

Question 1 & 3 were solved (see code below). The code works well for information in only one observation. If information is across two observations, I still don't know how to retain them into one observation with basic statements, and the records afterwards could not be correctly matched in the output anymore.....(I'm thinking about using || to connect them, but no idea yet.....) e.g. Junior Member is wanted in one cell under usertitle column and next to Member like the photo shown: Code of question 1&3: Data test; Set work. test0; retain titlecheck tmpusertitle; if find(record, 'usertitle">') then titlecheck=1; if find(record, '') then titlecheck=0; if titlecheck=1 then user_title=record; if _n_=1 then do; ...... (omit some steps of other variables here); tmpusertitle=user_title; end; ...... (omit some steps of other variables here); if user_title ne "" then tmpusertitle=user_title; if post_id ne "" then do; user_title=tmpusertitle; end;

may0423 · ‎01-04-2017

Thank you everybody. @ballardw. The Errors were gone. The questions are: (1) the is not wanted, how could I get rid of it when the information in tmptitle is transfered to user_title? (2) what if the information wanted across two observations, e.g. retain junior (next row) member? (3) how to flag NA in photo 2 situation? the information between and was not even flagged as 1. @Patrick mentioned Perl Regular Expressions that is very worthwhile learning, but it seems too advanced for me at this point. @Reeza I pasted the unfinished code after the photos. Thank you all again! Data test; Set work. test0; Retain user_title tmp; if find (record, 'usertitle">') then tmp=1; if find (record, '') then tmp=0; if tmp=1 then do; tmptitle=record; end; if _n_=1 then user_title=tmptitle; else user_title=user_title||tmptitle; Run;

may0423 · ‎01-04-2017

@Patrick yes. Inspired by your code, I kept practicing and changing, and now codes are getting weirder...... 8 Data test; 9 Set work. Posts; 10 Retain user_title 0; 11 If find(record,'usertitle">') then usertitle=1; 12 else if find(record,'') then usertitle=0; Here are errors that I could not get rid of: ERROR 386-185: Expecting an arithmetic expression. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored." Actually why sometimes there is a 0 in the retain statement and sometimes not? Those errors pointed to the ' in find statement.....

may0423 · ‎01-04-2017

Hi all, I am learning how to use the retain statement. I got confused when I tried to aggregate strings across observations by marking = 1 and =0. Here is the record and the intended results (User_Name). Record User_Name </ul> </div>. ABC ABCDEF DEF Please help. Thank you.

may0423 · ‎12-29-2016

Thank you @Patrick, the retain statement works!

may0423 · ‎12-27-2016

Hi all, I am trying to get some replied contents from a website. Below is my code. However, it give me only the first row, no matter how many rows between <blockquote class="postcontent restore "> and </blockquote> in the contents . Code: data testpostcontents; filename indata url 'http://forums.vwvortex.com/showthread.php?7286873-To-our-readers' lrecl=10000; infile indata length=len; input record $varying10000. len; input @ '<blockquote class="postcontent restore "> ' / _line_ :&$10000. ; run; One example of the replied contents: <blockquote class="postcontent restore "> Definitely a big part of many enthusiast's lives. I try to explain the bond I have made with people all across the world, to my wife and she just doesn't get it. To the new owners of VW Vortex - Good luck! Don't mind the CEL. It will always be there. Also... Ban Jett! To Jamie and George - Best of luck in your future endeavors. Family coming first is the best decision any man can make. Congrats guys! </blockquote>

may0423 · ‎12-27-2016

Hi @mnjtrana, Thank you very much for the code!

may0423 · ‎12-27-2016

Hi @Patrick, I am very new to SAS. Thank you for the notes! It's getting interesting

may0423 · ‎12-27-2016

Hi @Kurt_Bremser, @Shmuel's code works! I might type in something wrong last night while adjusting the code........ Thank you both 🙂

Online Status	Offline
Date Last Visited	‎04-18-2017 11:59 AM

Re: How to generate links by refering information from other datasets

Re: How to generate links by refering information from other datasets

How to generate links by refering information from other datasets

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Use retain to aggregate strings across observations

Re: How to generate links by refering information from other datasets

Re: Use retain to aggregate strings across observations

Re: Extract rows from website

Re: Extract information between strings

Re: Extract information between strings

Re: Extract information between strings

Re: How to generate links by refering information from other datasets

Re: How to generate links by refering information from other datasets

How to generate links by refering information from other datasets

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Re: Use retain to aggregate strings across observations

Use retain to aggregate strings across observations

Re: Extract rows from website

Extract rows from website

Re: Extract information between strings

Re: Extract information between strings

Re: Extract information between strings