About Boa

Boa · ‎12-08-2016

How do you explain Smooth trend state and smooth season state by month 1 - month 12. What are the difference btween them, cant seem to find any definition, or i found was the equation.

Boa · ‎12-07-2016

Can someone explain to me. what this code is doing? basically, i want to display the year 2008 and 2010 with the different month sold in the products. My code do not recognise xlog. Please help. proc arima data=temp_orders; identify var=xlog(1,12); estimate q=(1)(12) noint method=ml; forecast id=orderdate interval=month printall out=b; run; I got this error message :ERROR: Forecasting was not performed because estimation was not done.

Boa · ‎11-30-2016

thanks for explaining the differences. So, after proc sql i did a proc rank which creates another variable to indicate the quartile range for each worker. for example, 1,2,3. My question is to display worker that falls under value 3 and keep only the 3 columns i mentioned above. Any advise on continuing the code?

Boa · ‎11-30-2016

data work.merged; set assign.earnings assign.workers keep worker_id totalearning lastname; run; // this is not merged? cause i setting both datasets together as one? How do i show the data from Q3 onwards, i have 5k records so probably 4k records onwards, i would like to display. Thanks

Boa · ‎11-30-2016

Datasets with 5k records. i have to find all workers in the 3rd quartile of the amount they earned And keep only lastname,total earning and their ID. This is the raw data of both dataset Earning data set, there are spendingid, customerid, totalprice Earning_id Worker_id totalearning 1212112 12311111 1900 989898 9908009 2980 3i31030 3376247 20000 233233 3332323 6000 Worker dataset, there are customerid and firstname Worker_id lastname 12311111 Ellen 9908009 JOhn 3376247 Jay My code: data work.merged; set assign.earnings assign.workers keep worker_id totalearning lastname; run; proc print data=work.merged; run; Q) So basically i need to merge the two dataset first because the lastname does not contain in the earnings dataset and then showing the Q3 of those customer earnings. Result: worker_id totalearnings lastname 121112 1900 989898 2980

Boa · ‎11-29-2016

Boa · ‎11-29-2016

Boa · ‎11-29-2016

Please delete this thread.

Boa · ‎11-28-2016

ok thanks., i have another question that is similar to this, i probably would post another question. But i doubt it would use monname3.

Boa · ‎11-28-2016

Firstly, thanks for the code. I tried and used it for my program, the code looks fine but there is no output in the orderdate. i would like to ask why would you put a bracket behing a where clause? if you put that, the where clause wont run and it shows error. And what is mnth? am i creating a new variable just for month itself? Kindly advise. Thanks 🙂

Boa · ‎11-28-2016

Yes they are stored in the dataset already. is it possible to just show the month in the year 2008 instead of just printing the date and month together?

Boa · ‎11-28-2016

Hi sasusers, i have a dataset of 300000 + datas and with orderdate as my only column and it contains Datetime as well. How can i show all the month in a 2008? For example, Jan , Feb , Mar without the days value. I am doing this for a bar chart wizard. Some data in my orderdate: Orderdate 13OCT07 00:00:00 2JUN08 00:00:00 2JAN08 00:00:00 1JAN08 00:00:00 1DEC08 00:00:00 5DEC09 00:00:00

Boa · ‎11-27-2016

numunits is just another column but i supposed is not needed for my question. i want Q3 for all customer.

Boa · ‎11-27-2016

There are more than 1 record in the customer data, where should i make the join statement? I tested out the code and it got error, that shows variable is not found data merged; run; proc rank data=merged out =quartiles groups=4; VAR totalprice Ranks price_quartile; run; proc print data=merged; run;

Boa · ‎11-27-2016

Hi sasusers, i need to merge the 2 datasets as some columns not included in the dataset. Therefore, is it possible if i use proc univariate and then merge together? And i tried using sql but do not get the result. Just an example of the dataset: Spending data set, there are spendingid, customerid, totalprice and numunits Spending_id Customer_id totalprice numunits 1212112 100000 19 2 989898 112121 298 10 3i31030 20000 2 22 Customer dataset, there are customerid and firstname Customer_id firstname 12311111 Ellen 9908009 JOhn 3376247 Jay Question: Show all the customers in the 3rd quartile of their spending. Display their name, total spent and their customer id Thanks in advance.:)

Online Status	Offline
Date Last Visited	‎12-13-2016 09:26 AM

Difference between these two terms.

Explain on this code.

Re: Merge help with displaying Q3 onwards

Re: Merge help with displaying Q3 onwards

SQL Q3

Re: Need help in Date function

Re: Need help in Date function

TIme

Re: All month in a year

Re: All month in a year

Re: Merge help with displaying Q3 onwards

Re: Proc Univariate

Re: Proc Univariate

Re: Finding Q3 using proc sql

Difference between these two terms.

Explain on this code.

Re: Merge help with displaying Q3 onwards

Re: Merge help with displaying Q3 onwards

SQL Q3

Re: Need help in Date function

Re: Need help in Date function

TIme

Re: All month in a year

Re: All month in a year

Re: All month in a year

All month in a year

Re: Proc Univariate

Re: Proc Univariate

Proc Univariate