About Babloo

Babloo · ‎05-19-2023

In the following code, I want to execute the where clause in proc print only if the macro variable 'filter' is 'y' otherwise it should not execute. %let target_table=&datasource; %global prompt; %filter ='y'; proc sort data= "&envPath/data/gb/&datasource" out=sorted nodupkey /*or noduprecs if sorting all vars*/; by &_field /* or list of vars */; run; proc print data= sorted noobs; where &parameter_1 in ("&parameter_2"); /** need help here to tweak this line to execute only when the macro variable 'filter' is 'y' */ var &_field; run;

Babloo · ‎05-18-2023

In the following code, I want to remove the duplicates. If I want to add proc sort or proc sql to remove duplicates then how to tweak this code? %let target_table=&datasource; %global prompt; proc print data="&envPath/data/gb/&datasource" noobs; where &parameter_1 in ("&parameter_2"); var &_field; run;

Babloo · ‎05-17-2023

@AhmedAl_Attar Were you can elaborate the point 3 which is, 'Within your JavaScript Function, get the value of the Environment and concatenate the path dynamically. I would guess SAS will place this parameter somewhere with your HTML Page and allow you to access its value via "$P_ENV$". Similar to how we did here '? I couldn't understand how SAS will pass the parameter value of "$P_ENV$". to HTML ? How to call this parameter in HTML?

Babloo · ‎05-16-2023

@AhmedAl_Attar I'd like to know how to dynamically use the path/folder name in HTML. In the following code, you can see that path name (/Environments/Dev/Jobs/html_job/prompts) is hard coded and it has the folder name called 'DEV'. This folder name is TEST and PROD, when we move this code to test and production environments respectively. I don't wish to manually correct this path when we promote this code to higher enviornments. What would be the efficient way to handle this? <div class="divTableCell"> <select name="_division_sel" id="_division_sel" class="jobexec_select" multiple hidden onchange="get_data('pf_ncnm_sel', '_division_sel', '/Environments/Dev/Jobs/html_job/prompts', 'DIVISION', 'SECTION', 'pt_div_map.sas7bdat' )"> <option value="Insurance">Insurance</option> <option value="Life">Life</option> <option value="NonLife">NonLife</option> <option value="Loan">Loan</option> </select> </div>

Babloo · ‎05-02-2023

@AhmedAl_Attar I came across the following articles today and I observed that we can use a rest API call to retrieve the distinct values of a column. from a SAS dataset. 'Proc http' does this it seems. I can try this later. Creating JES Prompts and Output Using the Viya Reports API - SAS Support Communities Executing a JES Job Using JavaScript - SAS Support Communities Now my question is how to embed (or add) the HTML code which I already wrote with the Proc http which I'm going to write?

Babloo · ‎04-25-2023

@AhmedAl_Attar I added this line Filename _webout "/ifrs/test/_webout.html"; on yesterday and it was working fine and I could see the html file in the mentioned location. When I executed the same code today, it ended up with error as shown below. Even I removed the HTML file from the location where it was created on yesterday and even I changed the path in Filename statement as well but still the same error. Any help? Filename _webout "/ifrs/test/_webout.html"; ERROR: At least one file associated with fileref _WEBOUT is still in use. ERROR: Error in the FILENAME statement.

Babloo · ‎04-24-2023

For me WORK path is /sastmp/... I don't know how to go to this path. I will check with SAS admin on this. In the same location we can see the generated HTML which you shown in your post? If not, where to see it? I know I'm asking many questions and I'm sorry for that.

Babloo · ‎04-24-2023

@AhmedAl_Attar How did you got the HTML code which you showed in your post? I executed the SAS code in SAS Studio based on your instructions and there is no error in the log now. However I could not see the result. May I know where to check the result?

Babloo · ‎04-24-2023

