SAS Support Communities

Hi experts   I'm trying to extract specific components from an HTML page with the following code:   filename src temp; proc http url=&url out=src; run; data _null_; infile src; input; list; run; data rep; infile src length=len lrecl=30000000; input line $varying32767. len; line = strip(line); if len>0; run; The problem I face is that the part of the HTML page I need is beyond the 32767. character limit of the varying format, so it's probably left out by SAS when reading the input line   There is a way for large HTML bodies to:   a. break the HTML body in lines < of te 32767 limit?   I'm testing the code on this url: - https://www.youtube.com/c/sasusers/featured   And I want to isolate the line which include this HTML line of text: 'metadata":{"channelMetadataRenderer":{'       ... View more

Hi experts. I'm using the following example: filename src temp; proc http url="https://www.sas.com/en/whitepapers/artificial-intelligence-banking-risk-management-110277.br.html#formsuccess?utm_source=linkedin&utm_medium=paid-social&utm_campaign=rsk-gen-emea&utm_content=50931-lklgf-english" out=src; run; The scraping produce the following note:    73 filename src temp; 74 proc http 75 method="get" 76 url="https://www.sas.com/en/whitepapers/artificial-intelligence-banking-risk-management-110277.br.html#formsuccess?utm_so 76 ! urce=linkedin&utm_medium=paid-social&utm_campaign=rsk-gen-emea&utm_content=50931-lklgf-english" WARNING: Apparent symbolic reference UTM_MEDIUM not resolved. WARNING: Apparent symbolic reference UTM_CAMPAIGN not resolved. WARNING: Apparent symbolic reference UTM_CONTENT not resolved. 77 out=src; 78 run; NOTE: 404 Not Found NOTE: PROCEDURE HTTP ha utilizado (Tiempo de proceso total): real time 0.11 seconds cpu time However, the URL is reachable and it has an HTML structure that should be possible to scrape   Any idea about why the scraping is failing here?   ... View more

Hi experts   i'm trying to get, at column level, the % represented by each cell, for each sub-group. code like this:   proc tabulate data=active_opp (where=(active_pipeline_&yy=1 and opp_class_cy="new_pipe" and quadrant in ("A"))) format=comma12.2 missing; class quadrant account_industry cy_impact status_class ; var sale_amount_usm; table (quadrant)*account_industry*(cy_impact all='Grand Total' ), (status_class all='Grand Total')*sale_amount_usm* (sum="Total"*{style={background=pipe_vol.}} pctn<cy_impact*sale_amount_usm cy_impact*status_class cy_impact*all all >)/rts=50 ; run; However, the % at column levels do not reflect the proper percentage values, like below     Example: in column "open" the row "sourced" should be 76% but instead show a 56%. Any idea what I'm missing in the code?   Bests ... View more

Hi people   The below is causing this error:  ERROR: Column "AAAA.PRECISIONS" must be GROUPed or used in an aggregate function ERROR: The action stopped due to errors. ERROR: The FedSQL action was not successful. No idea what is generating the error in the final aggreagation, as all the sub-queries work fine (tested) proc fedsql sessref=casauto; create table casuser.test as select mean(precisions) as mean_precision, median(precisions) as median_precision from ( select aaa.person_id, count(distinct(aaa.gms_deliverable_id))/5 as precisions from ( select a.person_id, b.gms_deliverable_id from user_recc_open a left join recc_test_open b on a.person_id=b.person_id and inputn(a.gms_deliverable_id,'best.')=b.gms_deliverable_id ) aaa group by aaa.person_id ) aaaa ; quit; ... View more