Im pretty sure the wizard from the file menu in EG gives you the code it uses to read in the data (as a tab next to the log and output data tabs). I also think it defaults to using data step with an infile statement which would not require Office. The reason you lose data when changes the file extension is the row limitation that older excel files had of 65K rows. Of course in EG if the wizard is part of your process flow it should work fine each time it is ran. Is there a reason that you are trying to move to proc import? EJ ... View more

I my be misunderstanding your need, but if you need all the rows to remain and just retain the value of the last pm value then you will have to do something like: proc sort data=dir.sampler;      by date id descending time ; /*places last time row first in the dataset*/ run; data test;      set dir.sampler;      by date id descending time;      if first,id then lastpm = pm;      retain lastpm; /*keeps the value until changes at the next id*/ run; I dont have anything to test this with so this is untested code. Eric ... View more

I dont think this is a SAS issue but an corrupt file issue. You may have to go back to the original and get a new copy. Copy the file again and then look in your OS to make sure the copy is the same size as the original. If it matches, then try to read it through SAS. OR if you have access to the original file location you can try to to point SAS to that file directly and see if you have the same problems. EJ ... View more

Have you compared the size of the file that was copied to your drive with size of the original? Something may have happened during the copying of the file especially if you are talking about really large file (multiple gbs). I dont think the formats are the problem since not having them would throw a different error than the one you are describing. I would first verify that the full file was copied correctly to your drive. EJ ... View more

I just realized I forgot to add my render code above: proc sgrender data=q1q2 template=piechart;   where q1 ne '';   dynamic _var = 'Q1'   _title = "Q1: How long have you been a Medicaid provider?"   _sz = '10pt'   _dlc = 'Percent'   _dll = 'Auto'   ; run; proc sgrender data=q1q2 template=piechart;   where q2 ne '';   dynamic _var = 'Q2'   _title = "Q2: What is your provider type?"   _sz = '10pt'   _dlc = 'Percent'   _dll = 'Auto'   ; run; ... View more

I think what Im looking for is something similar to the radius option in gchart but for GTL. Any ideas? EJ ... View more

I would guess your email settings are already setup if you are able to send email at all through SAS. EJ ... View more

Just to be clear your email is set to view HTML email by default. If the same code generates emails to others that work, the real problem may be your email client. EJ ... View more

I might be confusing things but the above code is set to import data from a excel sheet and not export data as you described in your post. Im pretty sure that the dsd option on infile defaults to a comma delimiter instead of a tab delimiter. But again that would be for importing the data from excel. If you have SAS/ACcess for pc files you can do either an import or and export using libname syntax: Import: libname test excel "C:\Users\mrinal\Desktop\test\Badahar.xls"; *once you run this you should see it listed in the sas explorer on the left; data yourdata; *creates the sas dataset;      set test.'yoursheetname$'n; run; libname test clear; *clears your connection to the excel file; Export -- basically the same but the data step is reversed. Data test.'sheetname'n;      set yourdata; run; See if any of this helps! EJ ... View more

IN SAS, since the value is in quotes you do not have to "declare" the variable as character as with some other languages. If you so desired you could change the length of numeric variables in the same way, but that comes with the lost of precision when moving from 8 bytes. EJ ... View more

Try proc sql;      select 'abc' as name length=20      from xxx      ; quit; EJ ... View more