This paper may inspire you https://lexjansen.com/nesug/nesug10/bb/bb05.pdf ... View more

If you are interested in making the Report a bit fancy, you might want to look into the  ODS Report Writing Interface  Check the examples section http://support.sas.com/rnd/base/ods/Tipsheet_RWI.pdf   Hope this helps, Ahmed   ... View more

Depending on your SAS version, this code may work for you %let date=&sysdate; data src_&date; NAME='Some Name'; ADDRESS='Some Address'; PRODUCT='Some Product'; COL_A='Y'; *COL_B='Y'; run; %let g_dynWhere=; options mprint; PROC SQL NOPRINT; SELECT STRIP(name)||"='Y'" INTO :g_dynWhere separated by ' OR ' FROM dictionary.columns WHERE libname='WORK' AND memname=upcase("SRC_&DATE") AND name LIKE 'COL_%' AND memtype='DATA'; /*%put &=g_dynWhere;*/ CREATE TABLE TBL_&DATE. AS SELECT NAME, ADDRESS, PRODUCT FROM SRC_&DATE. %if (%superq(g_dynWhere) NE ) %then %do; WHERE &g_dynWhere %end; ; QUIT; Back in 2018, @ChrisHemedinger posted the following Blog about SAS 9.4 M5. The code above would examine the structure of your source table and dynamically build the condition. That condition then in turn, would conditionally be used in the Create Table Query.   Hope this helps, Ahmed   ... View more

Thanks, Will keep it in mind 🙂 ... View more

@JMS  Your reply plays straight into my point. Your SAS administrator needs to update his/her skills in order to satisfy the users needs and provide functional environment. Your SAS Admin should know your SAS Order Inventory (What products included/licensed) and Deployment Typology (Which SAS components installed where) --> Look back at the papers I sent you earlier.   Myself and others on this forum, can suggest all sorts of potential solutions/ways, but without exact knowledge of what your company has licensed and which & where the components are installed. That's why I told you to contact SAS Tech Support, because they can use your site number to extract your Software Order and figure out which products are licensed to your company.   Ahmed        ... View more

Hi @JMS  So here is my personal take on this - If you are a user, then it's really the responsibility of your organization/department/branch/team designated SAS Administrator to provide users with a Functional SAS environment (Properly set-up and running) On-Boarding detailed steps (such as, How to create Connection Profile in EG) Users should not take matter in their hands and try to operate server(s) and services! There should be clear separation of duties. I think you would be better served by finding out, How your company manages their SAS environment? Who is responsible for the up keeping of SAS  --> Once you find out, ask them for the correct way to connect! Anything beyond this, you'll need to contact SAS Technical Support    Good luck, Ahmed   ... View more

Couldn't be more clearer than this! ... View more

Did you modify & run/submit the createdata.sas file? ... View more

@Abastaki  First - Check the setting on your SAS University Edition Virtual machine   Second - Within SAS Studio, Check the properties of your "My Folder"   Third - Ensure using correct paths in your libname statements, based on the information gathered from the above two pics i.e. Physically on my Personal desktop, I have placed all my SAS related files under This PC\Documents\SASUniversityEdition\myfolders\....... In SAS Studio that would translate to /folders/myfolders/...... Therefore, as long as you have physically placed all your SAS related contents under C:\.....\myfolders\, you can reference it in SAS Studio as /folders/myfolders/<DirectoryName>/<file name> Your pg1 library has to be defined as LIBNAME pg1 "/folders/myfolders/EPG1V2/data"; I think, you'll need to open and modify This PC\Documents\SASUniversityEdition\myfolders\EPG1V2\createdata.sas and make sure to use the same path as in the above libname statement, in order to create the sample data sets there.   Hope this clarify it for you. Ahmed ... View more

in SAS Studio, Click on the "Servers Files & Folders" in the Left Navigation Panel, then browse down to the folder of your course programs, double click on the *.sas file, that will open it in SAS Studio, then you submit it   Hope this helps, Ahmed  ... View more