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:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.