Thanks, but I need to encode only one variable in dataset, I use SAS 9.1.3. I need something like function or format. I know that there's needed format, but it's available starting from SAS 9.2. Does anyone know a way to do it in 9.1.3 ?
... View more
Hi all, I use query syntax with XMLSelect and Templates where I filter query by metadata type and attribute together in Templates like this: <GetMetadataObjects> <Reposid>$METAREPOSITORY</Reposid> <Type>Document</Type> <Objects/> <NS>SAS</NS> <Flags>388</Flags> <Options> <XMLSelect search="*[@Name ? 'Customer']"/> <Templates> <Document Id="" Name="" TextType=""> <ResponsibleParties search="ResponsibleParty[@Role='OWNER']"/> </Document> </Templates> </Options> </GetMetadataObjects> It doesn't search existent ResponsibleParty object. The same situation if I try to use filter by assosiation. If I use attribute filter only - it works well: <XMLSelect search="*[@Name ? 'Customer']"/> <Templates> <Document Id="" Name="" TextType=""> <ResponsibleParties search="@Role='OWNER'"/> </Document> Is there anybody who can help me with explanation why it doesn't search with combined fiters in the <Template>? (I have SAS 9.1, while using OMI documentation for 9.2 - but I haven't found such restrictions for 9.1)
... View more
Hi. Have an issue with DI studio while building big jobs (big - in terms of number of transformations used). After some number of transformations added I find impossible to add new ones, and also I can't edit existing ones. Maybe there are limits on number of transformations used in job?
... View more
Hello, anybody knows how to check if macro variable's length exceeds max length (65534) while select into runs?
E.g.
proc sql;
select x into :y separated by " " from z;
quit;
Macro var Y is always created nevertheless its lenght, but when I'm trying to use it further it, of course, invokes an error if length is more than 65534
... View more