About Xusheng

Xusheng · ‎06-22-2017

Hi JPGilbert, if you are currently using SAS 9.4 TS1M1, maybe you can try to update your SAS from SAS 9.4 TS1M1 to SAS 9.4 TS1M3 and SAS 9.4 TS1M4. I heard that would help. Good luck. ##- Please type your reply above this line. Simple formatting, no attachments. -##

Xusheng · ‎06-16-2017

Hi ep121, sorry for the very late reply, I was away from Country and didn't get this notification from gmail by firewall. In terms of the problem. I found that if you are still having the problem, try to run two sas, you will get an error within the first opened sas, just ignore that one and close first sas, and the second sas would work perfectly. I hope that helps.

Xusheng · ‎04-25-2017

Hi ballardw, I correct a black error in the middle of the code and it can plot ACF and other figures now. Thank you.

Xusheng · ‎04-24-2017

Hi ballardw, thank you for replying. I think your advise led me to the right track. Here is the log after I ran your code: And here is what looks like in my c drive: if my understanding is correct the java is installed with the right version, which is 9.4? Looking forward your reply.

Xusheng · ‎04-24-2017

To someone who may concern, Hi I'm plotting the ACF of CAD with the following code: proc autoreg DATA=Combined plots(unpackpanel only) = ACFPlot; model CAD = Date; run; However, I got the following error in log: Can someone provide some advise with this error? Thank you.

Xusheng · ‎04-24-2017

Thank you for replying, I double checked the format part and fixed it by correcting a mistake. Thank you.

Xusheng · ‎04-24-2017

Hi I'm plotting the ACF of CAD with the following data example: However, the log gave the following error: So I guess the problem is my date is not numeric? If so, can someone provide some hint with this problem? Thank you. Here is the code I wrote for ACF plot: proc autoreg DATA=Combined plots(unpackpanel only) = ACFPlot; model CAD = Date; run;

Xusheng · ‎04-23-2017

Thank you, I'll read it

Xusheng · ‎04-23-2017

thank you, that's what I thought. However, the log gives the following error: any suggestion about this problem?

Xusheng · ‎04-23-2017

Hi Patrick, thank you for replying. I was trying to match the exchange rate data with oil return data. In general oil return data is less than exchange rate data in daily basis so I don't know whether to fill 0 in oil data in order to match exchange rate data. For the merging part, I was stilling trying to figure it out. I tried the solutions provided under this question but seems does not work very well.

Xusheng · ‎04-23-2017

Thank you art297, I understand now.

Xusheng · ‎04-22-2017

Thank you art297, I don't quite understand why we need "??" here. date=input(_date, ?? anydtdte11.);

Xusheng · ‎04-22-2017

Thkank you, I don't quite understand the 'cad.csv' Should this be the path?

Xusheng · ‎04-22-2017

Thank you Reeza, I will try this

Xusheng · ‎04-22-2017

Hi I'm trying to merge two files by date. However, the date is not matching and after I ran the code the log showed the following warning: "Variable Date has been defined as both character and numeric" Here is the example of two files: Can anyone give some suggestion about how to sovle this problem? Thank you.

Online Status	Offline
Date Last Visited	‎04-26-2019 06:57 PM

Re: If condition with By group

Re: If condition with By group

If condition with By group

Re: Retrieve particular number from a column

Re: Retrieve particular number from a column

Re: Retrieve particular number from a column

Retrieve particular number from a column

Re: Remove observations by date with if condition

Re: Remove observations by date with if condition

Re: Remove observations by date with if condition

Re: Remove observations by date with if condition

Re: Retrieve particular number from a column

Re: Retrieve particular number from a column

Re: Retrieve particular number from a column

Re: Remove observations when a variable contains more than 2 continuou...

Re: "Unable to load the Java Virtual Machine" when plotting ACF with S...

Re: "Unable to load the Java Virtual Machine" when plotting ACF with S...

Re: "Unable to load the Java Virtual Machine" when plotting ACF with S...

Re: "Unable to load the Java Virtual Machine" when plotting ACF with S...

Re: "Unable to load the Java Virtual Machine" when plotting ACF with S...

"Unable to load the Java Virtual Machine" when plotting ACF with SAS 9...

Re: Character date to numeric date & ACF plot

Character date to numeric date & ACF plot

Re: Merge by date, variable Date has been defined as both character an...

Re: Merge by date, variable Date has been defined as both character an...

Re: Merge CSV files with different date matching

Re: Merge by date, variable Date has been defined as both character an...

Re: Merge by date, variable Date has been defined as both character an...

Re: Merge by date, variable Date has been defined as both character an...

Re: Merge by date, variable Date has been defined as both character an...

Merge by date, variable Date has been defined as both character and nu...