I’m at a loss. The code below won't work in Enterprise Guide but will in Base Sas. Also, I have the same input code for a different variable earlier in the program that works in both environments. The problem input code is in blue below. I'm using Enterprise Guide 6.1. Things I've tried: changing the format to comma12., best12., and dollar12., running the specific portion of the code in a different enterprise window, changing the original dataset's variable's name, moved the input code to various different places in the program, restarted the program, and restarted computer. Solution: had a coworker run the code without any problems- and it worked like a charm. She uses Base SAS 9.4 and I was then able to run it in that program with no problems as well. Problem: I need to convert ‘Annual_Retail_Sales_17a’ to a numeric variable but when I run this code it creates two numeric variables (Annual_Retail_Sales_17a and Annualretailsales), both missing all values. And the original character variable is still there (so I will have three variables, but two with missing values, and the original has values but is still characters)! title "open SAS file"; data FNS (keep= food_stamp_ID contract_id vendor_id); set 'X:\research\projects\pg(CHC)\STARS data\fnslist201711.sas7bdat'; run; data FNS; set FNS; food_stamp_id2 = input (food_stamp_id, 10.); drop food_stamp_id; rename food_stamp_id2=food_stamp_id; run; title "import csv file"; proc import datafile="X:\research\projects\pg(CHC)\ss\Sample 1 2 SF v2.csv " out= work.Sample dbms=csv replace ; getnames=YES; run; proc sort data=fns ; by food_stamp_id; run; proc sort data=sample ; by food_stamp_id; run; data FNSSample; merge sample (in=first) fns; by food_stamp_id; if first; run; data fnssample; set fnsSample; AnnualRetailSales = input ( Annual_Retail_Sales_17a, comma12.); run;
... View more