How to Check, if the variable exists in the SAS dataset or not
How to check if a variable exist or not: In SAS sometimes, we need to check whether the variable is exist in the dataset or not, we usually run the proc contents program and physically check if the variable exist in the dataset or not. If we want to check it programmatically, then use the following code.... Sample dataset: data old; input ID SCORE1 SCORE2 SCORE3 SCORE4 SCORE5 SCORE6; cards; 24 100 97 99 100 85 85 28 98 87 98 100 44 90 60 100 97 69 100 100 100 65 100 98 100 93 90 100 70 99 97 100 100 95 100 40 97 99 98 49 100 95 190 100 99 97 100 100 90 196 100 100 99 100 100 100 210 98 85 88 90 80 95 100 ; run ; data _null_; dset= open ( ' old ' ); call symput (' chk ',varnum ( dset ,' SCORE4 ')); run ; %put &chk; RESULT:5 Here I have used both OPEN and VARNUM functions in the program to check if SCORE4 variable exists in a 'OLD' dataset. The OPEN function opens a SAS data set and the VARNUM function, which returns the variable's position ...