04-02-2013 10:00 AM
I am relatively new to SAS and was wondering if you or could help me with the coding to join and import 25+ CSV files.
All data is in a single folder on my C drive and the format is the same throughout all files. Please see bellow sample of data.
SHA,PCT,PRACTICE,BNF CODE,BNF NAME ,ITEMS ,NIC ,ACT COST ,QUANTITY,PERIOD,
Q30,5D7,A86001,0703010F0BEAAAC,Microgynon 30_Tab ,1,0.94,0.9,21,201101,
Q30,5D7,A86001,0703022M0BBABAB,Depo-Provera_Inj 150mg/ml 1ml Pfs ,1,6.01,5.56,1,201101,
04-02-2013 11:12 AM
INFILE "myPath\*.csv" dsd missover firstobs=2 eov=skip lrecl=2000;
if skip then skip=0;
input sha $ PCT $ practice $ .... ;