About RobertHuey

RobertHuey · ‎01-23-2015

Hi all, Is there a way to keep my PROC IMPORT procedure from truncating my unique identifier? It is about 20 numbers long and is converted to scientific notation using my procedure. It uses the best12 format and I'm importing from a txt delimited file with vertical bars as the delimeter. The last two digits are what make these identifiers unique and I need them, not the scientific notation. Thanks for any help!

RobertHuey · ‎01-20-2015

Great. Thank you!

RobertHuey · ‎01-20-2015

Hi all, Is there a way to limit the number of tick marks on the x axis on a PROC SGPLOT series graph? My data is set up by month and I only want to show 18 months at a time (the most recent 18 months). Is there a way to set this up so that each month, the oldest month rolls off? Thanks in advance!

RobertHuey · ‎09-24-2014

Thanks for the response Linus. I tried that and it only returns the first three rows. The log looks fine. Nothing in red.

RobertHuey · ‎09-24-2014

How can you use the XSD file to import your XML file?

RobertHuey · ‎09-24-2014

Hi all, Is there a way to import an XML file while using a corresponding XSD file? All suggestions are welcome. Thank you.

RobertHuey · ‎09-22-2014

That's perfect. Thank you!

RobertHuey · ‎09-19-2014

Hi all, When I am plotting a graph using SGPLOT, SAS reorders my observations when plotting the bars for each month using a VBAR statement. I was curious to see if there is a way to keep the original order of the observations. The table looks as follows... Month Count January 100,000 February 200,000 March 300,000 .... When graphed, the month names get all mixed up and out of order. Please let me know if you have any solutions! Thanks!

RobertHuey · ‎09-18-2014

Thanks again Arthur. In doing so, it has a note that says that no rows were selected in the log. Should that be a concern?....Actually it turns out that it didn't select my data. None of the variables were converted when using double quotes and the macro variable. Also, is there a way to keep one of my variables that is already stored as a character variable as a character variable? Sorry for the confusion!

RobertHuey · ‎09-18-2014

Thank you for your response! I have a question about my memname. I tried using a macro variable with an ampersand and it couldn't read it. It looks as follows... memname='monthreport_&month' Is there a way to deal with this? Also, when I do memname='monthreport_april', it converts my character variable, month. Is there a way for me to keep that variable as a character variable? Thanks again!

RobertHuey · ‎09-18-2014

Hi all, Is there a way for me to convert a dataset of 14 character variables and one numeric variable to all numeric variables without having to use input statements? I would also like to keep the names of the variables too. Is there a way to do this in an array? Thanks in advance!

RobertHuey · ‎09-11-2014

Hi all, Is there a way for me to pull all values in a column that are unique? I combined two monthly datasets and some of the primary keys are unique when combined, not all of them though. Is there a way to pull just the unique primary keys without using PROC SQL? I dropped some of the variables so I can't use PROC SQL according to the log. Also, I tried using PROC SORT and the NODUPKEY. I forgot that it keeps one set of the duplicate records but I want to get rid of both sets of the duplicate records. Let me know of any suggestions! Thanks!

RobertHuey · ‎09-08-2014

Is there a way for me to output all of my tables generated from my PROC FREQ procedure into one dataset? I'm counting the number of null values in my dataset and would like to know if I can. Thanks in advance.

RobertHuey · ‎09-05-2014

You're right. The modifier worked! Thanks!

RobertHuey · ‎09-05-2014

Thanks, Hima but I was using the compare function and not the PROC. See below. result= compare(NamesFromFile, MasterNames)

Online Status	Offline
Date Last Visited	‎10-12-2015 04:58 PM

PROC IMPORT truncating numbers

Re: Maximum number of ticks/months for PROC SGPLOT

Maximum number of ticks/months for PROC SGPLOT

Re: XML import

Re: To import XML file (Hierarchical structured) into SAS

XML import

Re: PROC SGPLOT variable reordering

PROC SGPLOT variable reordering

Re: Converting character variables to numeric

Re: Converting character variables to numeric

Re: Converting character variables to numeric

Re: Converting character variables to numeric

Re: Compare Function

PROC IMPORT truncating numbers

Re: Maximum number of ticks/months for PROC SGPLOT

Maximum number of ticks/months for PROC SGPLOT

Re: XML import

Re: To import XML file (Hierarchical structured) into SAS

XML import

Re: PROC SGPLOT variable reordering

PROC SGPLOT variable reordering

Re: Converting character variables to numeric

Re: Converting character variables to numeric

Converting character variables to numeric

Pulling unique identifiers

PROC FREQ

Re: Compare Function

Re: Compare Function