cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
niteshbharadwaj
‎12-25-2018
  • 9 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: A macro to check whether a variable is blank or not in the dataset

by Fluorite | Level 6 in SAS Programming
‎12-21-2018 07:16 AM
‎12-21-2018 07:16 AM
even after correcting still the error exists.   please help ... View more

Re: A macro to check whether a variable is blank or not in the dataset

by Fluorite | Level 6 in SAS Programming
‎12-21-2018 02:24 AM
‎12-21-2018 02:24 AM
Hi ,   My problem almost got solved but while implementing the macro these are the below errors am receiving     6 proc contents data=&ds out=&temp(keep=name type) noprint; run; proc sql noprint; select count(*) into :nCount from &temp. where up case(name)="%upcase(&var)"; quit; _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, CONNECTION, DICTIONARY.   Thanks & Regards Nitesh ... View more

Re: A macro to check whether a variable is blank or not in the dataset

by Fluorite | Level 6 in SAS Programming
‎12-21-2018 01:16 AM
‎12-21-2018 01:16 AM
This is my macro looks      %macro varexist(ds=,var=); %local dsid rc ; %let dsid = %sysfunc(open(&ds)); %if (&dsid) %then %do; %if %sysfunc(varnum(&dsid,&var)) %then 1; %else 0 ; %let rc = %sysfunc(close(&dsid)); %end; %else 0; %mend varexist;       but here i want to check whether varaiable has null values or not instead of existing  ... View more

A macro to check whether a variable is blank or not in the dataset

by Fluorite | Level 6 in SAS Programming
‎12-21-2018 12:37 AM
‎12-21-2018 12:37 AM
  Hi Team,   could you please help me knowing how to write a macro which reads a data set and corresponding variable and checking whether variable is blank or not.   for example;  %macro varcheck (dataset=,varaiable=)     %mend ... View more

Re: checking null values for the variables

by Fluorite | Level 6 in SAS Programming
‎12-19-2018 05:55 AM
‎12-19-2018 05:55 AM
please find the sample data   data abcd; input memname $ name $ libname $; cards; x1 v1 l1 x1 v2 l2 x2 v3 l2 x3 v4 l1 ; run;     expected output: data abcd5; set abcd; status2=0; run;     here x1,x2,x3 are datasets corresponding to  libraries l1 and l2  we want to check whether var v1 in dataset x1 is null or not     kindly accept apologies in case of inconvenience ... View more

Re: checking null values for the variables

by Fluorite | Level 6 in SAS Programming
‎12-19-2018 04:45 AM
‎12-19-2018 04:45 AM
My dataset abcd has 3 coloumns:   memname  name   libname x1                 v1        lib1 x1                  v2       lib1 x2                 v3         lib2 x3                 v4          lib1   This is how my dataset abcd looks like, here memname varaible consists of list of datasets i.e. x1,x2,x3 are datasets name variable consists of list of variables associated to it.   how to check whether varaiable v1 of dataset x1 is null or not. Repeating the same process till end of the table.   and popultae a field status =0 for null and status =1 for not null in abcd dataset again ... View more

checking null values for the variables

by Fluorite | Level 6 in SAS Programming
‎12-18-2018 11:43 PM
‎12-18-2018 11:43 PM
Hi All,   I have a dataset which consists of 3 columns name,memname and libname  memname consists of list of datasets and name consists of list variables associated to corresponding to dataset. Kindly help me how to check whether the value of variable to particular dataset is null or not and populate a status varaible coulmn if value exists to a variable only there are two libraries ex. memname: x1,x2,x3 name: v1,v2,v3 libname: l1,l2,l1   how to check whether vi is null or not ... View more

Print multiple datasets with same datasets name and different librarie...

by Fluorite | Level 6 in SAS Programming
‎06-21-2018 06:13 AM
‎06-21-2018 06:13 AM
Hi Folks,   I have two libraries named in1 & in2 both consist the datasets with same naming convention .For eg: test1 & test1 i.e in1.test1 & in2.test1. Though the naming convention is same fields inside the datasets may or may not differ.   suppose I have added two fields named age and place in the source file. and they will reflect in both the datasets with same or different values ,because they might be separated on basis of key identifiers.   Could you please help me how to find the values for added fields w.r.t to library in the same sas program.   Thanks Nitesh   ... View more

concatenating the data sets with previous day

by Fluorite | Level 6 in SAS Programming
‎02-14-2018 02:16 AM
‎02-14-2018 02:16 AM
Hi Folks I am working on a small automation of manual testing in SAS ,we primarily take data sets from different directories and validate the field in the data sets. so ihave taken two libraries in one sas code for example libname in1 "/path1" libname in2 "/path2" and saved them in test.sas and saved them in output library my output datasets in libraries will in the following format 1)test021318 2)testa021318 3)testb021318 in all libraries in1,in2 the names of datasets will be same but only paths will differ . so to make the testing process bit easier and generic i have written a small snippet like this %include "/path/output/" ;----where libraries are stored in one file   %let x = %sysfunc(cats(test,%sysfunc(intnx(day,%sysfunc(today()),-1),mmddyy6.))); %let y = %sysfunc(cats(testa,%sysfunc(intnx(day,%sysfunc(today()),-1),mmddyy6.))); %let z = %sysfunc(cats(testb,%sysfunc(intnx(day,%sysfunc(today()),-1),mmddyy6.))); libname out "/path/output/"; %put &x &y &z; data out.final; set in1.&x in1.&y in1.&z in2.&x in2.&y in2.&z ; run; proc print data=out.final; run; but my output is printing like this ERROR: File IN1.test21318.DATA does not exist. ERROR: File IN1.testa21318.DATA does not exist. ERROR: File IN1.testb21318.DATA does not exist. ERROR: File IN2.test21318.DATA does not exist. ERROR: File IN2.testa21318.DATA does not exist. ERROR: File IN2.testb21318.DATA does not exist.   but in actual output locations datasets will be in the following format test021318.sas7bdat testa021318.sas7bdat testb021318.sas7bdat   dataset will be with previous day could you kindly help me in achieving the desired result. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-25-2018 08:24 AM
Likes given to
View All
Quick links