Hi SAS Users,   When collecting data from Compustat, one GVKEY (company) can have multiple IID (issue identifier) , so this SAS document suggests that these two identifiers must be accessed as a pair to properly identify a Compustat security.   In SAS, this SAS document says that SAS provides GVIIDKEY=option to provide access to Compustat securities through the composite key designated by "GVKEY.IID".   However, in my case, I have the data already with GVKEY and IID in separate columns. Can I ask what I should do to generate a GVKEY.IID in my current dataset based on the above idea?   I also attach my data in the attached file, here is a quick description GVKEY IID DATADATE PRCHD 001166 01W 04JAN1999 4.6000 001166 01W 05JAN1999 4.6000 001166 01W 06JAN1999 5.0000 001166 01W 07JAN1999 4.9000 001166 01W 08JAN1999 5.6000 001166 01W 11JAN1999 5.5000 001166 01W 12JAN1999 5.6000 While GVKEY and IID are character variables, the other two variables are numeric variables One idea popping up in my mind is just to create a new variable named, but I am not confident if I understand the idea of GVIIDKEY correctly. gvkey_iid=catx(_,GVKEY,IID) Apart from that, when I run this code libname import 'E:\Harv 27th_Feb_2021\global_daily_1999_2001' access=readonly; /*Creating gvkeyiid var*/ data sample; set import.qgorvcptbfwuowrm5; gvkeyiid=catx(_,gvkey,iid); run; The log announced a note as below: 30 /*Creating gvkeyiid var*/ 31 data sample; 32 set import.qgorvcptbfwuowrm5; 33 gvkeyiid=catx(_,gvkey,iid); 34 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 33:17 NOTE: Variable _ is uninitialized. Could you please tell me how to solve it as well?   Warmest regards! ... View more

Hi all SAS Users,   Today when reading a SAS code: data have; input x @@; datalines; 1 2 3 ; data test3; set have; put _N_=; _N_=0; put _N_= //; run; The log is as below _N_=1 _N_=0 _N_=2 _N_=0 _N_=3 _N_=0 It is my first time seeing "/ /" in SAS, I tried to perform some searches but there is no result available for me, even from lexjansen. My keyword is " "/ /"  in SAS meaning", whether I did something wrong in searching as well? And could you please explain what does "/ /" play on the above code and some cases we normally apply this one?   Warm regards.   ... View more

Hi all SAS users,   Today I am trying  to understand the usage of _N_, when looking at the link , I saw an example that the author used to create the dataset: data have; input x @@; datalines; 1 2 3 ; I am not familiar with the character"@@" so I did a search, and from what I search, I still cannot clarify what does "@@" actually do and how it work, could you please explain it to me and how it works in the above code?   Warmest regards. ... View more

Hi everyone! Today I face a basic problem but I do not know how to work on it efficiently.   I have a library named "my", I want to create an output of my.nlsy for checking data purpose (nlsy is a sas7bdat file in this library). Normally, I will do libname my'C:\Users\pnguyen\OneDrive - Massey University\SAS\Document\FERMFLDUSAS_data' access=readonly; data call_nlsy; set my.nlsy; run; But I think it is quite weird because we need to create a data step for such a simple task, and I do not want to use proc print as well. Is there any way to extend the libname statement or else to show the output my.nlsy efficiently?   Warm regards.   Update: I follow this document to call an output but it does not work. In this document they wrote: libname saveit 'your-data-library'; data saveit.weight_club; I also wrote the same thing in my code libname my 'C:\Users\pnguyen\OneDrive - Massey University\SAS\Document\FERMFLDUSAS_data' access=readonly; data my.nlsy; but the log is like that 28 libname my 'C:\Users\pnguyen\OneDrive - Massey University\SAS\Document\FERMFLDUSAS_data' access=readonly; NOTE: Libref MY refers to the same physical library as ECI00001. NOTE: Libref MY was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\pnguyen\OneDrive - Massey University\SAS\Document\FERMFLDUSAS_data 29 data my.nlsy; 30 31 %LET _CLIENTTASKLABEL=; 32 %LET _CLIENTPROCESSFLOWNAME=; 33 %LET _CLIENTPROJECTPATH=; 34 %LET _CLIENTPROJECTPATHHOST=; 35 %LET _CLIENTPROJECTNAME=; 36 %LET _SASPROGRAMFILE=; 37 %LET _SASPROGRAMFILEHOST=; 38 39 ;*';*";*/;quit;run; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: Write access to member MY.NLSY.DATA is denied. ... View more

Hi all SAS Experts,   I am new to SAS regression, I am working in finance research. After asking some questions in this forum, some experts ask me to read the book "Fixed Effects Methods for Linear Regression" (Paul Allison, 2005), then search lexjansen for answers then come back to this forum to ask if there are any questions (e.g: @StatDave  and @Reeza ). I am wondering if the questions about that book are allowed to be posted here, if not, please let me know and I am happy to receive any suggestion to align with the forum's rules.   I am quite a bit confused about that  1. The example in this book (I am standing on chapter 2) is straightforward with simple examples, I am wondering why many suggest me to go through lexjansen to search in any case, can I ask how to use lexjansen website and this book efficiently?   2. Regarding Output 2.2 in this book (page 13), he wrote something that I did not understand, and I do not know how to search from lexjansen website to go through it     I do not understand the part "Output 2.3 shows that although the majority of children did not change in status, about 24% did change in one direction or another", what does "24%" means and where it is on the Table?   Apart from that, the Table output 2.3 also really unfamiliar to me, because I do not know how to read this Table. For example, I do not know pov90 standing there for what, and what do 0 and 1 mean?   Warmest regards.       ... View more

Hi everyone,   I am dealing with a sas7bdat dataset file of around 120 GB. After using SAS EG to open it, I perform a quick search for IID="01W", the program stuck and suspend for a long time and still not working so far. Could you please tell me what should be the solution here? Talk to the tech guy and what should I talk to them?   Warm regards. ... View more