Thank you @Reeza . It worked and served my purpose now. I informed the upper level about this issue since its from a vendor. From this post I came to learn extend ( new option) and how to deal with these kind of Issues. Thanks to you all. special mentions to @Reeza @SASKiwi @Kurt_Bremser @Tom for you time on this issue
You cannot use hyphen in a dataset name.
Example:
456 options validmemname=extend; NOTE: Windowing environment support for VALIDMEMNAME=EXTEND is limited to Editor, Log, and Output windows. 457 data "test-name"n ; 458 x=1; 459 run; ERROR: The value TEST-NAME is not a valid SAS member name. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds
Reprimand the fool that created the file.
Rename or copy the file to one with a valid name and then SAS will be able to use it.
@Tom - I should have read the documentation for EXTEND a bit closer - see below.
@SASuserlot - I believe your offending dataset is on your local PC drive. If so just go into Windows Explorer, make a copy of the dataset file, then rename it and remove the hyphen. I can only assume the producer of the file has renamed it manually like this as you can't create a dataset containing a hyphen in the name in SAS itself.
specifies that a SAS data set name, a SAS data view name, or an item store name must follow these rules:
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.