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: 
smijoss1
‎06-07-2023
  • 49 Posts
  • 1 Likes Given
  • 6 Solutions
  • 14 Likes Received

Re: %symdel _all_ except

by Quartz | Level 8 in New SAS User
‎04-28-2019 10:42 AM
‎04-28-2019 10:42 AM
All my temp macro vars are prefixed with 1 or 2 underscore. So it suits my needs.. bht feel free to modify to your needs ... View more

Re: Find AVG for states in year/month

by Quartz | Level 8 in New SAS User
‎04-28-2019 04:26 AM
‎04-28-2019 04:26 AM
Then use substr(put( ... View more

Re: Find AVG for states in year/month

by Quartz | Level 8 in New SAS User
‎04-27-2019 09:55 PM
‎04-27-2019 09:55 PM
    you mean something like    proc sql ; select state, substr(yearmonth,1,4) as year, avg(Spend_Amt) as Avg_spend_amt From table group by state, substr(yearmonth,1,4); Quit ; ... View more

Re: created a distinct count when i am using same in report after appl...

by Quartz | Level 8 in New SAS User
‎04-27-2019 09:48 PM
‎04-27-2019 09:48 PM
Do a proc contents on the table and check the length and format of the variable.  my Hunch is it  is set to less than 8 to save space ?  ... View more

Re: Delete group on condition

by Quartz | Level 8 in New SAS User
‎04-27-2019 09:44 PM
‎04-27-2019 09:44 PM
Sql    select  from table  where id not in ( select id from table group by ID having max(var) = 0 ); ... View more

Re: %symdel _all_ except

by Quartz | Level 8 in New SAS User
‎04-27-2019 09:40 PM
‎04-27-2019 09:40 PM
Heres the macro i use to clean up macro vars.  you can change it to suit it to your needs.   %Macro Clean_Up_Macro_Vars(prefix); /*****************************************************************/ /* Delete macro variables created by previous Run */ /*****************************************************************/ %nrstr(options nosource nomprint nonotes;); /* Create list of macro variables to be deleted */ proc sort data=sashelp.vmacro nodupkey out=Temp_dsn; by name; where name =: upcase("&prefix."); run; data _null_; set Temp_dsn; /* Execute %SymDel against each Macro variable */ if scope='GLOBAL' then call execute('%symdel ' ||trim(left(name))||';'); run; proc delete data=Temp_dsn;run; %nrstr(options source mprint notes;); %Mend; ... View more

Re: Taking count and max for each row based on the list

by Quartz | Level 8 in New SAS User
‎04-27-2019 09:37 PM
‎04-27-2019 09:37 PM
data test; varlist = '_2014Q1,_2014Q2,_2014Q3,_2014Q4'; _2014Q1 =3; _2014Q2 =.; _2014Q3 =2; _2014Q4 =.; _2015Q1 =5; _2015Q2 =.; _2015Q3 =.; _2015Q4 =.; Array _tmp{*} _201: ; call missing (Count_NotMiss, Max_Val); do _i = 1 to dim(_tmp); if _tmp(_i) ne . and index(varlist,vname(_tmp(_i))) > 0 then do; Count_NotMiss + 1; Max_Val = Max(Max_Val,_tmp(_i)); end; end; Run; ... View more

Re: SAS Proc HTTP call to API Graph.Microsoft.

by Quartz | Level 8 in SAS Programming
‎04-26-2019 08:16 PM
‎04-26-2019 08:16 PM
Hi Chris,   I tried the method mentioned ( i copied the subject name and Serial number from certificate i see in browser )  however SAS did not like it. (screenshot below)   I also tried %let SSLCALISTLOC=/gpfsFS2/home/o815539/test_SP_Cert/cert_SP_Cloud_Smijo.pem; and that too didnt work.       i downloaded the Certificates ( as per http://javamemento.blogspot.com/2015/10/using-curl-with-ssl-cert-chain.html ) and tried it on my CURL command and it worked without any errors.  ( without having to use -k or --insecure)    filename test pipe 'curl --cacert /gpfsFS2/home/o815539/test_SP_Cert/cert_SP_Cloud_Smijo.pem --url <Download URL> /aim/mmc/mmc_Share/TEMP/smijo.xlsx';   is there an option in proc Http where i could pass the certificate path ? i tried searching couldnt fine one.  ... View more

Re: Proc HTTP Content Type for XLS and XLSX

by Quartz | Level 8 in SAS Programming
‎04-24-2019 10:47 PM
1 Like
‎04-24-2019 10:47 PM
1 Like
  For the file created by POST command. i Downloaded the file from sharepoint and opened it in notepad. and i see the multidata part we added on the top. I thought that part was for sharepoint and it would create the excel file with the binary portion of the file. i suspect this is where it is saying corrupt . expecting a binary file but getting text at top.   Do you think its a SP setup issue ?        I could get the PUT command to work.  i wasnt using a Fileref name on IN=  (stupid me)   filename reply TEMP ""; filename headout TEMP ""; filename In_file "&_xl_file_Pth./&_xl_file_Nm."; proc http url="&Site_Path./&_xl_file_Nm." in=In_file headerout=headout method='put' out=reply auth_negotiate verbose; run; filename In_file clear; ... View more

Re: SAS Proc HTTP call to API Graph.Microsoft.

by Quartz | Level 8 in SAS Programming
‎04-24-2019 01:37 PM
1 Like
‎04-24-2019 01:37 PM
1 Like
That is the blog i refereed to get till here (THANK YOU For the Blog! the steps were well explained.)    I was able to get DriveID , and Item IDs by listing files inside a SP folder (i did find using relative path on URL method more easy as you could skip getting the Drive ID step)    I used the same method mentioned on the blog to download the file but its throwing "partner certificate does not match" error.  I did some search online and most said its because the domain on URL does not match the Machine.  So instead of using the Drive ID and Item-ID  I tried to use the Pre-authenticated URL provided by API when i list files from folder. it works well when i put it into chorme but in SAS it still gives the same "partner certificate does not match".   I raised a support request with SAS as i feel this might me a setup issue on SAS Grid. I will update you on what they say.  So far they they directed me to your Blog to read and give the logs accordingly. ... View more

Re: Proc HTTP Content Type for XLS and XLSX

by Quartz | Level 8 in SAS Programming
‎04-23-2019 11:57 PM
‎04-23-2019 11:57 PM
Is there a way i could look at multipart information of files existing on SP.  i could use that as a reference to populate it. ... View more

Re: Proc HTTP Content Type for XLS and XLSX

by Quartz | Level 8 in SAS Programming
‎04-23-2019 11:55 PM
‎04-23-2019 11:55 PM
Hi Chris,   I used the code to create multipart data.    For some reason the method POST is not copying files to sharepoint (headerout file shows HTTP/1.1 404 NOT FOUND message)  The method PUT is able to transfer files to Sharepoint (On Prem). However i still get the corrupt / unable to open message.   Could you please take a look. I greatly appreciate your help on this.   Contents for response file :  <html> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><meta name="SharePointError" content=""/> <meta name="Description" content=""/> <meta name="Keywords" content=""/> <meta name="Robots" content="NOINDEX"/> <script type="text/javascript"> <!-- window.location.replace("https:\u002f\u002fsites.sp.xx.org\u002fteams\u002fnma\u002fPages\u002fPageNotFoundError.aspx?requestUrl=htt ps:\u002f\u002fsites.sp.xx.org\u002fteams\u002fnma\u002fKPRHS\u002fCPAU\u002fCPAU\u002520Documents\u002fTEST_SMIJO\u002fsmijo_tst_2. xlsx") --> </script> </head> <body> <!-------------------------------------------------------------------------> File Not Found <!-------------------------------------------------------------------------> </body> </html> Contents of Header File : HTTP/1.1 404 NOT FOUND Cache-Control: private,max-age=0 Content-Length: 758 Content-Type: text/html Expires: Tue, 09 Apr 2019 03:48:23 GMT Server: Microsoft-IIS/7.5 X-SharePointHealthScore: 0 Public-Extension: http://schemas.microsoft.com/repl-2 SPRequestGuid: 24fad59e-6d95-1045-26f4-42dcade71d97 request-id: 24fad59e-6d95-1045-26f4-42dcade71d97 X-FRAME-OPTIONS: SAMEORIGIN SPRequestDuration: 17 SPIisLatency: 0 WWW-Authenticate: Negotiate <removed by smijo> NK+6FCQ= Persistent-Auth: true X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: 15.0.0.4512 X-Content-Type-Options: nosniff X-MS-InvokeApp: 1; RequireReadOnly Date: Wed, 24 Apr 2019 03:48:22 GMT   Full log :  152 153 %let _Extn=xlsx; 154 %let _xl_file_Pth=%sysfunc(pathname(Work)) ; 155 %let _xl_file_Nm=smijo_tst_2.&_Extn ; 156 157 158 proc export data=sashelp.class outfile="&_xl_file_Pth./&_xl_file_Nm." dbms=&_Extn. replace; 158 ! run; NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,457-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 19| _DISARM| 34643968| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.020000| _DISARM| 0.012351| _DISARM| 1871696903.444913| _DISARM| 1871696903.457264| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: The export data set has 19 observations and 5 variables. NOTE: "/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/smijo_tst_2.xlsx" file was successfully created. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,459-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 38703104| _DISARM| 33980416| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.020000| _DISARM| 0.017112| _DISARM| 1871696903.442451| _DISARM| 1871696903.459563| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: PROCEDURE EXPORT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 159 160 %Post_to_SP_Multidata_fmt(&_xl_file_Pth./&_xl_file_Nm. 161 , https://sites.sp.xx.org/teams/nma/KPRHS/CPAU/CPAU%20Documents/TEST_SMIJO); _BOUNDARY=0030c5a5-68ec-b845-a49f-1707ecf990b6 _CAT=Testliste _PUBLDATE=2019-04-23 _UNPUBLDATE=2020-04-23 _TITLE=O815539 TEST 2019-04-23 _FILE_NM=smijo_tst_2.xlsx MPRINT(POST_TO_SP_MULTIDATA_FMT): filename req "/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_request.txt"; 2 The SAS System 19:14 Tuesday, April 23, 2019 MPRINT(POST_TO_SP_MULTIDATA_FMT): filename resp "/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_response.txt"; MPRINT(POST_TO_SP_MULTIDATA_FMT): filename headout TEMP ; MPRINT(POST_TO_SP_MULTIDATA_FMT): filename binfile "/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/smijo_tst_2.xlsx"; MPRINT(POST_TO_SP_MULTIDATA_FMT): data _null_; MPRINT(POST_TO_SP_MULTIDATA_FMT): file req termstr=CRLF; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "--0030c5a5-68ec-b845-a49f-1707ecf990b6"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put 'Content-Disposition: form-data; name="publish"'; MPRINT(POST_TO_SP_MULTIDATA_FMT): put; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "2019-04-23"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "--0030c5a5-68ec-b845-a49f-1707ecf990b6"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put 'Content-Disposition: form-data; name="unpublish"'; MPRINT(POST_TO_SP_MULTIDATA_FMT): put; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "2020-04-23"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "--0030c5a5-68ec-b845-a49f-1707ecf990b6"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put 'Content-Disposition: form-data; name="category"'; MPRINT(POST_TO_SP_MULTIDATA_FMT): put; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "Testliste"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "--0030c5a5-68ec-b845-a49f-1707ecf990b6"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put 'Content-Disposition: form-data; name="title"'; MPRINT(POST_TO_SP_MULTIDATA_FMT): put; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "O815539 TEST 2019-04-23"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put "--0030c5a5-68ec-b845-a49f-1707ecf990b6"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put 'Content-Disposition: form-data; name="uploadfile"; filename='"smijo_tst_2.xlsx"; MPRINT(POST_TO_SP_MULTIDATA_FMT): put 'Content-Type: application/octet-stream'; MPRINT(POST_TO_SP_MULTIDATA_FMT): put; MPRINT(POST_TO_SP_MULTIDATA_FMT): Run; NOTE: The file REQ is: Filename=/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_request.txt, Owner Name=o815539,Group Name=sasgrnsh, Access Permission=-rw-rw-r--, Last Modified=23Apr2019:20:48:23 NOTE: 20 records were written to the file REQ. The minimum record length was 0. The maximum record length was 76. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,470-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 38703104| _DISARM| 33980416| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.000000| _DISARM| 0.007543| _DISARM| 1871696903.462846| _DISARM| 1871696903.470389| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(POST_TO_SP_MULTIDATA_FMT): data _null_; MPRINT(POST_TO_SP_MULTIDATA_FMT): file req mod recfm=n; MPRINT(POST_TO_SP_MULTIDATA_FMT): infile binfile recfm=n; MPRINT(POST_TO_SP_MULTIDATA_FMT): input c $CHAR1.; MPRINT(POST_TO_SP_MULTIDATA_FMT): put c $CHAR1. @@; MPRINT(POST_TO_SP_MULTIDATA_FMT): Run; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file REQ is: Filename=/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_request.txt, Owner Name=o815539,Group Name=sasgrnsh, Access Permission=-rw-rw-r--, 3 The SAS System 19:14 Tuesday, April 23, 2019 Last Modified=23Apr2019:20:48:23, File Size (bytes)=581 NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile BINFILE is: Filename=/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/smijo_tst_2.xlsx, Owner Name=o815539,Group Name=sasgrnsh, Access Permission=-rw-rw-r--, Last Modified=23Apr2019:20:48:23, File Size (bytes)=7196 NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,478-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 38703104| _DISARM| 33980416| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.010000| _DISARM| 0.005901| _DISARM| 1871696903.472149| _DISARM| 1871696903.478050| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(POST_TO_SP_MULTIDATA_FMT): data _null_; MPRINT(POST_TO_SP_MULTIDATA_FMT): file req mod termstr=CRLF; MPRINT(POST_TO_SP_MULTIDATA_FMT): put / "--0030c5a5-68ec-b845-a49f-1707ecf990b6--"; MPRINT(POST_TO_SP_MULTIDATA_FMT): Run; NOTE: The file REQ is: Filename=/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_request.txt, Owner Name=o815539,Group Name=sasgrnsh, Access Permission=-rw-rw-r--, Last Modified=23Apr2019:20:48:23, File Size (bytes)=7777 NOTE: 2 records were written to the file REQ. The minimum record length was 0. The maximum record length was 40. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,482-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 38703104| _DISARM| 33980416| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.010000| _DISARM| 0.002997| _DISARM| 1871696903.479423| _DISARM| 1871696903.482420| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(POST_TO_SP_MULTIDATA_FMT): proc http url="https://sites.sp.xx.org/teams/nma/KPRHS/CPAU/CPAU%20Documents/TEST_SMIJO/smijo_tst_2.xlsx" in=req headerout=headout method='POST' out=resp auth_negotiate CT="multipart/form-data; boundary=0030c5a5-68ec-b845-a49f-1707ecf990b6" verbose; URL = https://sites.sp.xx.org/teams/nma/KPRHS/CPAU/CPAU%20Documents/TEST_SMIJO/smijo_tst_2.xlsx METHOD = POST CT = multipart/form-data; boundary=0030c5a5-68ec-b845-a49f-1707ecf990b6 In = /gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_request.txt Out = /gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_response.txt Header Out = /gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/#LN00193 MPRINT(POST_TO_SP_MULTIDATA_FMT): run; NOTE: PROCEDURE HTTP used (Total process time): real time 0.15 seconds cpu time 0.04 seconds 4 The SAS System 19:14 Tuesday, April 23, 2019 NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,635-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 38703104| _DISARM| 33980416| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.040000| _DISARM| 0.152011| _DISARM| 1871696903.483656| _DISARM| 1871696903.635667| _DISARM| 0.040000| _DISARM| | _ENDDISARM SYS_PROCHTTP_STATUS_CODE= SYS_PROCHTTP_STATUS_PHRASE= MPRINT(POST_TO_SP_MULTIDATA_FMT): data _null_; MPRINT(POST_TO_SP_MULTIDATA_FMT): infile req; MPRINT(POST_TO_SP_MULTIDATA_FMT): input ; MPRINT(POST_TO_SP_MULTIDATA_FMT): put _infile_; MPRINT(POST_TO_SP_MULTIDATA_FMT): Run; NOTE: The infile REQ is: Filename=/gpfsFS1/saswork/SAS_workA48900002C63_cskpcloudxp2056/SAS_workAB1F00002C63_cskpcloudxp2056/Http_request.txt, Owner Name=o815539,Group Name=sasgrnsh, Access Permission=-rw-rw-r--, Last Modified=23Apr2019:20:48:23, File Size (bytes)=7821 --0030c5a5-68ec-b845-a49f-1707ecf990b6 Content-Disposition: form-data; name="publish" 2019-04-23 --0030c5a5-68ec-b845-a49f-1707ecf990b6 Content-Disposition: form-data; name="unpublish" 6 The SAS System 19:14 Tuesday, April 23, 2019 2020-04-23 --0030c5a5-68ec-b845-a49f-1707ecf990b6 Content-Disposition: form-data; name="category" Testliste --0030c5a5-68ec-b845-a49f-1707ecf990b6 Content-Disposition: form-data; name="title" O815539 TEST 2019-04-23 --0030c5a5-68ec-b845-a49f-1707ecf990b6 Content-Disposition: form-data; name="uploadfile"; filename=smijo_tst_2.xlsx Content-Type: application/octet-stream PK  ˜N‰0È]. a  xl/worksheets/sheet1.xml•TÁrÚ0ýîAØØ$0˜L’ié4msòÚÖD²\I@øû®dã1dš¦¬ÕÓ{ûvWbuûªd´c…nrO¦$‚†ëB4UN~þx ¸º!‘u¬)˜Ôää–Ü®Wm^là"ä76'µsí’RËkPÌNt "¥6Š9 MEmk€¤$M¦Ó9UL4¤SXšhè²6šï4®1 ™C÷¶­=©)þ9ÅÌË®½âZµ(±R¸c%‘âËǪцm%Vý§ŒŸ´CðF^ n ´Õ¥› \oômÍ º ¨´^+ðM ”9ù/ïãiz“]Ï ]¯ã—€ƒ­#ǶO ;(r‚ƒòCØjýâÁÇ°…§Ã¯Ëð³‡;ÒËã÷™|:¨Ž×§l¡GßLT@ÉvÒ}ׇ/ ªÚáÉ°¾Ëâ¸Ëq ˜x’d^•kiÃo ¤„¿MØFö¾Q¸:'Hæ;ë´zîbD舐ô„d ¤ïf=a6âÙûŒ´g¤fd=#ûƒvå‡n˜cë•Ñ‡Èض̿’xù×öaFÖO ·,ÆûõtE÷^·Ç>±ø»cÉ9¶c³sì~Œ¥FÑúà?ùÿÉH/»ð?Ææþ“®ªôÂz·=_\¸îOÇÉ$»ðLGýoY_™©Dc# e°z˜î.wÓmÑV;œhXÖøhÁøˆ—Z»S€Sî°‡°1)ªæY¸ºÏâß ¿ Ãß ãúPK  ˜N÷_9«J Ž  [Content_Types].xml­”MnÂ0…¯y‹CUUXôgÙ"•À'‰…c[žÂí;1U%ª`+žyï{v4™Î·Í6ÑxWŠI1¸ÊkãšR¼/Ÿó;‘! )§•õJ±óÙt¹ €k–¢% ÷RbÕB§°ðWj;EüTµRÈ›ñøVVÞ8Ê©÷³é#Ôjm){Úòö>G‹"{Ø7ö¬R¨¬©q]nœþEÉ„‚•©[pÄBž$ô•¿Ý+_L4²…Šô¢:î’[+?}\}x¿*ΛœHéëÚT }µîXR`ˆ 4¶ ÔÙ"­E§ŒóS3Ê´L®äè?ƒø{Ãþyy„d3 DÚYÀk_{2"·*‚~£Èsqõ ?½Ïå`ý"ú€<Aþâ{DzuØ"™ó'?ÙúâSC?}ô ¶Lÿ“ÙPK  ˜Nõ"B¡æ J _rels/ .rels­’ÁNÃ0 @%ò}u7$„в]Òn•0‰ÛUmã(1Ðý=ဠҘvàÇ~~¶¼ÝÏÓhÞ9å^‚…uUƒáàÄ÷¡³ðÒ<®îÀd¥ài”ÀNœa¿Û>óHZJò±ÙFÈŽªñ1»#O”+‰ÊO+i"-ÏÔa$7PǸ©ë [L¿°dšƒ·þLsŠ|[Ú¶wü îmâ gZ ÏÊÁ³_ÅTê“öeÓPêX-xqO%œ‘b¬ ð¼Ñæz£¿§Å‰•<)¡“Ä—}¾2. ­ÿsEËŒ›yÄIëÈðí‚‹Ø}PK  ˜NBù. _  docProps/core.xml’]OÂ0†ÿÊÒû­+84Í65\Ib"Fã]Ó qýH[ü{» cD.¼lßç<=ç¤å|¯šäœ—FWˆd9J@s#¤ÞTè}µHPâÓ‚5FC…àѼ.¹¥Ü8xuÆ‚ |=ÚSn+´ÁRŒ=ß‚b>‹„ŽáÚ8ÅB<º¶Œ³àIžÏ°‚À wÂÔFtR >(íÎ5½@p (ÐÁc’|a8åoôɈT2,ÜDÏá@ï½À¶m³vÚ£±‚?—/oý¨©Ôݦ8 ºœr,W{擝WâÑe·À†ù°Œ›^K‡÷7+OƒëA$±!zlÿœ|LŸžW TOrBÒ|’²"½+hQ|uO_Õ_ „êôÈÿ3JîGƳ îû¾þõ/PK  ˜N‹‚nXì Ž  xl/theme/theme1.xmlíY[‹7~/ô?ˆywæ>¶—xƒ=¶“6»IÈnRò(ebÍÈŒäÝ5!P’ÇB¡4-})ô­¥m ¾¤¿fÛ ”6…ü…j4¾hlM.ÍRìÑÑwŽ>st¤™9á$!àe Ó´eØç, 4¢CœŽ[ƍÃ~­a Æa:„„¦¨eÌ3.ì~øÁy¸Ãc” ôS¶[FÌùtÇ4Y$Н£S”Š¾ÍÈE3›Ã  » 1Ë ÌâÔ )L„Ù«£Ž8ÌM»Kã="~RÎrAD²ƒHŽ¨jHìpbçlÎB’#HZ†gHÑ 7 Œ‹Ž–aɏaîž7WJ„Wè*z}ùYè-†GêeãÁJÑó|/h¯ì;…ým\¯Þ zÁÊžÀ(3µ·°~§Ùéú ¬*.5¶» õ®k—ðŠ}w ßöóo ï®ñÞ¾ß×>T@Å¥¯ñIÝ ½Þ_ãƒ-|Ýjw½z /A1Áéd mù.g»‚Œ(¹¤…7}¯_wð5ÊT²«ÐOyU®%ð6Íú ƒ 9NŸOÑFB‚{x‹Ä›Â”2!¶«o¹â7ÿzòJzî ¨h¢ˆm‰r>€Ežò–ñ±°j(çO~|þäxþäáé½Ç§÷~9½ÿôÞÏÅK0«ŠÏ¾ÿâïo?=úîÙƒ¯ôx¦âÿé³ß~ýRä*ðé×ÿxüðé7ŸÿùüÁ ?Ä bà :×i"æ¦ ²×Ó8Œ!.iÀX 5ÀKÀ+sHt¸*;ïf&Š„xqv»Äõ Îfk€—ã¤ܧ”th¦Îå|,u:³t¬<›©¸ëéÆ7BÛ›ME¶cÉ0F%š×ˆˆ6£q÷Ñ Bµ[—üº£Œ2:âàˆµ.9 Ä®Wº„—¹Ž uÉ7û7A‡ù.:*#Å‚€Dg‘’/‡‰–1LˆŠÜƒ<Ö‘<˜gQÉጋH¡ 7DŒét®fóÝË¢¸èþOæI™q<Ñ!÷ ¥*²K'a “©–3Ncû›ˆ…àåZ´¼Bò¶ˆL+Ã}#þzË ú†¨«úÉ{f™nI Z^s2‚(]ì¥jžàô¥¥}£¨û¾¨·3¬]Z›¥¼ ÷,à]8K¯!±fÞ×ï÷õûÿX¿«ÖòÙWíu¡6ÕÓº4“TÝG˜>'hÉÏÄô†}!”©´ºS˜Æâr1\ 7Π¼åŸ`Äp*†±åc¶0=f`J™Ø$ŒJÛr“™%ûtXHm{ys* _ËÅ&³”‹-‰Ò ¾¾ [™—­1 S øÒè«“P+“p5$êî«‘°­³bÑÔ°hØ/ba*QëÀü¹†ïŒD¾A‚†yœ ýetÏ<ÒUÎ,OÛÑL¯éY¤K$”t+“PÒ0†C´)>ãX7›úP;ZõÆÛˆµ¹]HZnc±æ\_˜‰à´eŒÄñP\&Saåu’qÚ2"¾pô¿©,ÓŒñ.dq“]ÅüÌQND®«a éš›íÔ­w—\Óz÷<gnF(â’u SôF´½oÎt&HÄÃc0 ³ì:ŽòëvîÀ!f|åÍ!Δä^{q£\-–bé¡Ùz‰B2ábGQ‹y—×+:Ê<$ÓÍY™:Æý³Øu_®´Q4+6ze{{›¼ÂÊÕ³òµµ®Ù°^¼K¼ù† Pk詹zjU{ǔႠ¿9•Ñ|ÃÝ`3kMå\)[[o'èà¶Èü®8®ÎgÅc€q.Ÿ+•@J—Õ儃Y†[ÆËo{¡ã‡5«á÷jžëYµ†ßvkmßwížo[ÝŽsW8…ljíc÷Åý ™/^¾HùÖ ˜dyÌ>ÑĤòlJeùÆvª_À ,<s'púM· Ù jM·Ý¯yÝN£Ö ƒN­„õn¿úfÿ®Ž$Øk»¡ôµÀÚX9ýF³V÷§íÕۍž×¾»ðµ˜ùòé^Ék÷PK  ˜Nžj… @  docProps/app.xml“ÑkÛ0Æÿ£÷FN VƲJI7:ØXÀiûXTùk•%¡»˜dýd»Îú0èÛwwŸ:ÉâæØÚ¬ƒˆÆ»‚-9ËÀi_·/ØÃîÛÕ–!)W)ëìÈn¤ØF ’ÌR€Ã‚5DaÍ9êZ…‹4viRûØ*JeÜs_×FÝׇñUžæp$pTW a dçÄuG­¼îùðqw )OŠÛ¬ÑŠÒåO££G_Söõ¨Á >ŠT‚>DC'™ >/E©•…M –µ²‚¿5Ä=¨~e[e"JÑѺM>fhþ¤¥­Xö¢zœ‚u*初mçbÐ6 Eùäã+6 „‚OÍAνsm®åj0$qiäHÒ—ˆ;CðW½U‘þG<0°cÙó-ç|“ÂÖüöÏ„ô¼zÇ?’üóíoƒr'YÞ–Ùw‡dè@”|‰ ƽâCØù;E0îÿ²)ÊFE¨Ò•M÷35Ä}:H´½Ó(·‡jô¼ô¯åñüCÈåõ"ÿ”çÃ#{‚¿=~ùPK  ˜N @ð F  xl/_rels/workbook.xml.rels½RËjÃ0ü±÷Z¶û  ”(¹”B®múBZ[&¶$´Û‡ÿ¾Â¡©ièÁô$fÄÎ ;»Ú|½xÇD]𠪢ÞÛùVÁëîéê±öV÷Á£‚ 6ëÕ3öšó¹.’Èž8æø %‡ƒ¦"Dôù§ iÐœajeÔf¯[”uYÞÉ4×€SM±µ ÒÖނ؍ÿ¢š¦3øÌÛ€žÏXȏöä9‹êÔ"+8R$§§.²*y>Íõ’iˆÇ>/óå€'ÿ_ìë%í9Ïâûdu)CõÏ…\ s³hN'´/œòéÏk™ÓßaäÉý¯¿ PK  ˜NE Šx W  xl/worksheets/sheet2.xml•˜Ûr›:†_…á¾ ÄÁc»³]'Ó^t¦Óî½{-ƒl3D‘'o_„G‡D7¶Y¿Öâ“Xèo>¿V¥óBZVÐzë‚•ï:¤Îh^Ôç­ûß¿Ÿ×a×9.iM¶îaîçÝæJÛ'v!„; "¿f[÷Ây³ö<–]H…ÙŠ6¤ʉ¶æâ°={¬i Îû¤ªô ïG^…‹Ú•ÖíGjÐÓ©ÈȁfÏ©¹,Ò’sAÏ.EÆjUö‘rnŸž›O­QâX”닺N•­¿kÚâc)fý BœµûƒQùªÈZÊ良D9:žs꥞¨´Ûä…˜A·èNKN[÷°~ ~˜ 8r½Ý¦Ïø¿ W¦ýv8>þ"%É8É·®¸PÝE8RúÔ‰ßúÝèêbñõB¾²ìÊ‹«øG©;w«ªÿÎöدяÖÉÉ ?—ü'½~%ÅùÂE‡ ± ݬó·a™¸ âÄ+ˆºª-YÿéTE×Mbñkÿ}-r~Ùº©ëdÏŒÓê·<Š§%@• o árB ‚[–3B•~8© ô^†'§ß¯às¼Û´ôê´½ÌÜÝ%`=»|âŒÝØîJ‰Ç/;ã½tu•¶×5p¯}Ñ5x¯t-¸× t-¼iž@¿ñC~¨ÕC¿®E?”³ tŽRƒZp…¦™æ@ãŠf]K æ@RKza­Œù?H!™YæÐ9Ô°ŒÅÙ‡ Èá4² Ghe¶‡ÒdÙ #½{ÍÖF Ìhº5d8‚+cüƒïÏ6GdƒéØÆ]·::šÆ–á(uGôvlƒëØƆ°°ãÉ”ƒ £ 7 The SAS System 19:14 Tuesday, April 23, 2019 xÔ!RH‚iæĆ9Ñ™óì“…I¦™e¥£Iԍ8·Ò©uªSW{Ÿ.P§2ÅèƒC:ôµÙ é{›ð­œÆ×ÁͽúN5{øÓÛˆŠO°+enïvyg„‘I–ÈÁt«¨82FÅÓtvÍ­ÜèL¯¹SÍnƒç™ä2ŽÀèÎ –ÝÊ%n… 1Ù—ŒÓ{¡ŠGá˜]*©?Cne–@wD`Ú%XòKÎôK8˜üˆ\*q<Cnå™@÷E8z\rM€¦·Æ'C†6Ù{t+ߺ7BÓ8Á’s‚hòÎ>¨x Mp5Íu‹•sÝ¡i`É;ÁŒyª¸èsÓ‰n3OXÀÊ@ n’ÐtÐ;u„žÌ´‹ŒG± ®Æ3Ƭ<è> M½SGàƒ-šàéðÄ2ês©$3»"´rQ¨û$½ñ,¹(ô§—\Å'îÐ!ct‡zÚ[gƒÏä;nÏEÍœ’œzàXÌ£•oðò€Ó¦1=R.ÞcûŸ‚sÒv„~¢”âÝVj}ÐÁeq ®ü¢ÎÒýóнÿÞþÚýPK  ˜NÝ×yA ¿  xl/sharedStrings.xmlm’AkÃ0 …ÿJð}uÖC#Ii e„uŒ®cg5Qbƒ-g¶3Ú?—ÁÖŽúüd½g«Z_¬)¾Ðí¨÷‹RH ë5µx?íïD"PÆÖâŠA¬›*„X¤N µP1NR†N¡…°pR:œ·SéG&Ð…­‘˲\I šDѹ™b-–+Q̤?gÜý‚4B7Ul^Àb%cSÉ[ýÃÞð’£ÍÈTO¨Gsúñ/ݘÁcŸÓ—éŽÍÙç` þ r¼ï 7IþšÃ6e}c,K‹C Ã/uŠ8»ò<íܳæg7ëÀ”àÞ_•6zÊéѝÑ3§GG`Ø«Ÿ”K{ÄþM£Áþa™V°ùPK  ˜NXû€?} è  xl/workbook.xmlQËNÃ0ücUâN\žUÓŠ§@BÀ¡À™xÓ;² RþžMÒ@ BâdÏzgvf=¯ MÞÁyeMBã݈0©•Ê,ú°¸Ü9¢Äa¤ÐÖ@B?ÀS2ŸMkëÞ^¬}#È7>¡yå„1ŸæP¿kK0ø’YWˆ€Ð-™/és€PhÆ£è€BÚ)LÜ4l–©ÎmZ`B'â@‹€î}®JOgÓLixìQ–·¢@Û+M‰>\H @&t¡­a£àªò´RÁñ8â”}‡¼wDB&*h­WÇuñ=ΚΦëQAí¿I$«'e¤­zÈq³=⇈ê<)r”Šãè«vj™45æû:È· ìObÚt¾P¯ÿ©)]£ÿÃL^ܵŒ_ÍÏÁ‡g> ð¥›ÙÂä Ê€lö¸‰6†Ï¶Ûs{kt2Š'£‹Ÿ²AïŸÄµ‘5½C‘è‡ Ût“ âçd•Ögx½37V`†à*h3ô1ûPK  ˜Na > < xl/styles.xmlµ–_o›0À¿Šå÷ԁ&m•’©RWMj+íÕ“XõdL6í»ïŒ)!뤵ÛÈC|>ßý|>ÑõA ôÂLŵŠqp6ň©Lç\íbüô˜N®0ª,U9Z±7¬Â×ITÙF°‡=c@U1Þ[[. ©²=“´:Ó%S°Rh#©…©Ù‘ª4Œæ•s’‚„Óé‘”+ì K™½"©y®ËI¦eI-ßrÁmÓ²0’Ùòv§´¡[‚Í^Ùíä^òÌè Jö pDÏØÛ(dA€”Dª–©´Êt­,äªW!?Üæ ¼˜cäã]ëÂȉ$ü0"ID:DZI¨pù¬ôW•º%wVëoè… Ð™Ú '`Î4ŠJæ-ÖTð­áNYPÉEãÕ¡S´‡îì$‡49%ñ;´ƒ‹Š ÑGb¯H"È´eF¥0AüØ”°½‚’ð˜ÖîÖ;C› œÚöÝj“C 3ëUI$XaÁÁðÝލV—Ä-Z 7–D9§;­¨pÈWN lÆ„xp…ú ¥8aŠÁMÝ}©^„€:ÑcüÄñ‡4ÏbÏÿŠ‹E¿Á‰w0û;¢e)šûZn™IÛêk«êWjø± ÞKÇ ó1¨çc@G¹+xÚÇ ^ŽB¥¬F‰ôbêÿ*VÒõ•Aó:i]½¹®ã{ç-ämÍ…åê7m ˜ùáرÚUëÞ•§» #g­…}ìc|”?±œ×2ì­>óm;«£|çú5$ö`{WÙvDµá1þ~³º\lnÒpr5]]Mfçl>YÌW›É|¶^m6ébN×?¯îxq·p[ÁlY °2Ýa»àŽº&>ü6¶ÿoAŽ>ÉOPK   ˜Na > <  † xl/styles.xmlPK  ˜NXû€?} è   Ü xl/workbook.xmlPK  ˜NÝ×yA ¿   œ xl/sharedStrings.xmlPK  ˜NE Šx W   M xl/worksheets/sheet2.xmlPK  ˜N @ð F  % xl/_rels/workbook.xml.relsPK  ˜Nžj… @   h docProps/app.xmlPK  ˜N‹‚nX ì Ž   K xl/theme/theme1.xmlPK  ˜NBù. _   î docProps/core.xmlPK  ˜Nõ"B¡æ J ß _rels/.relsPK  ˜N÷_9«J Ž   d [Content_Types].xmlPK  ˜N‰0È]. a   xl/worksheets/sheet1.xmlPK Æ @ --0030c5a5-68ec-b845-a49f-1707ecf990b6-- NOTE: 48 records were read from the infile REQ. The minimum record length was 0. The maximum record length was 1114. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-04-23T20:48:23,656-07:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 38703104| _DISARM| 33980416| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 16| _DISARM| 0.010000| _DISARM| 0.006653| _DISARM| 1871696903.649545| _DISARM| 1871696903.656198| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(POST_TO_SP_MULTIDATA_FMT): filename req clear; NOTE: Fileref REQ has been deassigned. MPRINT(POST_TO_SP_MULTIDATA_FMT): filename resp clear; NOTE: Fileref RESP has been deassigned. MPRINT(POST_TO_SP_MULTIDATA_FMT): filename headout clear; NOTE: Fileref HEADOUT has been deassigned. MPRINT(POST_TO_SP_MULTIDATA_FMT): filename binfile clear; NOTE: Fileref BINFILE has been deassigned. 162 163 GOPTIONS NOACCESSIBLE; 164 %LET _CLIENTTASKLABEL=; 165 %LET _CLIENTPROCESSFLOWNAME=; 166 %LET _CLIENTPROJECTPATH=; 167 %LET _CLIENTPROJECTPATHHOST=; 168 %LET _CLIENTPROJECTNAME=; 169 %LET _SASPROGRAMFILE=; 170 %LET _SASPROGRAMFILEHOST=; 171 172 ;*';*";*/;quit;run; 173 ODS _ALL_ CLOSE; 174 8 The SAS System 19:14 Tuesday, April 23, 2019 175 176 QUIT; RUN; 177     ... View more

Re: Proc HTTP Content Type for XLS and XLSX

by Quartz | Level 8 in SAS Programming
‎04-23-2019 10:12 PM
‎04-23-2019 10:12 PM
Thank you Chris. Let me try this. i was wondering if SAS developers had fixed it as the thread seemed a 1.5 years old. ... View more

Re: SAS API Graph.Microsoft Download file from site

by Quartz | Level 8 in SAS Programming
‎04-23-2019 09:48 PM
‎04-23-2019 09:48 PM
Hi Chris, Thank you for replying.   I am using SAS Grid 9.4 M4.     ... View more

Re: upload an excel file to box.com using PROC HTTP

by Quartz | Level 8 in SAS Procedures
‎04-22-2019 09:08 PM
‎04-22-2019 09:08 PM
where do i get the value for macro variable _boundary, or is it any constant  ? Thank you for sharing your code ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-07-2023 03:55 PM
Likes given to
View All
Likes from
Quick links