04-09-2012 01:40 PM
I'm new to SAS.
I am trying to work with datasets in SAS that are >32 characters long. When I try to create a dataset based on this dataset I get the error "
ERROR 307-185: The data set name cannot have more than 32 characters." Here's the code I have.
I cannot change the name of the original dataset, how do I go about creating the new dataset.
04-09-2012 02:35 PM
This can be acheived by SQL Procedure Pass-Through Facility
Oracle Data base
DB2 Data base:
MS Access: Refer to Page # 16
04-09-2012 03:32 PM
You've found one of SAS weaknesses. As nobody wants to type in more than 32 characters to refer to a dataset, it would be nice to document datasets a little better. You can do so with the LABEL= dataset option (256 chars limit). But that label will almost never show up in reports. That's one reason why I never create permanent SAS datasets to store important data.