@AhmedAl_Attar thanks but still the other error persists. ERROR 180-322: Statement is not valid or it is used out of proper order. Log: 81 Filename _webout TEMP; 82 83 proc stream outfile=_webout quoting=both; 84 BEGIN 85 <html> 86 <body><title>Select Products</title><body> 87 %let rc =%sysfunc(dosubl( 88 proc sql noprint; 89 Figure 8. First Attempt to Include SAS Code in a SAS Server Page 90 11 91 select distinct 92 '<input type="checkbox" name="product" value="' 93 ||strip(product) 94 ||'">' ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

Babloo · ‎04-24-2023

@AhmedAl_Attar I connected with my manager and understood that we need solution using HTML, CSS and JavaScript with SAS Viya. I'm not sure how to move forward now as we identified the SAS Viya version issue earlier which prevented me to load values in the drop when I followed the reference article which you shared earlier

Babloo · ‎04-24-2023

@AhmedAl_Attar Still I get the same error when I tried to use Filename statement per your instruction. I kept the following line before proc steam. Filename sample '/home/babloo/test/_webout'; Even I tried this without any path, Filename sample '_webout'; Am I missing something?

Babloo · ‎04-23-2023

So if I add the following line, will it works? Filename sample '/ifrs/ins/_webout'; Apologies for shooting out numerous questions.

Babloo · ‎04-23-2023

I'm bit confused now. May I request you to clarify which method or the document to follow? As few suggested solutions were not working as I mentioned in the previous posts. Thanks again for staying with me.

Babloo · ‎04-23-2023

@AhmedAl_Attar I agree with you. Even I find easy to work with SAS Viya Task prompts but struggling fetch value from the SAS datasets to show in the prompts.

Babloo · ‎04-23-2023

@AhmedAl_Attar Thank you for the extended support. Those documents are helpful. It is evident that my task is not going to be easy. I just executed the following program in my SAS studio. I found this program in page 10 and 11 from https://support.sas.com/resources/papers/proceedings14/1738-2014.pdf proc stream outfile=_webout quoting=both; BEGIN <html> <body><title>Select Products</title><body> %let rc =%sysfunc(dosubl( proc sql noprint; Figure 8. First Attempt to Include SAS Code in a SAS Server Page 11 select distinct '<input type="checkbox" name="product" value="' ||strip(product) ||'">' ||strip(product) into:checkboxes separated by '<br>' from sashelp.shoes; quit; )); /* End both the DOSUBL function call and the %SYSFUNC macro function */ &checkboxes </body> </html> ;;;; run; Error which I got is, 'ERROR: No logical assign for filename _WEBOUT.' 81 proc stream outfile=_webout quoting=both; 82 BEGIN 83 <html> ERROR: No logical assign for filename _WEBOUT. 84 <body><title>Select Products</title><body> 85 %let rc =%sysfunc(dosubl( 86 proc sql noprint; 87 Figure 8. First Attempt to Include SAS Code in a SAS Server Page 88 11 89 select distinct 90 '<input type="checkbox" name="product" value="' 91 ||strip(product) 92 ||'">' ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 93 ||strip(product) 94 into:checkboxes separated by '<br>' 95 from sashelp.shoes; 96 quit; 97 )); /* End both the DOSUBL function call and the 98 %SYSFUNC macro function */ 99 &checkboxes WARNING: Apparent symbolic reference CHECKBOXES not resolved. NOTE: PROCEDURE STREAM used (Total process time): Other question is, I already wrote the HTML for the webpage. Only issue now is, to identify the right SAS code or HTML code (I wish to embed this version into my HTML code which I shown to @Kurt_Bremser ) to fetch data from SAS datasets and load the values in the prompts.

Online Status	Offline
Date Last Visited	‎06-03-2024 06:10 PM

SQL help on transpose logic

Re: Unexpected select error in Update statement

Re: Unexpected select error in Update statement

Unexpected select error in Update statement

Update statement based on Join condition not working

Select top 1 record based on conditions

Re: Substr with max function

Re: Substr with max function

Re: Substr with max function

Substr with max function

Re: Unexpected select error in Update statement

Re: Handling Missing and Null Values

Re: Handling Missing and Null Values

Re: Handling Missing and Null Values

Re: Case when to handle blank and NULL values

datetime format for dd.mm.yyyy hh:mm?

Re: datetime format for dd.mm.yyyy hh:mm?

Re: Error in Macro Variable

SAS 9.4 installation documents

Understanding of code submission to Grid nodes

Conditionally Execuete Where clause in proc print

Remove duplicates in proc print

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML

Re: SAS access in HTML