Hi all SAS Users,   Today I try to use PROC rank in my project, due to the characteristic, I need to rank 100 groups per year per country. However, in this year in this country, there are only 13 observation, I am quite surprise that SAS can assign some numbers over there. Can I ask how SAS can assign these rank_ numbers? The value of variable need to be ranked amihud 0.0005088943 1.4387286E-6 5.767935E-6 5.3867482E-7 2.1144515E-6 4.2862647E-6 0.0001175097 8.5303028E-6 0.000117864 3.4827424E-6 0.0000313065 0.0000173605 8.5760194E-6 And the result is rank_ 92 14 42 7 21 35 78 50 85 28 71 64 57 How come SAS rank 92 or 42 while there are only 13 obs over there. Warm regards,   P/S: I think it is quite a bit irrelevant but my code is as below proc rank data=work.trim_price groups=100 out=temp; by LOC year; Comment LOC is country; var amihud; ranks rank_; run; ... View more

Hi SAS Users,   The interface Serve is very useful for me because apart from it can link me to all the SAS datasets in my computer, but I can also see all datasets inside all the libraries. Super convenient!! I just wondering, if SAS EG stores a lot of datasets like that, whether it costs the RAM or else?. And what is the directory for these datasets (I mean physically access).   Warmest regards. ... View more

Hi SAS Users, Normally, we use RETAIN to reorder the columns in a dataset. For example, I have a list of column names as below GVKEY IID DATADATE CIK CONML LOC SIC ISIN SEDOL EXCHG AJEXDI CSHOC CSHTRD CURCDD PRCCD PRCHD PRCLD PRCSTD TPCI TRFD ex_rate gviidkey prccd_abs prccd_abs_ lagprccd_abs_ lagajexdi lagtrfd raw_return log_raw_return raw_return_abs dollar_vol /*I highlight DATADATE and gviidkey manually for noticing purpose*/ Normally if I want to put gviidkey and DATADATE in the first two columns, I did: data have; retain gviidkey DATADATE; set have; run; However, if I want to put the two columns (GVKEY and IID) to the last columns of the dataset, what I should do without typing all column names in retain statement?   Warm regards. ... View more

Hi SAS Users, I want to work efficiently by using SAS EG, and one function I am really into is the automatically suggestion about function and dataset. However, regarding dataset, they normally suggest that I need to type the library first then SAS EG will suggest me the dataset inside this library. I am wondering that is there any way when I type "data" statement, SAS EG will suggest all the datasets that I can choose and "enter" quickly rather than I must type the lib (for example: WORK) first then get the dataset hint from SAS EG. It makes my dataset name looks longer and the lib name plays no role here.     I am not lazy, but sometimes the library name is just redundant, and I want to optimize and simplify my coding progress as well.   Warmest regards.   P/S: Even when I call a dataset in set statement., I also need to call the library first and then SAS EG will suggest me the datasets inside. I am not greedy, just want to know if there is any way to shorten the coding progress. ... View more

Hi all SAS Users, After reading a couple of discussion from the forum, people normally try to replace if by where or else because if consumes quite a bit cpu or else. I want to ask how to replace if in my case here, and is there any general rule to do so. At least I know in some case we can use where instead of if.   data dollar_volume; set work.filter_; If raw_return ne . then raw_return_=abs(raw_return); by gviidkey; Comment trading volume <share oustanding =>trading volume as missing; if cshtrd > cshoc then cshtrd=.; Comment trading volume*unadjusted price (converted to USD)< 100$ then set missing ; if cshtrd*prccd_abs_ <100 and n(cshtrd,prccd_abs_)=2 /*This code is still under suspicious*/ then dollar_vol=.; /*This code is still under suspicious*/ else dollar_vol=cshtrd*prccd_abs_; /*This code is still under suspicious*/ label dollar_vol=daily dollar volume raw_return_= abs of raw_return ; run; And I am wondering is there any specific document that mentions ways to replace if ?   Many thanks and warm regards. ... View more

Hi all SAS Users,   1. I get something wrong with my logic.   I have the variables cshtrd and prccd_abs_ are numeric variables, the summary is as below I want to generate a variables named dollar_vol= cshtrd*prccd_abs_ My code is Comment trading volume*unadjusted price (converted to USD)< 100$ then set missing ; if cshtrd*prccd_abs_ <100 and n(cshtrd,prccd_abs_)=2 then dollar_vol=.; else dollar_vol=cshtrd*prccd_abs_; And the log says that ( I just post lines 37 and 39 because they are relevant to the NOTE) 37 if cshtrd*prccd_abs_ <100 and n(cshtrd,prccd_abs_)=2 38 then dollar_vol=.; 39 else dollar_vol=cshtrd*prccd_abs_; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 176040 at 37:12 176040 at 39:25 I am wondering what I did wrong in my calculation and is there any hint to fix it?   Warm regards. ... View more

Hi all SAS Users,   Today, when merging two datasets by using proc SQL (I do not use hash object thingy because it is quite a bit complex to me at this moment).  My code is as below data origin / view=origin; set my.keepvar_1999_2001_1; _seqno=_n_; run; proc sql; create table matching (drop=_seqno) as select a.*, ex_rate from origin a left join currency b on a.CURCDD = b.CURCDD & a.DATADATE=b.DATADATE order by _seqno; quit; And the log is as below NOTE: DATA STEP view saved on file WORK.ORIGIN. NOTE: A stored DATA STEP view cannot run under a different operating system. First of all, regarding the operating system (OS), I took a look at a comment from the previous post by @Reeza    "I'm guessing you're using the wrong encoding option here, is the file created and being used on the same OS or are you crossing OS and languages here? For example, is it created out of a Unix System and read on a Windows System?"   I can say I run all of them on a Window system. Secondly, I did a search about the document about this line of note, this documentsas just mentioned this line of code and no further explanation. So, I am wondering if I need to care about that note.   Warm regards.       ... View more