Assume that I have a dataset like this: data execs; input id $ firmid $ year; datalines; A001 APL 1990 A002 MSFT 1993 A002 AMZN 1994 A002 APL 1996 A003 CSCO 1994 ; run; This hypothetical table contains the first time a person has joined the firm. For example, Mr A002 has joined MSFT in 1993, and then joined AMZN in 1994 and then joined APL in 1996. Mr A003 only joined CSCO in 1994.   I want to collapse this data into person-level shape, so that each row is for a person, with multiple columns for every job experience that the person has had. data want; input id $ firmid $ year $ firmid2 $ year2 $ firmid3 $ year3; datalines; A001 APL 1990 . . . . A002 MSFT 1993 AMZN 1994 APL 1996 A003 CSCO 1994 . . . . ; run; Is there a nice way to do this procedure? I grappled with Proc Transpose but it does not seem to give me the desired output, or I cannot figure it out. Any helps?   Thanks a lot,   ... View more

# python code heret Hi All,   I have recently started to use the SAS Jupyter notebook in my university. It works generally well, but I have a problem if I want to do some downloads from rsubmit sessions.   A remote session like this works okay: %let wrds = wrds.wharton.upenn.edu 4016;options comamid = TCP remote=WRDS; signon username=.....; rsubmit; data c; set crsp.dsf; if _n_ = 2; run; endrsubmit; and I get a log with no problems: NOTE: There were 90591326 observations read from the data set CRSP.DSF. NOTE: The data set WORK.C has 1 observations and 20 variables. NOTE: DATA statement used (Total process time): real time 4.65 seconds cpu time 4.64 seconds NOTE: Remote submit to WRDS complete.   But if I want to download the file, it seems to be a problem there. The * (see picture below) never goes away, which I think it might mean that it is still working? and it gives me no log at all.   When I check the folders, there is a file created as file c, but it is empty. Is there something that I shoud do to solve the problem? does it have anything to do with Jupyter notebook, or what?   Another point: I am not sure if it matters or not, but I am running the code on a server on my university computers, not my local computer.   As always, Thanks a lot!     ... View more

Hi all,   I recently noticed that, if I want to write a do loop or do a %let statement while on server, it does not work, and it seems that SAS simply ignores the line.   * sign on WRDS server; rsubmit; %do i = 1980 %to 2000; data a_&i; set ...; run; %end; endrsubmit; log does not produce any line for that issue, it simply returns an error becasue a_i& is not resolved. The same thing happens if I want to use %let on the server. Is there a way that I can run such macro statements on the server? Or is there anything run with the code?   I am familiar with %syslput but somehow cannot figure how to use it with the %do loop.    Thanks a lot,   ... View more

Hello Everyone,    The title might not be accurate since I am not familiar with encoding, but here is my problem in simple words: I have a variable which is actually a list of names of people. Apparently, some of these names are Spanish or French, so they have characters which I belive are called "hexadecimal characters", such as  E with an accent above it, or a lowercase i with umlaut above it. ( I dont know how to type them, some examples are attached in the picture.)    I want to convert all of them into regular characters, for example, E with dots into E, etc.    I thought compress function should be the right way, so first I tried to just keep the alphabets like this:   data test2; set test; names_translate = compress(name2,'','ka'); run; It does not work unfortunately, and those charachters remain there. I played with other modifiers, such as 'c' or 'w' but those do not seem to give me what I want either. I was wondering if there is a neat method with compress function, or any other function that gives me the desired result? In the picture below I have shown basically what I have and what I want to get as output.       ... View more

Ok, I should explain the header better. Let's say I have a data set like this:   PERMNO    DATE    Y     X1     X2      X3 A                   100     xx    xx      xx      xx A                   100     xx    xx      xx      xx A                   100     xx    xx      xx      xx B                 ...... B B C C C   Basically, I want  to run multiple regression models.  For example, Y ~ x1. Y~ x2, Y~X3, ... In my real data set there are more than 10 variables.   I know that for a single model, I can run something like this: proc reg data = have out = want; by permno date; model y = x1; run; But what shoud I do if I want to do a loop through my variables, so that I get all of models, y ~ x1, y~x2, y~x3 in one table. Can it possibly done in one proc reg, or should I define multiple ones and append them together?   I appreciate any help. Thanks! ... View more