About jerry898969

jerry898969 · ‎04-09-2013

Ballardw, Thanks for the reply. Would that when belong to another case statement? Within this contatnation i'm doing there will be multiple variables that could be null and if they are I don't want the text that identifies them to display. I want it to display only if there is data. Thanks

jerry898969 · ‎04-09-2013

I have a proc sql statement that I'm trying to check if a variable is null or not. proc sql ; create table x as select id, case when Search = 'Yahoo' then '<a href="www.yahoo.com">Yahoo</a>' || ' ' || ?????? quit ; At this point I want to replace ?????? with a way to check my variable to see if there is data or not. If there is I want to add more text if not then continue to the next step. I want to add brackets around my value if it isn't null. Ex. The variable has data : Yahoo [Bob] Ex. The variable no data : Yahoo Thanks

jerry898969 · ‎02-22-2013

Thanks again for all the help. I was able to find a file that had address geocoded and had the postal standardization info which allowed me to track back and get the zip info. Thank you again for all your help.

jerry898969 · ‎02-22-2013

Thank you for your replies I will look at those links and post my results. I understand the address could be the problem but I have no choice but to try and get zipped based on address if nothing is returned or found then I can investigate those address. Thank you

jerry898969 · ‎02-22-2013

Hi Linlin, I agree that that is true but there should be a way to do that and have a flag that says if the address was found or not. At least that is what I'm hoping there is. Thank you

jerry898969 · ‎02-22-2013

I have addresses with incorrect zip codes. I wanted to create an automated process that would take each address and get the correct zip code. I have over 700 and doing them manually would take a very long time. Any help would be greatly appreciated. Thank you

jerry898969 · ‎02-22-2013

Hi Cynthia, Thank you for your reply. The issue has been resolved. The data that was orginally sent to me was incorrect and they are working on correcting it and sending it in a different format. Thank you once again for all your help

jerry898969 · ‎02-14-2013

Hi Cynthia, Thank you so much for your reply. I have to do this process in a sas program so I can't use the XML mapper. What i'm trying to do is store this data in a sas dataset. I have to have the output like the example I posted. There is another process that takes this data set and uploads the data to a different database. I don't think the scan function is going to work for my situation. There are some that have label="""TEMP 1""" and i'm not sure how to parse that out. Any other help you can give me would be appreciated. I want to eventually make it a macro. Thank you

jerry898969 · ‎02-14-2013

I have an xml file that was sent to me from an outside source. What I need to do it parse it so I have all the tag and property info put into a table. I have tried importing it as an xml file but the file isn't formatted correctly. I have no say in how the file comes to me so I decided to import the file and pull the info out myself. This is just a small example of some of the stuff within the file. <prj name="Test Prj"> <Level1 name="L101B"> <codes val="1" label="Temp 1" /> <codes val="2" label="Temp 2" /> <codes val="3" label="Temp 3" /> . . . </prj> Some tags have up to 9 properties so I know a loop will do it but I can't figure out how to grab each lines of info. Example output Table Tag Property1 Value1 Property2 Value2 ... prj name "Test Prj" Level1 name "L101B" codes val "1" label "Temp 1" codes val "2" label "Temp 2" codes val "3" label "Temp 3" Thank you for your help

jerry898969 · ‎12-11-2012

Sorry I didn't explain it better. It is the length of the text field I need these statistics for. I will try those procs thanks.

jerry898969 · ‎12-11-2012

Reeza, Thank you for your help I will try that out. Is there a proc that can give me mean, median and mode all at once? If not what would be the best approach to calcualte mean and median? Thank you so much

jerry898969 · ‎12-11-2012

I have a column that has text in each row. I was assigned to find the mode of this column by my manager. I have never heard of mode in this respects so i'm not sure how I would calculate it in sas. Any help would be great appreciated.

jerry898969 · ‎04-23-2012

Thank you so much that did what I needed. Thanks

jerry898969 · ‎04-23-2012

Is it possible to convert as sas data file (.sas7bdat) to an ascii file? We have data and a user is unable to use sas and needs the data in an ascii format. I've never had to do this before and i'm unsure of where to start. Any help would be greatly appreciated.

jerry898969 · ‎03-23-2012

Tom, Thank you so much. That extra check if time < '12:00't corrected an issue I was running into was the time in seconds was greater then 86400. I will eventually be using the date and time together to get the difference but for now my lead just wants me to deal with time. I have my rows in the order they appear in the log file. sec tab var date time 1 1 1 01/01/2010 09:05:26 AM 1 1 1 01/01/2010 09:05:46 AM 1 1 2 01/01/2010 09:05:46 AM 1 1 2 01/01/2010 09:05:48 AM 1 1 1 01/01/2010 09:06:01 AM 1 1 1 01/01/2010 09:06:09 AM If I use the diff function it will do a minus from a current row from the previous row. Without sorting my data since I need the times to be in the correct order how can I get it to be. sec tab var diff 1 1 1 00:00:20 1 1 2 00:00:02 1 1 1 00:00:08 After this point I can go a sum in a proc sql and sum up total time spent on each combination sec tab var diff 1 1 1 00:00:28 1 1 2 00:00:02 Thank you again to everyone for your help

Online Status	Offline
Date Last Visited	‎05-17-2021 12:05 PM

ODS PDF knowing how many rows before page break

Re: Proc GINSIDE Optimization

Re: Two-way freq doesn't show the variable names when displayed

Re: Two-way freq doesn't show the variable names when displayed

Two-way freq doesn't show the variable names when displayed

Re: Use different select value in proc sql based on variable

Use different select value in proc sql based on variable

Re: Right arrow character causes problems only when logging with proc ...

Right arrow character causes problems only when logging with proc prin...

Re: Break up string using count function and how to loop through it

Re: seach text file based on obs in data table

Re: create data rows depending on value in column

Re: create data rows depending on value in column

Re: Add leading zero based on the number of numbers for that value

Re: Add leading zero based on the number of numbers for that value

Creating Macro variables based on min max of id field

Creating Macro variables based on min max of id field

ODS PDF knowing how many rows before page break

Re: Two-way freq doesn't show the variable names when displayed

How to check if server is configured as a unicode server

Re: How to check if a var is null within Proc SQL

How to check if a var is null within Proc SQL

Re: Is it possible to get a zip code based on an address within SAS?

Re: Is it possible to get a zip code based on an address within SAS?

Re: Is it possible to get a zip code based on an address within SAS?

Is it possible to get a zip code based on an address within SAS?

Re: Pulling out tag info from xml file

Re: Pulling out tag info from xml file

Pulling out tag info from xml file

Re: How to calculate mode for length

Re: How to calculate mode for length

How to calculate mode for length

Re: SAS data set to an ASCII file

SAS data set to an ASCII file

Re: Calculate time between rows