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: 
carloshmcaldas
‎03-24-2023
  • 11 Posts
  • 4 Likes Given
  • 0 Solutions
  • 5 Likes Received
This widget could not be displayed.

Re: Converting curl to SAS

by Fluorite | Level 6 in SAS Programming
‎02-03-2022 06:54 PM
‎02-03-2022 06:54 PM
I've tried sslreqcert and still dont works.. ... View more

Re: Converting curl to SAS

by Fluorite | Level 6 in SAS Programming
‎02-03-2022 12:27 PM
‎02-03-2022 12:27 PM
Tryed filename result temp; proc http url="https://api.rjmetrics.com/0.1/figure/11111/export" in = "format=csv" in = "includeColumnHeaders=1" out=result; headers "X-RJM-API-Key" = "11111111"; debug level=3; run; Log shows a 403 error: < HTTP/1.1 403 Forbidden < Content-Type: text/html; charset=UTF-8 < Date: Thu, 03 Feb 2022 17:21:30 GMT < Server: Apache 2 The SAS System 13:20 Thursday, February 3, 2022 < Content-Length: 13 < Connection: keep-alive On my curl command I had to use "--ssl-no-revoke" By the way, is there a way to make the output as a dataset, instead of a CSV? Thanks Chris! ... View more

Converting curl to SAS

by Fluorite | Level 6 in SAS Programming
‎02-03-2022 09:22 AM
‎02-03-2022 09:22 AM
I´ve been trying to use SAS to import a database extracted through curl, but couldn´t figure how to pass the --data statement.   My curl command is:   curl --data "format=csv&includeColumnHeaders=1" --header "X-RJM-API-Key: <my-api-key>" https://api.rjmetrics.com/0.1/figure/<my-table-id>/export --ssl-no-revoke     I´ve tryied proc http method, but without success. Any suggestions? ... View more

Export as a step in the project XLS instead of XLSX

by Fluorite | Level 6 in SAS Enterprise Guide
‎10-02-2020 02:19 PM
1 Like
‎10-02-2020 02:19 PM
1 Like
My sasapp can't export at a local machine, I'm trying to create a project exporting as a step in it, but I can't choose XLS format. (needed format, can't use XLSX) How can I change this?   ... View more

Re: Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎10-01-2020 05:04 PM
1 Like
‎10-01-2020 05:04 PM
1 Like
Works like a charm @jimbarbour    Thank you very much! ... View more

Re: Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎09-29-2020 06:16 PM
‎09-29-2020 06:16 PM
As pdct 3 only  has one week sequence, as week 5, 6, 7 and 8, whe use date_start from first row and date_end from last row.   st1 - ct1 - cr1 - pdct3 - 5 - 11/1 - 20/2 st1 - ct1 - cr1 - pdct3 - 6 - 21/1 - 30/2 st1 - ct1 - cr1 - pdct3 - 7 - 1/1 - 10/3 st1 - ct1 - cr1 - pdct3 - 8 - 11/1 - 20/3   ... View more

Re: Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎09-29-2020 05:21 PM
‎09-29-2020 05:21 PM
no, because we can't use a year value, only date and month. the order is defined by week sequence. If the sequence  start at week 1 but it's interrupted, the correct sequence starts in the next order.  After the week sequence is solved, whe use the date_start from the first row and date_end from the last row. Product 1 input: state - city - crop - product - week - date_start - date_end st1 - ct1 - cr1 - pdct1 - 1 - 1/1 - 10/1 st1 - ct1 - cr1 - pdct1 - 2 - 11/1 - 20/1 st1 - ct1 - cr1 - pdct1 - 3 - 21/1 - 31/1 st1 - ct1 - cr1 - pdct1 - 34 - 1/12 - 10/12 st1 - ct1 - cr1 - pdct1 - 35 - 11/12 - 20/12 st1 - ct1 - cr1 - pdct1 - 36 - 21/12 - 31/12 Product 1 correct week sequence:   state - city - crop - product - week - date_start - date_end st1 - ct1 - cr1 - pdct1 - 34 - 1/12 - 10/12 st1 - ct1 - cr1 - pdct1 - 35 - 11/12 - 20/12 st1 - ct1 - cr1 - pdct1 - 36 - 21/12 - 31/12 st1 - ct1 - cr1 - pdct1 - 1 - 1/1 - 10/1 st1 - ct1 - cr1 - pdct1 - 2 - 11/1 - 20/1 st1 - ct1 - cr1 - pdct1 - 3 - 21/1 - 31/1 Product 1 correct output: state - city - crop - product - date_start - date_end st1 - ct1 - cr1 - pdct1 - 1/12 - 31/1   ... View more

Re: Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎09-29-2020 05:03 PM
‎09-29-2020 05:03 PM
The crop plantation definition order is the week sequence. ... View more

Re: Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎09-28-2020 09:59 PM
1 Like
‎09-28-2020 09:59 PM
1 Like
Because this crop plantation start in 11/Jan and ends in 20/Mar. ... View more

Re: Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎09-28-2020 09:44 PM
1 Like
‎09-28-2020 09:44 PM
1 Like
Date, with dd/mm format ... View more

Finding correct time range

by Fluorite | Level 6 in SAS Enterprise Guide
‎09-28-2020 06:50 PM
1 Like
‎09-28-2020 06:50 PM
1 Like
Hi folks, I'm trying to identify the time range from a database and I don't know how to do it at SAS:   This is how my database is: state - city - crop - product - week - date_start - date_end st1 - ct1 - cr1 - pdct1 - 1 - 1/1 - 10/1 st1 - ct1 - cr1 - pdct1 - 2 - 11/1 - 20/1 st1 - ct1 - cr1 - pdct1 - 3 - 21/1 - 31/1 st1 - ct1 - cr1 - pdct1 - 34 - 1/12 - 10/12 st1 - ct1 - cr1 - pdct1 - 35 - 11/12 - 20/12 st1 - ct1 - cr1 - pdct1 - 36 - 21/12 - 31/12 st1 - ct1 - cr1 - pdct2 - 1 - 1/1 - 10/1 st1 - ct1 - cr1 - pdct2 - 2 - 11/1 - 20/1 st1 - ct1 - cr1 - pdct2 - 35 - 11/12 - 20/12 st1 - ct1 - cr1 - pdct2 - 36 - 21/12 - 31/12 st1 - ct1 - cr1 - pdct3 - 5 - 11/1 - 20/2 st1 - ct1 - cr1 - pdct3 - 6 - 21/1 - 30/2 st1 - ct1 - cr1 - pdct3 - 7 - 1/1 - 10/3 st1 - ct1 - cr1 - pdct3 - 8 - 11/1 - 20/3 I need identify the date that a crop planting starts and when it ends. The issue that some crops plantation starts in one year and ends at the next year. So, my database output should be like this, but didn't figure how to do this on SAS:   state - city - crop - product - date_start - date_end st1 - ct1 - cr1 - pdct1 - 1/12 - 31/1 st1 - ct1 - cr1 - pdct2 - 11/12 - 20/1 st1 - ct1 - cr1 - pdct3 - 11/1 - 20/3   Ps. Sorry for my bad english. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-24-2023 07:48 PM
Likes given to
View All
Likes from
View All
Quick links