Hi there, I second this request for wider scroll bars in SAS EG 8.1.  Although I appreciate the observation of the existing relationship between the operative system and the bars width, it is not a solution.   Many of us who use SAS at work cannot choose a particular operative system.  We have work computers that our companies tailor to their needs. Thanks, Claudia ... View more

@claudiajc wrote: Dear experts, I am creating the data set ap3_8fmt to create the formats for a variable called ap3_8, contained in the data set tsdemwl. The formats are stored in the work library (I can see that in the results window) but they are not picked up by the data set that contains the variable ap3_8. Could you please tell me what am I doing wrong? Many thanks, Claudia   Nothing in your code shows that the set tsdemwl should use the format. You create mydatawf from  p1dem.tsdemwl and use the format but there is NO reason that  p1dem.tsdemwl should have any connection to the format. If you try this code after the format is created then you can display the value from that data set with the given format. proc print data= p1dem.tsdemwl; format AP3_8 $AP3_8F.; run; Or you can use proc datasets to change the current format of the variable ap3_8 in the data set.   Formats must be explicitly assigned, either for use during a procedure, when a variable is created or by modifying an existing data set to change the format. Otherwise there is know way for SAS to know that you want to use a different format than the one assigned when the original data was created. ... View more

I came here with the same isue. One of the existing answers suggested I should review carefully my code again. I found a missing closing parenthesis was causing the error. The missing parenthesis made the code look something like this:   %macro a (var1,var2;     The right code should have been:    %macro a (var1,var2);   ... View more

I just had to go through this wonderful process...what a pain!   No guarantees, but hopefully this will get you going.   First, you need to figure out how your spreadsheet is encoded. My source data wasn't a spreadsheet, but I think this will work. In Excel, do File | Save As | click More options | click Tools | click Web options | click Encoding. Hopefully, this will show you what your spreadsheed is stored with.   Once I knew this, and had my data imported, running this fixed my up (in my case the data was UTF-8).   /* Set the encoding of the dataset to utf-8 */ proc datasets lib=work nolist; modify indata / CORRECTENCODING='utf-8'; quit;     Good luck!   Tom ... View more