topic Re: Proc Expand in SAS University Edition in SAS Procedures

Proc Expand in SAS University Edition

tritringuyen — Mon, 17 Jul 2017 15:32:27 GMT

Hi, I am trying SAS University Edition. I found that some codes cannot be run with SAS University Edition. Here is an example of SAS log when I want to create lead values for some variables.

838 proc expand data=have out=want method = none;

ERROR: Procedure EXPAND not found.

839 by isin;

840 id fyear;

842 * Create lead for debtissuer;

843 convert DEBTISSUE;

844 convert DEBTISSUE = DEBTISSUEtp1 / transformout=(lead 1);

846 * Create lead for SEO;

847 convert SEO;

848 convert SEO = SEOtp1 / transformout=(lead 1);

850 * Create lead for cost of debt;

851 convert costdebt;

852 convert costdebt = costdebttp1 / transformout=(lead 1);

854 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE EXPAND used (Total process time):

real time 0.05 seconds

cpu time 0.00 seconds

Is there any SAS procedure which is similar to proc Expand and results in the same outcomes? Thank you very much!

Cheers, Thierry

Re: Proc Expand in SAS University Edition

Reeza — Mon, 17 Jul 2017 15:36:19 GMT

Not all SAS ETS procedures are available in SAS University Edition. I don't think PROC EXPAND is included 😞

Re: Proc Expand in SAS University Edition

ChrisHemedinger — Mon, 17 Jul 2017 15:43:10 GMT

The following SAS/ETS procs are included:

TIMEDATA, TIMESERIES, ARIMA, ESM, UCM, and TIMEID

PROC TIMEDATA is especially flexible, and you can probably use it to accomplish similar work to PROC EXPAND.

Alternatively, try SAS OnDemand for Academics -- hosted by SAS, this environment supports all of the SAS/ETS procs and more.

Re: Proc Expand in SAS University Edition

tritringuyen — Mon, 17 Jul 2017 16:18:46 GMT

Thank you very much! 😞

Re: Proc Expand in SAS University Edition

ChrisBrooks — Tue, 18 Jul 2017 10:42:23 GMT

Hi Chris

I'm sure when I've looked at SAS OnDemand for Academics before you had to be a teacher or student at an "accredited" body but looking now it seems independent learners can use it. Is this a recent change?

Re: Proc Expand in SAS University Edition

ChrisHemedinger — Tue, 18 Jul 2017 10:59:38 GMT

Hi @ChrisBrooks - yes, any learner can use SAS Studio on SAS OnDemand for Academics. No university or course affiliation is required.

To use SAS Enterprise Guide, SAS Enterprise Miner, or SAS Forecast Server on the environment, you do need to be a teacher or part of a registered class.

Re: Proc Expand in SAS University Edition

ChrisBrooks — Tue, 18 Jul 2017 11:15:43 GMT

Thanks - it's a shame about Enterprise Guide as I've been a big fan since, I think, about version 4....

Re: Proc Expand in SAS University Edition

ChrisHemedinger — Tue, 18 Jul 2017 12:11:28 GMT

I like to hear that. You didn't hear it from me, but you could register as an instructor and get access to download EG, exploring it for your own mentoring/teaching activities. The version you get is pinned to the SAS OnDemand for Academics environment, and I don't think you can use it at the same time as a commercial version. Also, some of the EG capabilities are "turned off" while connected to this environment.

Re: Proc Expand in SAS University Edition

tritringuyen — Tue, 18 Jul 2017 13:10:21 GMT

Thank you very much! I got an ID for SAS OnDemand now (never known before). Another concern is that whether data uploaded to SAS OnDemand are confidential?

Thanks,

Thierry

Re: Proc Expand in SAS University Edition

ChrisHemedinger — Tue, 18 Jul 2017 13:18:09 GMT

@tritringuyen:I'm sure it's spelled out in the terms of service, but you should not upload sensitive data to the SAS OnDemand for Academics environment. This area is for learning purposes and while data you upload isn't generally shared or accessible by other users, SAS does not promise rigorous security around these data files.

SAS offers "professional grade" hosting for companies with a much more secure/certified environment.

Re: Proc Expand in SAS University Edition

tritringuyen — Tue, 18 Jul 2017 13:28:10 GMT

@ChrisHemedinger thank you very much! I suppose that my data is not sensitive. However, I collect data for my research. I want to retain the copyright of those data. I read terms and conditions already, but I am not sure about how my data are used by SAS company.

Re: Proc Expand in SAS University Edition

ChrisBrooks — Tue, 18 Jul 2017 15:33:52 GMT

Re: Proc Expand in SAS University Edition

yuchang19931014 — Sat, 07 Apr 2018 09:54:46 GMT

Does proc autoreg and proc tscsreg included? as when I type them, it says proc autoreg and proc tscsreg not found

Re: Proc Expand in SAS University Edition

yuchang19931014 — Sat, 07 Apr 2018 09:57:01 GMT

does proc autoreg and proc tscsreg included?

Re: Proc Expand in SAS University Edition

Reeza — Sat, 07 Apr 2018 18:45:36 GMT

No, only limited PROCS from SAS/ETS are included.

Six procedures from SAS/ETS are included in SAS University Edition to support the forecasting tasks in SAS Studio. The procedures are TIMEDATA, TIMESERIES, ARIMA, ESM, UCM, and TIMEID. You might notice that SAS/ETS appears in the list of products that are included with SAS University Edition. However, only those six procedures are included.

Limitations are listed here:

https://support.sas.com/software/products/university-edition/faq/limitations.htm

@yuchang19931014 wrote:

Does proc autoreg and proc tscsreg included? as when I type them, it says proc autoreg and proc tscsreg not found