but 12 prints entire column i want print 12 value for paritcular row only balls=compress('12(','('); is not working for tat balls 12 12 12 12 12 12 its print like this ... View more

So please tell me . What the extension of excel file How convert to sas And dbms value ... View more

  1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 proc import datafile='/home/naveence0/food3.csv' 72 out = datainput 73 dbms = excel 74 ; ERROR: DBMS type EXCEL not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds   whic extension should i use excel sheet to sas on windows system cpu time 0.00 seconds memory 44.00k OS Memory 26532.00k Timestamp 08/10/2018 01:25:47 PM Step Count 38 Switch Count 0 Page Faults 0 Page Reclaims 22 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0   75 run;   ... View more

proc import datafile="/home/naveence0/food2.xlsx" out= indata dbms=xlsx replace; run; proc print data = indata; ... View more

data breakfast; length items $20; length description $85; infile"/home/naveence0/food.txt" dlm='|'; input items$ price description$ calorieskl; run; proc print data = breakfast; data breakfast; set breakfast;output; format price DOLLAR10.2; ; run; proc print data= breakfast; ... View more

Thanks and how to do it tat from infile methid ... View more