Hi @odrisco4    You'll need to fix your use of the folder separator and macro definition %let home = /home/<my username>; * Remove trailing /; filename Totals “&home/Totals.csv”; * Use / instead of \; ... View more

Hi @alepage  if you are trying to pass this value over to Snowflake and use it there, then you may want to look at this SAS/ACCESS Interface to Snowflake https://documentation.sas.com/doc/en/pgmsascdc/v_046/acreldb/n1d5j8d7wegfezn1irjj3hcrne1n.htm   Hope this helps ... View more

Hi Elena,   If you couldn't get the required utilization information from your SAS system/deployment, you can find most of these information in SnowFlake 🙂 SnowFlake provide Access_History view that you query to get the information you are looking for. https://docs.snowflake.com/en/user-guide/access-history#querying-the-access-history-view   Here is an article that will help you with drawing a Column & Table Lineage diagram out of your queries https://medium.com/snowflake/how-to-visualize-the-data-lineage-graph-in-snowflake-f0a356046380   Depending on the version of SnowFlake your organization is using, SnowFlake in their most recent/scheduled release, will include Cost Optimization - https://www.youtube.com/watch?v=ETrd6VFY3JY - https://www.youtube.com/watch?v=up3bTjrBvTA&list=PLavJpcg8cl1Epd5ziAjdpvkO9NyzVgsy-   You may want to look at how to optimize your Snowflake queries too in order to reduce your Total Cost of Operation - https://www.youtube.com/watch?v=eRQf4RvjPWM   Hope this helps, Ahmed ... View more

Hi @river1    Try using the attached macro which I developed to reduce the disk storage consumed by SAS data set(s) without compression! compressing SAS data sets, would increase CPU time, as the data would have to be decompressed when read and recompressed  when written out.   You can try it out with a sample/fraction of your large data set(s) to see what impact it yield on the final disk consumption.   Have a look at this  formally known as "SAS Global Forum" paper Twenty Ways to Run Your SAS® Program Faster and Use Less Space By Stephen Sloan, Accenture He provides several ways to preserve space when dealing with large SAS data sets.   Hope this helps, Ahmed ... View more

Hi @Emma2021 , You may want to invest in a Search Indexing Tool for your Windows Documents. These tools are purpose built, and they probably do their job much better than custom SAS hand coding. Here is a example of such tool: https://docfetcher.sourceforge.io/en/index.html (Disclaimer: I've never used this before, but long time ago, I've used a similar indexing tool for searching through my saved docs)  https://en.wikipedia.org/wiki/Desktop_search https://sourceforge.net/software/desktop-search/   Hope this helps, Ahmed ... View more

@JBailey Glad to hear and best of luck with all you are doing. I don't have any specific requirements/requests! I'm mainly trying to keep my finger on the pulse where possible. 😊  ... View more

Schema == domain  (SPDS User Guide): https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/spdsug/p1tofgu13wdlcan1gl7mavwhmx8y.htm   Here is how domains are defined (SPDS Admin Guide): https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/spdsag/n0nhzqn43hpeb6n1ucu1vo689zd4.htm   ... View more

Hi @KIIMCL  Not sure which documentation you have followed, but I hope this Data Administration Guide link https://documentation.sas.com/doc/en/bicdc/9.4/bidsag/n0a7lt4p1l4nhwn19fhqb4yam90f.htm provide you with better steps towards your resolution.   Hope this helps, Ahmed ... View more

Hi @W1ndwaker  If you are using Base SAS, then this feature is not available out of box and you'll have to fudge it somehow. Here is a response from 2018 about the same request code to implement row level security to data set using enterprise guide  Alternatively, you may want to try out SAS Federation Server if that's an option?   Hope this helps ... View more

Hi @Julie4435637  Check out this paper if you want to see SQL implementation for first. & last. Advanced Programming Techniques with PROC SQL If you are trying to apply the SQL to a third party Relational Database such as Teradata/Oracle to name few, you may need to check this paper  Your Database Can Do SAS® Too!   Hope this helps, Ahmed ... View more

Hi @kumarsandip975  The Stored Process by design is tightly coupled with  the SAS Metadata Server, because you can integrate and run STPs (Stored Processes) from within various Client Apps provided by the SAS EBI/BI (Enterprise Business Intelligence) Platform. Therefore having the correct metadata associated with STPs, allows for greater authorization/access control. Having said that, STPs are old school now, there are no more development being done for EBI/BI, and in SAS 9.4 M8 (Latest release), Few of the EBI components were deprecated/retired!  SAS Viya Job Execution Web App are the latest and greatest replacements for Stored Processes and the Prompting Framework from the SAS 9.4 era.   If dealing with metadata is not your thing, and you are trying to avoid it all together!! then SASjs Server might be your alternative!? Have a chat with @AllanBowe he can guide you through it.   Hope this helps, Ahmed ... View more

@luvscandy27  Hmm!, In this case I would double check the formats catalog in the WORK library, to ensure the $subs. format is created correctly.  You might as well test it on a different data set. ... View more

Check the fmtsearch option in your SAS 9.4 Display Manager. Proc options option=fmtsearch; run; if WORK is not part of it, then add WORK library to the option settings ... View more