can you tell me the procedure? i guess once we have imported the file then how to rename it and use that file ? Also i was trying to do time series analysis with it but i am unable to proceed both in seeing the trend also forecasting for the future please do revert back
... View more
let me put things into perspective, I had imported a csv file now after importing it the last column heading label was incomplete (since it was exceeding 32 characters) so that why I was asking for help if any further code can be applied to increase the label??
... View more
proc import datafile = "E:\Analytics_Backup_Acche\daily-spot-prices-for-heating-oil-1986-march-2016.csv" out = mylib.SpotPrices dbms = dlm replace; delimiter = ";"; run; this is running fine but the last column has text exceeding 32 characters hence it is not coming full, so what to do
... View more
Many thanks it is working but one problem i am finding is the last column where words have not come in full, New York Harbor No. 2 Heating Oil Spot Price FOB (Dollars per Gallon) (this is the full label that should have come but instead it is displaying (New_York_Harbor_No__2_Heating_Oi), so what can i do to give a full label name? Please suggest with codes
... View more
SpotPrices The code that i had used to convert the csv file was proc import datafile = "Path\daily-spot-prices-for-heating-oil-1986-march-2016.csv" out = mylib.Spotprices dbms = tab replace; run;
... View more
I have converted the CSV file into SAS but I am unable to find any solution for separating the columns. There are two variables one is the Date (DDMMYY) and the other is the Spot Prices of Oil. Please help
... View more