Many thanks for reply. PROC IMPORT OUT= work.test DATAFILE= "C:\temp\Test.xls" DBMS=EXCEL2000 REPLACE; SHEET="Underlying data"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Applogies I was not able to attach excel sheet here.
... View more
With PROC import while uploading data from excel into SAS the formulas values are convered as blank. how can i upload excel formula DATA values into SAS.
... View more
HI, with PROC EXPORT option data in excel is not in colourful format. Hence I would like to create excel template file with lables and logo. than can I copy data from SAS to excel template file. Many thanks.
... View more