Initially Worked with humana on health care and life scince project on SAS reporting, Currently Working With Barclays technology centre india on capital and credit risk reporting.
Base SAS, SAS/Macro, SAS Data Integration, Unix, CRMS 4.2
Also, do you have ALLOWXCMD available in your environment? What happens if you run this code (adjust if you're running Linux): filename dirlist pipe "dir /b /s \\sascs\linkage\RL_content_snapshots";
data dirlist1;
infile dirlist lrecl=256 truncover;
input;
filename=_infile_;
run;
* or ;
filename dirlist pipe "powershell ""Get-ChildItem -recurse \\sascs\linkage\RL_content_snapshots | ForEach-Object {$_.Fullname}"" ";
data dirlist2;
infile dirlist lrecl=256 truncover;
input;
filename=_infile_;
run;
... View more
Hi, I'm using sas studio 3.5 in windows. I have tried the "Libname mylib clear" and it was successfull. Opened a new sas session and I can't see that library that has been deleted. Now created library with the same but I haven't got any warnings/error? Just curious about what could be the implications if we delete library using clear command and recreate those libraries again? Best krisraa
... View more
Thanks KurtBremser, For your suggestion, thats real helpful. Thanks Jaap Karman for your suggestion, i will go through that link and will take care of complete review of current system.
... View more
yeah thats i am trying now with below code, I am trying to list every cluster table present in my library to see in which cluster table that member table is present. Thanks Again LinusH. proc spdo library=test1; cluster list X_abc/VERBOSE; QUIT;
... View more
Hi Anna, Thank you so much for your reply. This would be really helpful at any stage from bottom to top. If i would get stuck at any stage, i will come back to you ..... for sure. Regards Uma Shanker Saini
... View more
The following will give you the location of the dataset CLASS in any library that has been established in your current SAS session, be it as part of the log on process or one you have set up yourself, and is still in effect. PROC SQL; CREATE TABLE WANT AS SELECT LIBNAME FROM DICTIONARY.TABLES WHERE UPCASE(MEMNAME) = 'CLASS'; QUIT; If you wish to know if the dataset appears in any location accessible by SAS, e.g. any subdirectory on a network, then this is a completely different animal and will require something more sophisticated. Regards, Scott
... View more
Hi MaheshPeesari, Can you tell me where actually you are using this stored process? I mean are you accsing this in SAS WRS or Information Delivery portal? As per my understanding textbox length and all can not be set in STP wizard however you can create a dependant prompt using Stored Process. Check this below link http://analytics.ncsu.edu/sesug/2011/BB11.Droogendyk.pdf Regards, Tushar J.
... View more
