About valleet

LinusH · ‎01-13-2017

I'm not really following, what is the actual problem? When you define views corresponding SAS files are created but they contain no data, just the definition ("meta data"). Can't see any problem hee since those very light weight. The problem will problem will more likely to occur when calling your views, it's not very efficient to call the same table that many times, but that will show later...

Astounding · ‎01-05-2017

Yes, there is nothing in your code that would re-set those variables if the FIND fails. There are a couple of ways to go about this. (1) Before outputting to NONMATCHADMIN, hard-code statements that set these variables to missing. (2) Drop the variables from NONMATCHADMIN that should be missing: data MatchAdmin nonMatchAdmin (drop=list of some variables here);

Loko · ‎12-28-2016

Hello, Providing the substring (in your ex. col2) in the form of a variable means SAS adds the spaces which fill in the variable until thje length provided (in your example 20). Adjusting the code to test = find(col1,trim(col2)); will do it .

Online Status	Offline
Date Last Visited	‎07-10-2017 08:10 AM

Re: creating view in proc sql without the creation in work of the corr...

Re: creating view in proc sql without the creation in work of the corr...

creating view in proc sql without the creation in work of the correspo...

find method issue

Re: find function

find function

Re: creating view in proc sql without the creation in work of the corr...

Re: find method issue

Re: find function