Hi CTorres, still thank you for replying because any additional knowledge is useful! There is one problem when I use the transpose: if for example I have a date appearing several times then the transpose will give me an error because it is considering as if I want to create the same dummy column several times ... View more

Hi Statistician13, thank you for your code, it combines what the two previous codes separately, namely it can both automatically create the dummy variables and it allows for the same date to be repeated. In the output I get an intercept value, and I guess that this is due to the proc logistic, but I can drop it right? ... View more

The code of CTorres actually finds what dummies need to be created, but when I have the same date appearing more than once, the corresponding dummy variable isn't created because I get an error message saying that there are more than one columns of the same name... ... View more

Hi Gergely, thank you for the reply, I ran the code and it worked good. But what if I have many categories for which I need to create corresponding dummies, and I don't know how many dummies there will be and what are they (and figuring this out and creating the dummies is tedious and time consuming) is there a way for SAS to do this for me instead of me actually creating dummy2010, dummy2013 etc? Thank you ... View more

Hi CTorres, Thanks a lot for replying, I ran the code and it worked fine !!! Staying on the same note, I would like to ask a small variation of my initial question please. Suppose that instead of dates I had some categories and wanted to get the dummies for the categories, like the following: ID Category Dummy A Dummy B 1 A 1 0 2 B 0 1 Thank you! ... View more

Hi Reeza, In your code you had the following statement: select catx("=", name, compress(name, "_")) into :rename_list because if I understand correctly you did: rename age= age_student sex = gender_student; but if in my case I didn't do the rename, but just had: input age_s g_by; that is, there are no "=", so is it possible to put that into the catx? Its just that I still can't figure it out and was guessing if that's what I am doing wrong... Thank you ... View more

Hi Reeza, thanks for the code it worked, but what if I have my own data and not the one given from sashelp, for ex: data x; input age_s g_by; datalines; 1 2 3 4 ; run; in such a case how can the "_" be automatically removed? Thank you ... View more

I ran the code and there's a lot of output so I didn't want to paste it all, but when I did the proc contents I saw that the variable names are actually ok, and that the names which I reported as having a space bw them are  labels... and that's probably why SAS was telling me that I couldn't use in the code 'greatest score'n ... But out of pure interest, I created a small data set on Excel simulating my apparent initial problem, i.e a variable named "greatest score". I successfully imported it into SAS and when I did its proc contents I saw that SAS actually called it "greatest_score", so it seems that SAS automatically inserts the "_" . But suppose now that what I wanted to do is to get rid of all the "_" and instead of having for ex "greatest_score" to have "greatestscore" Thank you ... View more

Hi FriedEgg, sorry if I bother you too much with this but when I did the following: data class; set sashelp.class; 'greatest score'n = weight; 'foo bar'n = height; run; I still got a message that these are not valid names... And when I did this: data _null_; length rename $ 32767; rename='rename'; do until(done); set sashelp.vcolumn end=done; where libname='WORK' and memname='CLASS' and not nvalid(name, 'v7') ; rename = cat(strip(rename), ' ', quote(strip(name)),'n=',translate(strip(name), '_', ' ')); end; call symputx('rename', rename); run; I got a message that I have 0 observations... Thank you ... View more

Hi FriedEgg and thanks for the very quick reply! I wrote like you said but got the message that this is not a valid name. Here is what my code is like: proc sort data=uc; by 'greatest score'n; run; its pretty basic, but am I missing something? Thank you ... View more

Hi Xia Keshan, Thank you for your code!!! What I especially find interesting is that it will give me the date even if I have something like this: ABC (delisted in 1/1/2010 33.AA) I guess that this is because the prxchange function, with the arguments you gave it, is searching for the first from the left string element that is in the date form as specified by the argument. Thank you! ... View more

Hi Reeza, thank you for replying and for reading my previous question!!! I would like to ask a question, suppose I had ABC ( merged in 1/10/2012 because of reasons), when applying the scan function the "date" that I will get is "reasons" because its the last word, so is there a way of getting the date regardless of its position in the string? Thank you  ... View more