About JayCorbett

JayCorbett · ‎03-31-2015

Could you post some sample data? Is the "Applicable Value" variable the same or different in the two data sets?

JayCorbett · ‎03-24-2015

I should have been more complete with my answer. if cat1s1, cat1s2, cat1s3, cat2s1, cat2s2 were declared in a %GLOBAL statement. Then to test for existence you could use %If &&CAT1S&i^=%str() OR %If %Length(&&CAT1S&i)>0. Also, you'll be happier if you %LET &CAT1=&&CAT1S&i; Then referencing it is not so tedious....

JayCorbett · ‎03-21-2015

An alternate method is to put the macro variable names in a %GLOBAL statement. Then you can simply test with %IF or %LENGTH statements.

JayCorbett · ‎03-21-2015

I realize that the core problem has been solved, however (in the original code) since the macro vars were created in one macro but used in another, they need to be %GLOBAL.

JayCorbett · ‎03-21-2015

Choose the Options button (located below the Query name, on the right side). Under Query limits, check the box for Limit number of matching rows to process and set the number of rows.

JayCorbett · ‎03-20-2015

Alternatively, you can do a query builder task and arrange the variables, in the output data set, in any order you want. By right-clicking where the variables are listed, in the query builder task, you can arrange the variables names in ascending or descending order also.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Issue with merging data

Re: how to check if a macro variable exists....

Re: how to check if a macro variable exists....

Re: to_date

Re: How to locate a variable in a SAS data opened under EG window?

Re: How to locate a variable in a SAS data opened under EG window?

Re: How to locate a variable in a SAS data opened under EG window?

Re: to_date

Re: Issue with merging data

Re: how to check if a macro variable exists....

Re: how to check if a macro variable exists....

Re: to_date

Re: How to locate a variable in a SAS data opened under EG window?

Re: How to locate a variable in a SAS data opened under EG window?