Hi all,    Today I want to list all distinct values in one column in one dataset. I did a search but mainly other discussions are about how to count the frequency of unique value of one variable by using sql.   For example, I use the dataset sashelp.class Name Sex Age Height Weight Alfred M 14 69 112.5 Alice F 13 56.5 84 Barbara F 13 65.3 98 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 James M 12 57.3 83 Jane F 12 59.8 84.5 Janet F 15 62.5 112.5 Jeffrey M 13 62.5 84 John M 12 59 99.5 Joyce F 11 51.3 50.5 Judy F 14 64.3 90 Louise F 12 56.3 77 Mary F 15 66.5 112 Philip M 16 72 150 Robert M 12 64.8 128 Ronald M 15 67 133 Thomas M 11 57.5 85 William M 15 66.5 112 What I want is how to code to get Sex M F or Age 14 13 12 15 16 11 (neither the ascending nor descending order is not a concern here).   Warm regards. ... View more

Hi SAS Experts,   I have the code below data var_cal; set my.keepvar_1999_2001_1; gviidkey=catx('_',gvkey,iid); prccd_abs= abs(prccd); by gviidkey; lagprccd_abs=ifn(first.gviidkey,.,lag(prccd_abs)); lagajexdi=ifn(first.gviidkey,.,lag(ajexdi)); lagtrfd=ifn(first.gviidkey,.,lag(trfd)); If n(prccd_abs,ajexdi,trfd,lagprccd_abs,lagajexdi,lagtrfd)=6 then raw_return=((prccd_abs/ajexdi*trfd)/(lagprccd_abs/ladajexdi*lagtrfd)-1)*100; log_raw_return=log(raw_return); run; I am not sure whether it is accepted that I can use BY gviidkey when this variable was calculated right above as noted in the code.   Kind regards. ... View more

Hi SAS Users,   Normally I treated two ways of comments in SAS (/*   */ and *    ;) similarly. I normally use the shortcut Ctr /  to make the comment line so did not notice the difference between these two.   However, today I want to separate the comment way to make my code aesthetically. For example, I want to let the comment outside the datastep as /* */ while the comments inside the datastep is * ;   It turns out as below data filter_; set my.keepvar_1999_2001_1; *Sufficient 3 componenst t calculate return and adjusted price; if n(ajexdi,prccd,trfd)=3 or n(prccd,prchd,prcld)=3 /**/ and ; run; As you can see from the picture, the word and turned red and * ; seem not to work while they are still black (I did not post the code because the code here did not show the red and black colors of what I want to impress)   I am wondering if I fall into any fallacy.   Warmest regards. ... View more

Hi all SAS Users,   Is there any shortcut or way to italicize or bold the words in the comment part of SAS. For example, I have a code as below /*Cut a file to three small pieces SAS4rum:How to cut a file to many small files ? https://cutt.ly/jlVejWX 3939186,7966392.. are last obs of a random company */ data keepvar_1999_2001_1; set keepvar_1999_2001 (obs=3939186); run; In this code above, I want to highlight the word "SAS4rum", "3939186", "7966392" to let the comment part more eye-catching? I am wondering is there any way to do that for the comment part, I did a search but the results so far saying that we can specify the font in the output parts but not the comment part (inside /* */).   Warm regards.   ... View more

Hi all SAS Users,   These two days I deal with a 128 GB file, and I fell super hopeless because just a very simple code, it takes around 30 minutes and still be there (around 12 million obs in this file). So now I decide to cut it into many small pieces and deal with each of them.   I have three questions here: 1. How to check with how many observations, my computer can perform reasonably, or just assign a number and test until we feel the computer being slow gradually?   2. How to subsample from observation N1 to N2. For example, the code to retrieve the first 10000 obs is as below: data want; set have (obs=10000); run; So, what if I want a new dataset from obs 10001 to 20000, what code I should perform? 3. A further question of my curiosity only, I have 11 million observations in the file have, is there any way to split this whole dataset to many subsamples that each subsample contains 1 million observation?   Warmest regards.   ... View more

Hi all SAS Users, Today when I import the library import into SAS Eg with the code below   libname import 'E:\Harv 27th_Feb_2021\global_daily_1999_2001' access=readonly; I try to have a look about the file in this library from Serve interface but there is no display as below? As you can see, no library import displayed.   Could you please tell me how to sort it out?   Warm regard! ... View more