About ShenQicheng

ShenQicheng · ‎11-15-2022

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

ShenQicheng · ‎11-14-2022

I'm running SAS Studio Engineer.

ShenQicheng · ‎11-14-2022

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.

ShenQicheng · ‎12-12-2018

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

ShenQicheng · ‎12-12-2018

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

ShenQicheng · ‎04-24-2018

@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

ShenQicheng · ‎04-24-2018

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

ShenQicheng · ‎04-18-2018

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

ShenQicheng · ‎04-17-2018

As Reeza said, please post your code directly into the forum in text format.

ShenQicheng · ‎04-17-2018

Try Group by QWHSSSID, SYSTEM_DATE instead of Group by QWHSSSID, DATEPART(SMFTIME)

ShenQicheng · ‎04-17-2018

Can you provide a code sample and the results that can describe you problem?

ShenQicheng · ‎04-17-2018

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;

ShenQicheng · ‎10-17-2017

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

ShenQicheng · ‎10-15-2017

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

ShenQicheng · ‎10-13-2017

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

Online Status	Offline
Date Last Visited	‎11-16-2022 03:13 AM

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

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

How to customize custom steps on SAS Viya SAS Studio

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

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

Re: change project.XML from SAS EG within SAS

Re: change project.XML from SAS EG within SAS

Re: Nested Loop and splitting

Re: How to Sum Vertically

Re: How to Sum Vertically

COVID-19 Vaccination Distribution & Efficacy Tracker

Re: Introducing SAS Enterprise Guide 8.1!

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

Re: How to create metadata libraries, apply ACT on ACT using batchtool...

Re: SAS起動時のシステムオプション

Re: return number of months between 2 dates

Re: VPN report viewer endless wait

Re: Failure in running EG 7.1

Re: sas data viewer custom task format issue

COVID-19 Vaccination Distribution & Efficacy Tracker

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

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

How to customize custom steps on SAS Viya SAS Studio

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

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

Re: change project.XML from SAS EG within SAS

Re: change project.XML from SAS EG within SAS

Re: Nested Loop and splitting

Re: How to Sum Vertically

Re: How to Sum Vertically

Re: How to Sum Vertically

Re: Select by ID the most recent occurance

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

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

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

SUGA