Hello Koen,   Thank you for providing an alternative to check my data set. I've tried it, and there is no duplicates. I've sent you a private message as well. I really appreciate your great support 😊   ... View more

Hello @sbxkoenk ,   No problem with generating data sets on SAS trial so far. Thanks a lot!   I've checked if the year value is unique within every firm in my data set with the following code: /*sort my data set by firm and year*/ proc sort data=panel_data; by firm year; run; /*mark 1 if there is a year value occurring more than one time within a firm*/ data panel_data; set panel_data; by firm; lag_firm=lag(firm); lag_year=lag(year); if first.firm then mark=0; else if firm=lag_firm and year^=lag_y+1 then mark=1; run; There isn't any observation marked 1, which means there is no duplicated year value within every firm in my data set. Is there other possible reason why that error keeps showing up? I know that in the ID statement, a time variable is optional, but I think it should not be an error if I have it there.🤔 ... View more

Hello Koen,   Instead of uploading my data into CAS, I "create" a data set on the server, so that I can analyze it (I'm waiting for SAS Technical Support to get back to me at the same time).   Within my Viya trial environment, I run my code as follows: proc cpanel data=casuser.panel_data; id firm year; model elimat = early_refin asset leverage tbrate / ivfixtwo; /*tbrate is an interest rate that changes with time*/ endogenous early_refin; instruments turn_call; run; But the log keeps saying "ERROR: Duplicated time values within cross sections. Unable to proceed." If I drop "year" in the ID statement, it works, but I want to fix year effect as well. Do you know how I can fix this error?   ... View more

Hello Koen,   I was using WinSCP to connect to the server, but I don't know the name of the server hosting my SAS Viya trial on Jupyter Notebook, so I've send an email to SAS Technical Support to ask about this. It should work if I get the host name. Anyway, thank you for you help. I will let you know how things are going. Have a nice weekend! ... View more

Hello Koen,   I tried to run your code on the portal link I got (Jupyter Notebook), and the first three lines worked perfectly, so I think I can run SAS code on the Jupyter Notebook. There's no need to be familiar with python.   However, before I run PROC CPANEL, I have to "upload" the file in my computer to the CAS in-memory. How can I achieve that? ... View more

Hi,   I think there isn't a profile button on my SAS Studio user interface. This is how my SAS Studio looks like: (I'm sorry that it's automatically in Chinese for some reason) The top-right button is just a log-out button (登出).   The email I received right after I signed up for SAS Viya trial is here: As I click on Log in to your Trial Portal, it directs me to Jupyter Notebook. I hope that this portal is not the only way I can use Viya trial.   I think the main problem is that SAS Studio doesn't know I signed up for Viya trial. Do you know how to fix this?   ... View more

Hello Koen,    I ran the code on SAS Studio and errors showed up. Do I need to do something to tell SAS Studio that I want to use SAS Viya? I just googled "SAS Studio", logged into my SAS account, and opened SAS Studio. Is there anything I need to do before running the code? ... View more

Hello,   Sorry for my late reply. It was late night here in Taiwan then. I think I've successfully logged into SAS Studio, but I don't know whether merely SAS Studio will work, or I need another thing called "SAS Studio V." Thank you for your information. I thought I could only use Jupyter Notebook with SAS Viya trial. It's good to know that I don't 😆 ... View more

Hello,   I just signed up for SAS Viya trial, but I have difficulties "activating" the environment (starting a CAS session, creating a CASLIB, passing data to CAS, etc.), since I am new to Jupyter Notebook. Could you provide me the code to do all those "settings" before I can run a PROC CPANEL? If it's too complicated, is there any "SAS Viya on Jupyter Notebook" tutorial that you recommend? (I haven't found one on YouTube yet.) Thanks a lot. ... View more

Hi Koen,   This code works when I drop the BY statement. Is the BY statement for fixed effects?   And I'm trying PROC CPANEL which you've suggested before. Since I only have SAS 9.4, I'm looking for a way to start a CAS session. I was following the steps from a SAS tutorial on YouTube, but problems happened again. The code I used to start a CAS session is as follows (totally the same as the tutorial):   %let path=/Users/lab433/Documents/SAS_dataset/RFS; libname mycas "&path"; cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US"); However, the log said "A host name is required to start a session. Use the HOST= CAS statement option, CASHOST=system option, or the _CASHOST_ environment variable to set the host name."   After checking the SAS documentation, I still don't have any idea about what to specify after the HOST statement. Do you know how to start a CAS session within SAS 9.4?  I really appreciate your kindness and help.     ... View more

Hi @Saba1, I've been struggling to figure out the same problem as you did. I would like to run a 2SLS regression on my panel data, and I also need to include firm and year fixed effects and cluster standard errors at firm level.  It's frustrated to find that similar problems posted on SAS community seems to end up being unsolved. I was wondering if you eventually fixed this. If you did, could you tell me how? Thank you.   ... View more