Hello all, I'm a graduate student learning SAS and I have an issue regarding the proc import command. I used the following command to load my data from a csv file: proc import out=sasuser.Load_Data
datafile = "d:\ECE_592_DA\Homework1\Historical_Load_Data.csv"
dbms=csv replace;
getnames=No;
datarow=1;
run; The file has no header names so my data starts at row 1. The first column includes names like Segment:G, Segment:GF, Segment:R, Segment:RL, Segment:RLH, and so on while the remaining columns contain load data and dates. It's this first column that I am having issue with the above import procedure. The log tells me the import was completed successfully and I can verify the data in the table. Upon verifying column 1, I noticed that my data that is attached to Segment:GF is list as Segment:G, Segments RL, RLH all show up as Segment:R, not Segment:RL or Segment:RLH. I've included my csv file so hopefully you will be able to duplicate what I am seeing. I am using SAS v9.4 Desktop. Am I doing something wrong or what could be causing this issue?
... View more