About HabAM

HabAM · ‎11-09-2017

Thank you

HabAM · ‎11-09-2017

I have a recursive data I would want to re-structure analysis: data : data have; input id pid ; cards; 1 0 2 1 3 1 4 2 5 2 6 3 7 0 8 7 9 8 10 8 11 7 run; I would like to structure it like this : id 1id 2id 1 2 4 1 2 5 1 3 6 7 8 9 7 8 10 7 11 . The challenge I have is I don't know how many levels I have in the data set. I tried the SAS support example (http://support.sas.com/kb/25/437.html) but I keep getting errors (ERROR: Ambiguous reference, column level is in more than one table.) Any help is much appreciated.

HabAM · ‎10-19-2017

I have 9.4 M2. I know the latest releason has a JSON lib. Thank you for the response.

HabAM · ‎10-18-2017

How do I parse the JSON file to a sas dataset using proc groovy: here is my code- proc groovy; add classpath="C:\bin\groovy-2.4.12\lib\groovy-2.4.12.jar"; add classpath="C:\bin\groovy-2.4.12\lib\groovy-json-2.4.12.jar"; submit; import groovy.json.JsonSlurper; def json_string = (new File("C:\\Users\\test.json")).getText(); def jsonSlurper = new JsonSlurper() def json = jsonSlurper.parseText(json_string); def testDataList = [] json.each { testDataList.add(jsonSlurper.parseText(it)) } endsubmit; quit; Thank you

HabAM · ‎10-13-2017

Thank you Cynthia as always.

HabAM · ‎10-13-2017

if you are creating three separate variables, this should work.. data want; set have; first=Compress('H'||substr(Road_No ,2,6)); second=Compress(substr(Road_No ,1,6)||'M'); third=Compress(substr(Road_No ,1,2)||'B'||substr(Road_No ,4,4)); run; good luck

HabAM · ‎10-13-2017

Are you creating three different variables from one or you are only interested in replacing the first, third and last?

HabAM · ‎10-13-2017

You can try this: data want; set have; newval=Compress('H'||substr(Road_No ,2,1)||'B'||substr(Road_No ,4,4)); run;

HabAM · ‎10-13-2017

here is my macro value: %let urlPath = %str(https://www.fda.gov/); And I am not sure what you meant by the text style element. If you look at the screen shot I posted, the hyperlink word "here" has a different format compared to the remaining words in the text. ODS PDF text="For resources and information, click ^S={font_size=9pt font_face=Arial URL='&urlPath.'}here";

HabAM · ‎10-12-2017

I tried the suggestion and it didn't create the hyperlink and the font format will not be the same for the remaining text.

HabAM · ‎10-12-2017

Hello community, I am trying to create a hyperlink on a PDF document but only want to highlight the link on one word, see example below. ODS PDF text="^S={font_size=9pt font_face=Arial URL='&urlPath.'}For resources and information, click here"; This code is highlighting the whole statement but my interest is highlighting "here". How can I accomplish this without creating a separate line? Thank you

HabAM · ‎09-13-2017

That explains it. Thank you all.

HabAM · ‎09-13-2017

Thank you. Is there a document published you recommend for me to review?

HabAM · ‎09-13-2017

I don't know why you are not getting the link to open, i checked it again and it works. The reason I wanted to try in in SAS is I wanted to integrate it with my existing SAS reports. Thank you for the response.

HabAM · ‎09-12-2017

How do you save the titles on the 'US - Based Outbreak' container using SAS? https://www.cdc.gov/outbreaks/index.html (EDIT via Reeza to fix the link)

Online Status	Offline
Date Last Visited	‎09-03-2019 05:55 PM

Re: Skipping dates on Proc Sgplot

Skipping dates on Proc Sgplot

Re: Proc Freq not displaying variable name

Proc Freq not displaying variable name

Re: Creating a FASTA file from dataset

Creating a FASTA file from dataset

Re: How to remove white space and format legend in proc gmap output?

Re: How to remove white space and format legend in proc gmap output?

How to remove white space and format legend in proc gmap output?

Re: How do you change your community UserName

Re: How to remove white space and format legend in proc gmap output?

Re: Using macro stored numbers in report- symput

Re: ODS HTML error

Re: using macro in do loop

Re: ODS HTML error

Re: recursive joins with PROC SQL

recursive joins with PROC SQL

Re: generate sas dataset using proc groovy-JSON

Create a SAS data set from JSON file using PROC GROOVY

Re: ODS PDF hyperlink

Re: Replacing first letter or value or last letter or value in given ...

Re: Replacing first letter or value or last letter or value in given ...

Re: Replacing first letter or value or last letter or value in given ...

Re: ODS PDF hyperlink

Re: ODS PDF hyperlink

ODS PDF hyperlink

Re: Scrap data from a webpage

Re: Scrape data from a webpage

Re: Scrap data from a webpage

Scrape data from a webpage