06-18-2018 11:45 AM
Observations in SAS are like rows or records of data. The message you are seeing indicates that the SAS data set (table) you have created holds no rows / records.
Share your code and a representative sample of the input data that can be read by your code. Also share the log.
06-18-2018 02:04 PM
06-19-2018 03:46 AM
You have to describe more precisely your needs.
Here are the contents of your csv file :
Trial - 2015,,,,, ,,,,, food quality data,,,,, ,,,,, Plot,Cultigen number,Rep,Loc,Std,1 ,,,,, 6360,1,1,CIe,6,11 ,,,,, 6366,2,1,CIe,6,.
What should the output dataset look like ? What are the names/formats of the columns ?
06-19-2018 07:50 AM - edited 06-19-2018 09:43 AM
data FoodQualityData; infile "path/filename.csv" firstobs = 6 dsd; input Plot Cultigen number Rep Loc $ Std _1; run;
06-19-2018 09:10 AM
06-19-2018 09:42 AM
data FoodQualityData; infile "path/filename.csv" firstobs = 6 dsd; input Plot Cultigen number Rep Loc $ Std _1; run; open your file and check from which line the data starts and mention it in firstobs option.
I found only 7 variables in the files. So, I mentioned only 7 variables in the input statement. Ex : if the data starts from 6th line mention firstobs = 6 if it starts from 10th line then firstobs = 10
06-19-2018 05:35 AM
If your data is in a separate csv file then there should be no need to use datalines as shown in your code. The data step you have shown is incomplete. Please copy and pate the log, showing the SAS code and any messages after it is executed.
You can use the infile statement to specify the csv file and path:
A simple example template is:
data dst1; infile '<your-path-and-file-name.csv>' dsd; input <your-variable-names-and-formats>; run;
I cannot download your file, but from what @gamotte has shown it does not appear to have a clear structure which is why it would be helpful to also see the output you expect to see, based on the file you've provided, also as @gamotte has advised. You might need some extra logic in your data step to help you read in the csv file.
06-18-2018 11:46 AM
Which program ?
The log message says that SAS has created a dataset DST1 in the work library. This dataset has 18 columns but no row of data, i.e. it's an empty dataset.
Can you show the code and describe expected output.