topic Re: validvarname in SAS Programming

validvarname

fatemeh — Thu, 15 Feb 2018 23:39:50 GMT

Hello all,

As in sas, names begin with letter(lowe or upercase) or (_) but I want to use 2$adc2_ as my data set name and using (validvarname=any) .Where validvarname=any should be placed in a data step to make this name(2$adc2_) valid?below is my sas code. any help is appreciated.

data 2$adc2_ ; validvarname=any;
infile datalines;
input score1 score2 score3;
datalines;
90 80 98
78 88
65 66 69
92 94 96
;
run;
proc print data=2$adc2_;run;

Re: validvarname

Reeza — Thu, 15 Feb 2018 23:42:35 GMT

VALIDVARNAME is an option, not on the data set but globally.

options validvarname = any;

data ....

Re: validvarname

Tom — Thu, 15 Feb 2018 23:45:43 GMT

The VALIDVARNAME=ANY only applies to variable names, not member names.

Try VALIDMEMNAME=EXTEND.

Also make sure to use a name literal if you name does not follow normal naming conventions.

options validmemname=extend ;

data 'really$bad name'n ;
  x=1;
run;

proc contents; run;

Re: validvarname

WarrenKuhfeld — Thu, 15 Feb 2018 23:46:27 GMT

This is the correct placement of the option. It will not handle member names like yours.

options validvarname=any;
data '2$adc2_'n;
infile datalines;
input score1 score2 score3;
datalines;
90 80 98
78 88
65 66 69
92 94 96
;

proc print data='2$adc2_'n;run;

proc print data=2$adc2_;run;

Re: validvarname

fatemeh — Thu, 15 Feb 2018 23:59:31 GMT

thanks for your reply .still sas is giving me error for both validvarname=any and validvarname=extend

Re: validvarname

Tom — Fri, 16 Feb 2018 00:03:45 GMT

Copy the lines from the SAS log and paste them into the forum.

Make sure to use the {i} icon to pop-up a code window to paste the text to avoid having the forum editor reformat the text.

Re: validvarname

WarrenKuhfeld — Fri, 16 Feb 2018 00:03:46 GMT

Did you n-literalize my names (as I did in my example), which for some reason stripped out the line feeds.

Re: validvarname

fatemeh — Fri, 16 Feb 2018 00:10:56 GMT

options validvarname=any;
56 data '2$adc2_'n;infile datalines;input score1 score2 score3;datalines;

ERROR: The value '2$ADC2_'n is not a valid SAS 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.01 seconds

56 ! 90 80 9878 8865 66 6992
--
180
56 ! 94 96;proc print data='2$adc2_'n;run;

ERROR 180-322: Statement is not valid or it is used out of proper order.

ERROR: The value '2$ADC2_'n is not a valid SAS name.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

58 proc print data=2$adc2_;run;
-
22
200
ERROR: File WORK.ADC2_.DATA does not exist.

ERROR 22-322: Expecting a name.

ERROR 200-322: The symbol is not recognized and will be ignored.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: validvarname

fatemeh — Fri, 16 Feb 2018 00:51:37 GMT

thanks for your reply. I just copied the codes you corrected and pasted it in sas and executed that!

Re: validvarname

Tom — Fri, 16 Feb 2018 00:21:29 GMT

You are still trying to change the wrong option. validVARname is for VARiable names. You are trying to use dataset (member) name that contains gibberish characters. To do that you need to change the validMEMname option.

Re: validvarname

fatemeh — Fri, 16 Feb 2018 00:41:05 GMT

do you mean i should replace validvarname with validMEMname? below is my sas code still giving me error

options validMEMname=any;
data '2$adc2_'n;
infile datalines;
input score1 score2 score3;
datalines;
90 80 9878 8865 66 6992 94 96
;
proc print data='2$adc2_'n;
run;

Re: validvarname

Tom — Fri, 16 Feb 2018 01:23:39 GMT

@fatemeh wrote:

do you mean i should replace validvarname with validMEMname? below is my sas code still giving me error

options validMEMname=any;
data '2$adc2_'n;
infile datalines;
input score1 score2 score3;
datalines;
90 80 9878 8865 66 6992 94 96
;
proc print data='2$adc2_'n;
run;

And did you read the error?

39    options validmemname=any ;
              ------------
              14

ERROR 14-12: Invalid option value any for SAS option VALIDMEMNAME.

Did you look at the documentation for that option?

http://documentation.sas.com/?docsetId=nlsref&docsetTarget=n10nwm6blrcrtmn0zdcwyxlwxfjh.htm&docsetVersion=9.4&locale=en

Or read the previous replies to your topic?