About ANLYNG

ANLYNG · ‎08-19-2016

hoW can i disconnect metadata in EG? and connect again?

ANLYNG · ‎08-19-2016

I want to see all columns in sas tables,table name and libname.I get an error like below: Is there a work around or al alternative to get this information (the table from dictionary show the same error). Alternative can I ask the metadata server ? and how (code example is appreciated). Thanks in advance. 23 proc sql; 24 create table XXXX AS 25 select libname, memname, name, type from 26 27 sashelp.VCOLUMN; ERROR: Incorrect length in SAS Metadata Repository for column initial_1.

ANLYNG · ‎08-18-2016

i suppose it is possible to put it into the same step eg. if not first.library. i have to read on proc execute. looks very smart...

ANLYNG · ‎08-18-2016

but as far i can test it only takes the first library and not the following. ...

ANLYNG · ‎08-18-2016

Look really nice-thank you very much......it helps me....

ANLYNG · ‎08-18-2016

the idea is that the input (libane, data and label) is dynamic and read from a data set and used inside proc datasets.

ANLYNG · ‎08-18-2016

What I was thinking was to make this dynamically. I have putted the classification variable into a SAS dataset. In this structure: library table type contact XXX x Area_X Unit_U YYY z Area_X Unit_Z And wish to loop these variables and use like this: proc datasets lib=&library. nolist; modify table_&table.; xattr add DS Type=&type.; xattr add DS Contact=&contact.; run; Do you have some ideas to make it smart?

ANLYNG · ‎08-17-2016

I wish to make it more dynamically. eg. do you have an example if i put the classification in an variable in a data set (together with dataset name) and how to loop it into a dynamic macro variable which rund through the data set?

ANLYNG · ‎08-16-2016

Hi, Is it possible to select more than one dataset in proc dataset??? eg. dynamically? I want to put the same attrubutes and labels on a list of data (the list of the data is in a SAS datasæt). All ideas to get the job done are appreciated. I thinkt the code somthing like this - but it fails .... proc datasets lib=XXX nolist; modify table_x table_y ; xattr add DS Type="Area_X"; xattr add DS Contact="Unit_U"; run; Thanks in advance. Rgrds, Annette

ANLYNG · ‎06-26-2016

Thank you very much. It did help and it looks nice. I am very happy thanks.

ANLYNG · ‎06-23-2016

I got a stored process with a lot of macro parameters. But I can not get it to work properly. The parameters does not work in the selection. Can you see what is wrong and why the paramters will not work???? it is especially the two date macro parameters: "&fradato."d and "&tildato."d Some code from the stored process: %macro udtrak; data idataperiode fordataperiode; set test; %if %nrquote(&banavn) eq ' ' or %nrquote(&banavn) eq _ALL_VALUES_ %then %do; if transaction_date_d >="&fradato."d and transaction_date_d <="&tildato."d and regime_number in("&ordning") then output idataperiode; if transaction_date_d < "&fradato."d and regime_number in("&ordning") then output fordataperiode; %end; %if %nrquote(&fsnavn) eq ' ' or %nrquote(&fsnavn)eq _ALL_VALUES_%then %do; if transaction_date_d >="&fradato."d and transaction_date_d <="&tildato."d and regime_number in("&ordning") and ba_id in("&banavn") then output idataperiode; if transaction_date_d <"&fradato."d and regime_number in("&ordning") and ba_id in("&banavn") then output fordataperiode; %end; %if %nrquote(&fsnavn) ne ' ' and %nrquote(&banavn) ne ' ' %then %do; if transaction_date_d >="&fradato."d and transaction_date_d <="&tildato."d and regime_number in("&ordning") and ba_id in("&banavn") and focusarea_id in("&fsnavn") then output idataperiode; if transaction_date_d <"&fradato."d and regime_number in("&ordning") and ba_id in("&banavn") and focusarea_id in("&fsnavn") then output fordataperiode; %end; %mend udtrak; run; %udtrak;

ANLYNG · ‎04-17-2016

Hi , We have testet a lot of possibilities on basis om the solutions mentioned here. The clue to the solution was the metadata respository. We got a macro from SAS Support which helped us to retrieve the information from the SAS meatadata respository by SAS code. Thank you all for you replies.

ANLYNG · ‎04-17-2016

Hi , We have testet a lot of possibilities on basis om the solutions mentioned here. The clue to the solution was the metadata respository. We got a macro fro SAS Support which helped us to retrieve the information from the SAS meatadata respository. Thank you all for you replies.

ANLYNG · ‎04-11-2016

it should help me in planning my job flows so they are distributed in a effective manner. Start og endtime.

ANLYNG · ‎04-11-2016

Hi, We are currently using SMC for scheduling jobs. We build our job flows via Schedule Manager plug-in for SAS Management Console and it runs on a HP unix. Do anyone know if or where the information about job flow name and contained jobs are stored ? thanks in advance.

Online Status	Offline
Date Last Visited	‎09-12-2023 06:32 AM

Opgrade OS in place with Viya 3.5

size of metadata objects sas 9.4

Hotfix server and/or sas clients

Re: SAS data Integration minimize ressource use

SAS data Integration minimize ressource use

Use subflow - SAS Management Console optimizing memory use

sas(linux) command code to put recursive and multiple files on an SFTP...

sortseq information server client

Re: List of files in a directory filename, timestamp, size

Re: List of files in a directory filename, timestamp, size

Re: Opgrade OS in place with Viya 3.5

Re: Opgrade OS in place with Viya 3.5

Re: size of metadata objects sas 9.4

Re: unzip files from SAS in a loop

Re: unzip files from SAS in a loop

Anti-virus exclusions recommendation Viya Windows

Re: Replace emty char variable with a text string

folder architecture and security -recommendations

Re: SAS visual analytics autoload data in subfolders

SAS visual analytics autoload data in subfolders

Re: list with columns in sas tables,table name and libname! VCOLUMN - ...

list with columns in sas tables,table name and libname! VCOLUMN - but ...

Re: proc dataset select 2 or more datasæt?

Re: proc dataset select 2 or more datasæt?

Re: proc dataset select 2 or more datasæt?

Re: proc dataset select 2 or more datasæt?

Re: proc dataset select 2 or more datasæt?

Re: proc dataset select 2 or more datasæt?

proc dataset select 2 or more datasæt?

Re: Problems STored Proces macro parameters

Problems STored Proces macro parameters

Re: job flows and job relation

Re: job flows and job relation

Re: job flows and job relation

job flows and job relation