topic Re: Variable is not defined or does not exist. GetVarc Help_Needed in New SAS User

Variable is not defined or does not exist. GetVarc Help_Needed

mdlucas1 — Thu, 24 Jan 2019 20:58:34 GMT

I am new to SAS and I am currently trying to write a program that uses Proc SQL; to create a table. After the table is created, I am trying to call variable/fields from that table in SCL to use later. Below is the section of code that is getting the error (names of tables and variables have been changed), and the error itself. Any advice on what I'm doing wrong would be greatly appreciated.

SUBMIT continue; 

proc sql; 
create table work.TestCount 
as select * , count(*) as field3 
from sasTest.table1 
where field1 ne ""; 
quit; 

endsubmit; 

refTest='work.TestCount'; 
FieldTest=open(refTest,'u'); 

TestField1=getvarc(FieldTest,varnum(FieldTest,field1)); <-- ERROR IS STOPPING PROGRAM HERE 
TestField2=getvarc(FieldTest,varnum(FieldTest,field2)); 
TestField3=getvarn(FieldTest,varnum(FieldTest,field3));

*** Line 130: [ERROR: #70] Calling function GETVARC. ERROR: Variable is not defined or does not exist.
Arguments passed to GETVARC:
1 FieldTest = 3
2 (Numeric Expression $T0) = 0
Program returning prematurely at line 130

Re: Variable is not defined or does not exist. GetVarc Help_Needed

pink_poodle — Thu, 24 Jan 2019 21:50:48 GMT

This is a very interesting question. Please try replacing this fragment

refTest='work.TestCount'; 
FieldTest=open(refTest,'u'); 

TestField1=getvarc(FieldTest,varnum(FieldTest,field1));

with this one:

dsid = open( "work.TestCount", "i" );

position = varnum( dsid, field1 );

TestField1 = getvarc( dsid, position );

References

[1] Varnum() function

[2] Open() function

Re: Variable is not defined or does not exist. GetVarc Help_Needed

mdlucas1 — Fri, 25 Jan 2019 13:15:01 GMT

Thanks for replying. This is unfortunately giving a similar error on the Getvarc again.

Here is a copy of the error:

*** Line 130: [ERROR: #70] Calling function GETVARC. ERROR: Variable is not defined or does not exist.
Arguments passed to GETVARC:
1 dsid = 3
2 TestField1 = 0
Program returning prematurely at line 130

Re: Variable is not defined or does not exist. GetVarc Help_Needed

pink_poodle — Fri, 25 Jan 2019 13:55:10 GMT

What happens if you type

TestField1 = getvarc( dsid, 1 );

Re: Variable is not defined or does not exist. GetVarc Help_Needed

mdlucas1 — Fri, 25 Jan 2019 14:08:43 GMT

It seems to be having trouble reading in any observations from the table even with the 1 hardcoded in.

Error:

ERROR: No observations have been read from data set WORK.TESTCOUNT.

Arguments passed to GETVARC:
1 dsid = 3
2 (Numeric Literal) = 1
Program returning prematurely at line 130

Re: Variable is not defined or does not exist. GetVarc Help_Needed

pink_poodle — Fri, 25 Jan 2019 15:17:44 GMT

@gregl_sas helped me nicely with my SCL question:

https://communities.sas.com/t5/New-SAS-User/Using-SCL-to-prevent-entries-already-in-dset-through-PROC-FSEDIT/m-p/499945#M251

Maybe this person can have a look at this question, too.

Re: Variable is not defined or does not exist. GetVarc Help_Needed

mdlucas1 — Fri, 25 Jan 2019 15:31:15 GMT

Thanks for the attempts, @pink_poodle !

Re: Variable is not defined or does not exist. GetVarc Help_Needed

gregl_sas — Fri, 25 Jan 2019 16:02:38 GMT

There are a couple things happening with the GETVARC function in your code:

1 - The way you have the GETVARC function defined:

TestField1=getvarc(FieldTest,varnum(FieldTest,field1));

This code is expecting the FIELD1 variable in the VARNUM function to be a character value. The way that you have this coded, FIELD1 is a variable that would need to contain the character value 'field1'. So, your GETVARC statements should look like this:

TestField1=getvarc(FieldTest,varnum(FieldTest,'field1'));

2 - Just making the above change is not enough to make the code work though (you will get a different error message). With the GETVARC/N functions, you need to make an observation from the table available. This is done with the FETCH or FETCHOBS function. So, the code after your SUBMIT block would need to look like this:

...

endsubmit;

refTest='work.TestCount';
FieldTest=open(refTest,'u');

rc=fetch(FieldTest);

TestField1=getvarc(FieldTest,varnum(FieldTest,'field1'));/* <-- ERROR IS STOPPING PROGRAM HERE */
TestField2=getvarc(FieldTest,varnum(FieldTest,'field2'));
TestField3=getvarn(FieldTest,varnum(FieldTest,'field3'));

Let me know if you have any problems or questions.

Thanks,

Greg

Re: Variable is not defined or does not exist. GetVarc Help_Needed

mdlucas1 — Fri, 25 Jan 2019 16:55:42 GMT

Hi Greg,

This worked perfectly. Thanks so much!