It was mentioned that YrMth was originallly CHAR 200 in reply to Reeza. ... View more

Thank you; how can I do this in proc sql step ? Because I want to include it in a proc sql table I need to run without creating a separate data set. proc sql; substr(a.c_key,5) as cid from tableA a left join tableB b on a.cid=b.cid; quit; ... View more

Thanks. I will use this method to limit the number of datasets that show up on my Project. Seems like this option is local to the user that have set this limit.    If my another colleague run the same script without this Limit the limit is not applicable ... View more

Merci @Quentin. I really like your option to redirect the log into EG. Brillant. It is a good alternative but SAS EG should think of a way to avoid rewriting the log elsewhere in order to keep all our steps. ... View more

Thank you, this helped! ... View more

one more "safety vault" came into my mind, also adding: &&dslist&n(keep=code) would prevent "type mismatch" for other variables.   Taking all into account something like this macro wrapper: %macro findVarVal(variable, value, type=char); %local n len; data _1; &variable.=" "; run; data _2; &variable.=.; run; proc sql noprint; select catx(".",libname,memname) ,max(length) into :dslist1-, :len from dictionary.columns where upcase(name) = %upcase("&variable.") and type="&type." ; %let n=&SQLobs; quit; /* %put &=N.; %put &=dslist1.; %put &=dslist2.; %put dslist&N.=&&dslist&N.; %put &=len.; */ data want; length dataset_name $ 41 &variable. %if &type.=char %then $; &len. ; set %do n=1 %to &n.; &&dslist&n.(keep=&variable.) %end; indsname=dsname ; %if &type.=num %then %do; where &variable. = &value.; %end; %if &type.=char %then %do; where &variable. = symget('value'); %end; dataset_name = dsname; keep dataset_name; run; proc sort data=want nodupkey; by dataset_name; run; %mend findVarVal; %findVarVal(code, CM8) %findVarVal(name, John) %findVarVal(age, 14, type=num) (not 100% bullet proof, but good enough) ... View more

@jebjur , @kschott - Now waiting for the "freeze column" feature to be added back in too! ... View more

Hi Paige,    If the score is the same, I would like to maintain the order of "Code" as it is in Have.   Facing an issue in a scenario where my data is -  HAVE -  data have; input id name $ score code $; datalines; 1 John 23 A05 1 John 26 A02 1 John 26 A01 2 Mark 21 A05 2 Mark 22 A05 2 Mark 23 A07 ; run; ID NAME SCORE CODE 1 John 23 A05 1 John 26 A02 1 John 26 A01 2 Mark 21 A05 2 Mark 22 A05 2 Mark 23 A07   WANT -    ID NAME SCORE CODE 1 John 26 A02 [ Same Order as Input ] 1 John 26 A01 1 John 23 A05 2 Mark 22 A05 2 Mark 23 A07   Using the solution you provided, the A01 is getting sorted & coming at the top, whereas I want to keep the order as it is when the score is equal.  ... View more

data qtr (drop=temp); input Period $; temp=input(trim(left(substr(period,3)))||left(substr(period,1,2)),yyq6.); newdt2=intnx('qtr',temp,0,'end'); format newdt2 ddmmyy10.; cards; Q12022 Q22022 Q32022 Q42022 Q12023 ; run; ... View more

Separate workspace servers from separate EG sessions will share SASUSER and all libraries defined with the same physical path. WORK is always individual for any session. ... View more

@jozumhannes wrote: I found a column in DI Studio. But in the DI Studio, you can not see in which dataset this column is used. So, thats why, I want to find the dataset in which this column is used. Just for my information: Is by variable meant column? And @Tom: I tried your Code. I think you understood me. But this Code doesnt work, I am getting following in the Log: *NOTE: Table WORK.FOUND created, with 0 rows and 18 columns.* And another question would be: I have many libraries. I dont know which one to take. Is there a way in which SAS goes through all the libraries? Not sure about how DI studio works.  If you want to check for variable names in datasets then you need access to the datasets.  PROC CONTENTS works on either a single dataset or a single library of datasets.  But the DICTIONARY.COLUMNS metadata table (which you also see as SASHELP.COLUMN view) has the variable names of all of the datasets in all of the currently active libraries.  So as long as your SAS session has access to all of the libraries you wont to search you can use that. proc sql; create table want as select libname,memname,name,type,length,format,informat,label from dictionary.columns where upcase(name)="MYVAR" ; quit; You will get 0 observations if no matches are found.   NOTE:  A report or some data integration step might USE a variable, but a dataset just HAS variables. ... View more

Here is a much better way of doing what you want: Proc sql; create table DATE_TEST as Select input(adjudication_dt_id, yymmdd8.) as adjudication_dt format = yyq6. From SummaryLookup; quit; ... View more

@jwilson  - Can you give some idea of how many datasets it takes before your EG users experience "unacceptable" slowness and how long do these programs run for overall?    I'd suggest that if user jobs take over 30 minutes to run or output hundreds of datasets or are run on a regular basis then you should consider running these as batch jobs which will obviously remove any EG overheads entirely. In my experience, providing power users SAS Management Console so they can easily create and run their own batch jobs is well worth the effort.   Also it might be worth engaging SAS Tech Support to do more analysis on EG performance bottlenecks.   ... View more

First step check if the shared network path \\shared\dept\reports\  is accessible from your Linux machine . You can run the following code to see if the shared network path is accessible libname testlib "\\shared\dept\reports\"; If the library is created you have access otherwise not. In all probability it will be it will be a no. Speak to your Linux Admins / Steams to have the shared file system mounted  on the Linux Server with write access. If this does not happen then SCP  or FTP clients will be the only feasible options.   ... View more