cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ShenQicheng
‎11-16-2022
  • 42 Posts
  • 19 Likes Given
  • 2 Solutions
  • 5 Likes Received

Re: How to customize custom steps on SAS Viya SAS Studio

by Obsidian | Level 7 in SAS Studio
‎11-15-2022 05:42 AM
‎11-15-2022 05:42 AM
Thanks @DJongman .   I do know how to create custom steps and add them to flow. I'm asking for solutions for the points that I listed in my first post that can not implement (or I don't know how) on the current version of SAS Studio    ... View more

Re: How to customize custom steps on SAS Viya SAS Studio

by Obsidian | Level 7 in SAS Studio
‎11-14-2022 09:10 PM
‎11-14-2022 09:10 PM
I'm running SAS Studio Engineer. ... View more

How to customize custom steps on SAS Viya SAS Studio

by Obsidian | Level 7 in SAS Studio
‎11-14-2022 07:10 AM
‎11-14-2022 07:10 AM
Hi, I'm migrating Enterprise Guide custom task to SAS Studio and find that the best solutiong is to create a custom step with the same UI. Using SAS Studio custom task is not an option because it can not be added to a SAS Studio flow.   Here are my challenges, when a column in a column selector control is selected, user can set some additional properties that is needed when generating sas code. the step has two input data and user can set the join conditions columns of the output data can be inherited from either of the input data or be calculated using input data These functions are implemented on EG custom task by using c#. On SAS Studio these can be done by combining some built-in steps with simple custom steps, but is it possible that I can create my own controls so I can implement all these functions in one step, so that user can do all these in a single custom step?   I am using Viya 2022.1.     ... View more

Re: Five papers on Recommended SAS 9.4 Security Model Design (part 2 o...

by Obsidian | Level 7 in SAS Communities Library
‎12-12-2018 09:33 PM
‎12-12-2018 09:33 PM
Thank you @DavidStern. I can understand the reasons. It seems that I should try harder to do it by myself, using SAS Open Metadata Interface server interfaces. Any advice will be very helpful.   Anyway, thanks for sharing the paper.   QC ... View more

Re: Five papers on Recommended SAS 9.4 Security Model Design (part 2 o...

by Obsidian | Level 7 in SAS Communities Library
‎12-12-2018 02:07 AM
‎12-12-2018 02:07 AM
Greate post! I'm not a sas employee, but is that possible that I can get the GEL Turbo tool mentioned in the paper?   QC ... View more

Re: change project.XML from SAS EG within SAS

by Obsidian | Level 7 in SAS Programming
‎04-24-2018 08:02 PM
‎04-24-2018 08:02 PM
@Billybob73 wrote: Shen / Kurt,   This is it ! By default it encodes to ANSI. with this option to utf 16.   Why does this not work when I tried this ?     filename zip pipe "zip  %superq(zipmap)\&zipfile %superq(zipmap)\*";   data _null_;     infile zip encoding="utf-16";     input;     put _infile_;   run; What is the purpose of this code? The usage of the unnamed pipe is not correct, I think. If you want to read files in a zip file within SAS code, you can try FILENAME ZIP access method.  There are several blogs writen by Chris Hemedinger show how to use FILENAME ZIP access method. Here are some URLs: https://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/ https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/   Hope this helps.   Shen ... View more

Re: change project.XML from SAS EG within SAS

by Obsidian | Level 7 in SAS Programming
‎04-24-2018 04:52 AM
‎04-24-2018 04:52 AM
Try this, data programds1; infile "g:\mylocation\project.xml" encoding="utf-16"; length progtext $32000; input; progtext = _infile_; run; and  data _null_; file "g:\mylocation\project.xml" encoding="utf-16"; set work.programds1; put (progtext) (+(-1)); run; Shen ... View more

Re: Nested Loop and splitting

by Obsidian | Level 7 in SAS Programming
‎04-18-2018 07:59 PM
‎04-18-2018 07:59 PM
Are you sure the code you posted can be executed without error? (It is highly recommended that you post your code with 'Insert sas code' commad so that it can be more readable.)   I can't run you code but I think the reason might be the macro call in the inner loop is only pushed into a stack and won't be executed until the data step is completed. Try 'call exectute' or 'dosubl'.   Shen ... View more

Re: How to Sum Vertically

by Obsidian | Level 7 in SAS Programming
‎04-17-2018 10:39 PM
‎04-17-2018 10:39 PM
As Reeza said, please post your code directly into the forum in text format. ... View more

Re: How to Sum Vertically

by Obsidian | Level 7 in SAS Programming
‎04-17-2018 10:14 PM
‎04-17-2018 10:14 PM
Try Group by QWHSSSID, SYSTEM_DATE instead of Group by QWHSSSID, DATEPART(SMFTIME) ... View more

Re: How to Sum Vertically

by Obsidian | Level 7 in SAS Programming
‎04-17-2018 09:09 PM
‎04-17-2018 09:09 PM
Can you provide a code sample and the results that can describe you problem? ... View more

Re: Select by ID the most recent occurance

by Obsidian | Level 7 in SAS Enterprise Guide
‎04-17-2018 07:39 PM
‎04-17-2018 07:39 PM
Maybe this works?   proc sql; create table t1 as SELECT confirmation_num, input(confirmation_page, best12.) as confirmation_page, ARRIVAL_DAY_KEY, DEPARTURE_DAY_KEY from MC_RESERVATION where DEPARTURE_DAY_KEY between 20180418 and 20180424 group by confirmation_num having confirmation_page = max(confirmation_page) ; quit; ... View more

Re: Change the default location for the Files folder under SASApp serv...

by Obsidian | Level 7 in SAS Enterprise Guide
‎10-17-2017 04:58 AM
‎10-17-2017 04:58 AM
For XCMD, my test on Windows server shows that WorkspaceServer_usermods.bat/sasv9_usermods.cfg(both under WorkspaceServer folder) overrides the setting in SMC.   Anyway, I agree the "Bottom line" you showed is the best practice to configure the SAS App server.   Shen   ... View more

Re: Change the default location for the Files folder under SASApp serv...

by Obsidian | Level 7 in SAS Enterprise Guide
‎10-15-2017 08:43 PM
‎10-15-2017 08:43 PM
Thanks,  KurtBremser   Yes, I do understand 'In any case, changes that can be made in SMC should be made there.' I just try to find out that, why I can override the XCMD setting in SMC by using WorkspaceServer_usermods.bat but I can not do that for the "Files" folder location setting. (First of all, does MYSASFILES environent variable still mean anything?)   Shen ... View more

Change the default location for the Files folder under SASApp server E...

by Obsidian | Level 7 in SAS Enterprise Guide
‎10-13-2017 04:00 AM
‎10-13-2017 04:00 AM
Hi,   I tried the method that was posted in following topic,but it doesn't work. https://communities.sas.com/t5/SAS-Enterprise-Guide/Change-the-default-location-for-the-Files-folder-under-SASApp/td-p/106484   My EG Version is 7.15, and according to the answer from SAS Technical Support, "specs has been changed since EG7.13, this method will not take effective any more.  You should config it in SAS Management Console".    Now I am wondering that, 1. Does MYSASFILES environent variable have nothing to do with the "Files" folder location now from EG7.13? 2. Is there a way that I can change the location but not using SMC (e.g. for XCMD I can set "Set USERMODS_OPTIONS=-XCMD" in WorkspaceServer_usermods.bat) ?   Anybody has any idea on this?   Shen   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-16-2022 03:13 AM
  • Contact User via Skype
Group Hubs for ShenQicheng
View All
Likes given to
View All
Likes from
Quick links