i thank all of you from bottom of the heart.       Best wishes. ... View more

Hello Reeza,     Thanks for you advice, i will keep in mind. I tried to implement your simple code in my sas. but it does not work. what is the problem? too many arguments?     proc sql; create table count_stocks_by_date as select date, count(distinct cusip number) as count_stock from tmp1.secnmd group by effective date; quit;   this is what i tried to do. ... View more

Hello Dear Cynthia,   I am a beginner and undergraduate student who is trying to replicate a finance paper individually. First obstacle was i needed to learn sas by myself, and still learning. as far as i thought, cusip is an unique identifier which represents a firm or company.   this is a sample of my data set: from here, i want to get number of firms by cusip for each year. how may firms in a year. of course, i was not doing anything and i had tried to use count function;  proc sql; select count(distinct cusip) as count_cusip, count(distinct names date) as count_names date from tmp1.msenames; quit;     i have attached a sample data set.      thanks for you reply and feedback,       Best wishes,       sincerely Daniel     ... View more

dlstdt is the date ..... ... View more

how should i change the entire code to change my dsltdt format?   thanks a lot. ... View more

i know, it is a silly question. but how do i drop x and take y as a main afterward? ... View more

dlstdt is numeric and format is:YYMMDDN8. ... View more

i am novice to sas and a student who is trying to learn sas individually. here is what i get : Obs DLSTDT 1 19870611 2 20151231 3 20130215 4 19951215 5 19910711 ... View more