Thank you! ... View more

Yes, you are right, There is PCFiles server installed on my PC, and I am trying to transfer files between PC and SAS grid server. Somehow the ftp is not allowed in our SAS server for security purpose, it's really not convenient when I try to output my SAS data to CSV files. are there any other options other than the ftp?   Thank you, Jade ... View more

when I try the syntax of "proc import" with csv file, I got an error at the "server" statement said "ERROR 180-322: Statement is not valid or it is used out of proper order." I wonder usually how people try to transfer csv file from PC to SAS grid server? Thank you!   I will try the data step too. ... View more

I am trying the file transfer between PC and SAS server, it works for excel file. I am wondering whether there is some ways that work for CSV file. Syntax work for excel file: proc import datafile="C:\test.xlsx"  out=work.TEST_server dbms=excelcs replace; server='********'; run;   Any suggestion for similar coding works for CSV file? Thank you! ... View more

The value of "TenDay_BuyReturn" is missing after I used the following proc expand coding, does it make sense? (for example: we have 1/1/2010, 1/3/2010...etc. data, after proc expand, the "sale_TenDay_BuyReturn" is missing for the added 1/2/2010 data. ) Proc expand data=WORK.sale_TenDay_BuyReturn  out=WORK.sale_TenDay_BuyReturn from=day method=none;    by department location;    ID date; Run; ... View more

Thank you! ... View more

Thank you for the quick reply! The data is daily, but it is not daily when group by department and location level for column "10-day buy then return", The data I am using right now is calculated the "10-day buy then return" column at department and location level.   when I run the coding below, I got an error said "observation with duplicate ID value found":   proc timeseries data=sale_TenDay_BuyReturn plot=series; id date interval = Day; var TenDay_BuyReturn; run;   For example for 1/1/2016, I have the data for two different departments. How should I proceed now? Thank you!   Jade  ... View more

Thank you for your reply!   There is apparently no missing in this data set, I could not nderstand that the smallest interval is missing. Is it because the data is not daily data at the hierarchy level?   My data is kind of like daily sale data at different store location and different departments, and I am dealing with the 10-day buy_then_return data for now.   I guess my question is usually how do people define the time interval, by forecast studio or other tools or procedures (like the coding you provided)? Thank you so much!   Jade ... View more

Thank you. I am use it for some do loop calculations. See details: https://communities.sas.com/t5/SAS-Data-Management/how-to-come-up-with-a-do-loop-in-SAS-in-this-special-situation/m-p/393347#M11947   ... View more