Hi,   I'm using the json libname engine with proc http to get data from a secure website.  I have the basic code working fine and I have a username and password to access the website, but now I have an API password and API key that I have to use now and can't find any documentation on how to incorporate it.   filename out "C:\temp"; %let url =https:// %put url = &url; proc http url="&url" method="get" out=out WEBUSERNAME="&user" WEBPASSWORD="&PW" AUTH_BASIC; run; libname test JSON fileref=out; filename mymap "C:\temp\test.map"; ........ where do I add in the API password and API key or do I need the API password?   sorry if this is basic, but I searched and found a lot of stuff for tokens, which are different than keys from what I read.  I read you can add the key to the URL or you can specify it in headers statement.  I feel like I'm close just nothing seems to be working. if you can direct me to any documentation that would be great also. thanks Enrique ... View more

Hello   I outputted results from proc tabulate and sgplot to a pdf file.  I used ODS region to place the table and bar chart next to each other on one page.  Everything looks good except for the label for ALL (tables (ALL='Total'...), instead of total, it's using a label for another variable?  When I don't use ODS region, it resolves that issue.  Not sure what I'm missing or if there is a better way to output the table and graph side by side that doesn't require ODS region? Any tips would be appreciated.  Thanks! %let todaysDate1 = %sysfunc(today(), DATE9.); %put &todaysDate1; options orientation=landscape nodate pageno=1 leftmargin=.25in rightmargin=.25in topmargin=.25in bottommargin=.25in; ODS pdf file="C:\ODSRegionOutput..pdf" style=journal bookmarklist=none pdftoc=2; ODS layout start columns=2; ODS region; proc tabulate data=dataset1; class newage/missing preloadfmt mlf order=data s=[font_style=italic font_weight=bold CellWidth=200]; class newrace/missing preloadfmt mlf order=data s=[font_style=italic font_weight=bold ]; class Gender/missing mlf order=data s=[font_style=italic font_weight=bold ]; class resident/missing mlf order=data s=[font_style=italic font_weight=bold]; tables (ALL='Total' newage='Age' newrace='Race/Ethnicity' Gender='Sex' resident='Residence'),( N colpctn='(%)'); format newage age. newrace racegrp.; run; ODS graphics on/ width=5.5in height=4in noborder; ODS region; proc sgplot data=dataset1; vbar date/ stat=sum datalabelfitpolicy=rotate datalabel; xaxis label='Date' values = ('20DEC2020'd to "&todaysDate1"d by day) valueattrs=(size=7pt); yaxis label='Number' ; format date MMDDYYS.; run; ODS graphics off; ODS layout end; ODS pdf close; ... View more

Hello I am trying to transpose a wide data set to a long dataset and found some sas code that uses an array; I tested it out using three variables and it worked well.  The issue I have is that the zip codes are not all consecutive, for example, I have 60601 to 60620, but then it jumps to 60625 to 60640; most are consecutive but several are not.  How do I specify that in the array? Thank you! data WORK.TRANSPOSE; infile datalines dsd truncover; input Date:DATE9. Percent:32. Percent1:32. Percent2:32.; format Date DATE9.; datalines; 01JAN2020 16.667 0 0 02JAN2020 0 0 0 03JAN2020 14.286 0 0 04JAN2020 0 0 0 05JAN2020 0 0 0 06JAN2020 0 0 0 07JAN2020 0 0 0 08JAN2020 0 0 0 09JAN2020 20 0 0 10JAN2020 0 0 0 11JAN2020 0 0 0 12JAN2020 0 0 0 13JAN2020 0 0 0 14JAN2020 0 0 0 15JAN2020 0 0 0 16JAN2020 25 0 0 17JAN2020 0 0 0 18JAN2020 0 0 0 19JAN2020 0 0 0 20JAN2020 0 0 0 ;;;; data Transpose2; set transpose; array apctcli(60601:60603) Percent Percent1 Percent2; do zip = 60601 to 60603; pctcli = apctcli(zip); output; END; DROP Percent Percent1 Percent2; run;   ... View more