Data visualization with SAS programming

Conacatenating SAS datas

Reply
N/A
Posts: 0

Conacatenating SAS datas

Hello ,

could you please guide me.I want to concatenate my three datafiles.I had the data in .dat format and i used the following codes to permamnently store my SAS dataset in the C drive using code :

libname sc 'C:\SAS';

data sc.period1;
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=sc. period1;
run;

data period2A;
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=period2A;
run;

data period2B;
infile 'c:\Cwa\period1_sales_data.dat';
input TransactionID $1-8
DateofSale $9-16
;
run;
proc print data=period2B;
run;

I want to concatenate the there datasets ' period 1', 'period 2A,' and ' Period 2B' into one single SAS datafile to be stored permanently in my 'C:\SAS'; to make useful analysis of data .

Kind Regards ,
mark
SAS Super FREQ
Posts: 8,818

Re: Conacatenating SAS datas

Hi:
This question doesn't seem related to SAS/GRAPH or ODS GRAPHICS. This might be a question that would be better asked in one of the other forums. Perhaps in the SAS Procedures forum, where you asked about data similar to what you've posted here:
http://support.sas.com/forums/message.jspa?messageID=32178#32178
http://support.sas.com/forums/message.jspa?messageID=32184#32184

In general, you use the SET statement in a DATA Step program or PROC APPEND to concatenate or combine datasets. To merge or join datasets, you would use the MERGE statement in a DATA Step program or join in PROC SQL.An overview of these techniques is contained in this discussion:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001081414.htm

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 134 views
  • 0 likes
  • 2 in conversation