Hello ,
could someone please help me out.I've sales data with variables Date of Sale, Number of units sold and the Laptop model ( there are two A and B ).I've three raw data files called :
Period 1 sales , Period 2 Sales_A, Period 2 Sales_B.
I used the following code to first obtain the raw data in proper format :
libname sc 'h:\SAScourse';
data Period1Sales;
infile 'h:\SAScourse\period1_sales_data.dat';
input TransactionID $1-8
DateofSale $9-18
TimeofSale $19-26
LaptopModel $27-32
UnitsSold 33-35
Warranty 36;
proc print data = Period1Sales;
TITLE 'period1_sales_data.dat';
RUN;
data period2_sales_data_A;
infile 'h:\SAScourse\period2_sales_data_A.dat';
Input TransactionID $1-8
DateofSale $9-18
LaptopModel $19-24
UnitsSold 25-27
Warranty 28;
proc print data=period2_sales_data_A;
TITLE 'period2_sales_data_A';
RUN;
data period2_sales_data_B;
infile 'h:\SAScourse\period2_sales_data_B.dat';
Input TransactionID $1-8
TimeofSale $9-16;
proc print data=period2_sales_data_B;
TITLE 'period2_sales_data_B';
RUN;
There was no problems with the first and third codes , but the 2nd code for the raw data file period2_sales_data_A is showing 0 obseravations selected . I get the varables but with no entries in them.
Also , is there a way to combine/merge all three raw data files into one file to analyse the data.
Regards ,
mark