The above suggestion is not quite what I needed - but on the other hand, I wasn't specific enough in my description of my needs.
I need the XLSX file (and other filetypes) to be posted to the URL in a binary(?) format - exactly as the cURL command does.
It looks like the HTTP procedure can't handle this directly, so you need some kind of "pre-burner". A datastep?
I have looked at this post:
https://communities.sas.com/t5/SAS-Procedures/upload-an-excel-file-to-box-com-using-PROC-HTTP/td-p/424118
But it seems that the final solution has not yet come in this post. But is this the path to follow?
... View more
Jeg har følgende CURL kommando jeg gerne vil have lavet om til PROC HTTP - og jeg er kommet noget af vejen. Det der mangler er selve transporten af (i dette tilfælde) XLSX filen.
CURL -X POST -F "data=@F:\SASNykredit\CURL\CURLJMICTEST2.xlsx" -F publishdate=2018-10-30 -F unpublish=2018-11-22 -F title="JMIC TEST 2018-10-30" -F category="Funktionsliste" https://ptsv2.com/t/kommunikationsplatform/post
Foreløbig er jeg i SAS nået til:
filename req temp; filename resp temp;
data _null_; file req termstr=CRLF; put "-F 'data=@F:\SASNykredit\CURL\CURLJMICTEST2.xlsx' "; put '-F publishdate=2018-10-30 '; put '-F unpublish=2018-11-22 '; put '-F title="JMIC TEST 2018-10-30" '; put '-F category="Funktionsliste" '; run;
proc http URL="https://ptsv2.com/t/kommunikationsplatform/post" METHOD="POST" in=req out=resp; run;
men som nævnt så bliver XLSX filen ikke overført. Jeg har brug for at flere forskellige filformater kan overføres (pdf, xlsx, docx etc.)
Er der nogen der kan hjælpe og lede mig lidt på vej?
... View more
Hi - I have a similar problem.
Also XLSX, DOCX, PDF files I would like to POST
And I have a CURL statement that works - but would very much like to convert it to PROC HTTP.
So - Is this community-post solved?
... View more
Ja - hvorfor skulle jeg være den eneste med det problem. SAS har selvfølgelig allerede løst det. Og %u giver endda lige præcis det jeg har brug for.
Takker.
... View more
I often have problems with converting the result of the weekday function which gives you sunday as first day of week. However in our part of the world we use monday as first day of week.
Here is a function that kan do just that - convert:
proc fcmp outlib = work.funktion.dk_ugedag; function dk_ugedag(_sasdato); return(weekday(_sasdato)-1+(weekday(_sasdato)=1)*7); endsub; run;
... View more
We'll wrap this question up at out SASNineNetwork meeting at Thursday in Copenhagen. I have some conclusions - but not all the way around the topic.
... View more
Well, the documentation doesn't cover all situations on this issue, in fact I think it's a little missleading.
Have just spent about 2h figuring this out - and to me it looks like the macrovar SQLOBS delivers value 1 if PROC SQL is able to fill in a value in a (new) macrovar. (eg finds a value from a table), but a 0 (zero) if it is not able to.
It is a little confusing because SQLOBS also, in some situations, can take the value <blank> (that is: no value).
... View more
Du har sikkert hvad du skal bruge nu - hos mig har jeg dog ikke problemer med mellemrum mellem 7 og K
proc format;
picture yyk low - high ='%YK%q' (datatype=DATE) ;
run;
data a;
dag=today();
format dag yyk6.;
put dag yyk5./
dag yyk6./
dag yyk7.;
run;
LOG:
106 proc format;
107 picture yyk low - high ='%YK%q' (datatype=DATE) ;
NOTE: Format YYK is already on the library WORK.FORMATS.
NOTE: Format YYK has been output.
108 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
109
110 data a;
111 dag=today();
112 format dag yyk6.;
113 put dag yyk5./
114 dag yyk6./
115 dag yyk7.;
116 run;
NOTE: Compression was disabled for data set WORK.A because compression overhead
would increase the size of the data set.
2017K
2017K4
2017K4
NOTE: The data set WORK.A has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
... View more
Det findes ikke i SAS så vidt jeg ved
Men du kan lave dit eget PICTURE format i Proc Format
jeg vil tro at dette virker
proc format;
Picture YYK low-high = '%YK%q' datatype=DATE;
run;
http://documentation.sas.com/?docsetId=proc&docsetTarget=p0n990vq8gxca6n1vnsracr6jp2c.htm&docsetVersion=9.4&locale=da#p0n1r81ipjuupin12z0o1z8rmhco
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
