My code is: PROC EXPORT DATA = Work.Cr_values OUTFILE = "S:\shared\cmcgath\temp\productivity\Final 2014\CR_Values.xlsx" DBMS = xlsx REPLACE; Run; However, I took another look at the Cr_values dataset and the two columns coming out as text in Excel are, in fact, text. I thought that they were numeric. My question becomes how I can convert the text columns to numeric columns in a PROC SQL procedure. The SQL program is: Proc Sql; Create Table CR_Values as SELECT YYYY as Year label='Year' ,Vgroup||'A'||st||vtype||vdesc1||vdesc2||sens as ArtificialKey ,CommodityCode ,vtype||vdesc1||vdesc2 as GroupType ,Vtype ,Vdesc1 ,Vdesc2 ,StateName ,FIPS ,VariableDescription ,unit_desc ,amount FROM FarmInc.Public_data_view Where Year between '2007' and '2013' and MM = '00' and vgroup = 'CR' and vdesc2 = 'VA' /* All Cash receipt values */ Order by Year,CommodityCode,FIPS; Quit; Year and CommodityCode are the text columns that I want as values. Also, I thought of exporting to a .cvs file. The two columns come in as values in Excel.
... View more