About jerry898969

jerry898969 · ‎09-17-2015

Thank you so much. I need to add more data to the end of each row for use in another process. That did it. I tested it with one row and I was able to split it up and add the data to the end then put it into another text file. Thank you

jerry898969 · ‎09-17-2015

thank you data_null_, I need each row to come in as a single row. The lengths of each row vary and they are larger then 32767. Is that the max length of a character variable field?

jerry898969 · ‎09-17-2015

Hello, I have a file with varying row lengths. I only want one variable in my table that has each full fow in it. This is what I have so far and it doesn't bring in the full row data temp ; infile file1 lrecl=390000 ; input x $ ; run ; I know it's something simple, but I can't seem to figure it out. Thank you

jerry898969 · ‎09-17-2015

Hello, I have a text file is is comma delimited. The file has double quotes(") as the text identifier. I have 2 similier columns. One has data and the other one does not. 1,, When EG imports this it says the first is numeric and the second column is character. I thought it needed double quotes for it to be considered text and make that column character. I want that column to be numeric like the first one. I do have columns where there are double quotes and those are character. I could manually change it in EG, but I have thousends of columns and I want to make sure they are getting the correct data type assigned to them. Thank you

jerry898969 · ‎09-16-2015

Thank you RW9 and Ballardw for your responses. We have a very large data processes that has changed and we were forced to take a different route. We wanted the import to have a systematic naming convention so in our other programs we could loop through the variables. What I'm working on now is just creating my own naming for each column and importing it with getnames=yes. I know that is a very large amount of columns. We used to use a different application but they have changed it and now instead of getting multiple tables they are giving us just one wide one. It will be split up into many smaller tables. Thank you again both of you for your help.

jerry898969 · ‎09-15-2015

I have a large xlsx file with no headings just data. I'm expecting sas to import the file and name each variable after what column it is in. For example the first variable is name "A" and so on till "ZZ". After "ZZ" I get var703 and it continues incrementing from there till it gets to var11664. How can I keep it using the column letters or make all the variables have var and the column number? This is the sas code I'm using proc import datafile="c:\temp\temp.xlsx" out=temp dbms=xlsx replace ; getnames=no ; guessingrows=2147483647 ; run ; Thank you

jerry898969 · ‎09-11-2015

Hi ballardw, Thank you for all your suggestions. I was able to convince my lead to take the file to excel and create an xlsx file first before importing. That fixed it. There is more work that I will have to do but at least I'm variables I checked are getting the right types. Thanks again for your help

jerry898969 · ‎09-10-2015

Hi ballardw, I tried the datarow=2, but that didn't fix it either. I also noticed that the number of variables is incorrect when I do proc import. Does proc import automatically create valid sas names if the variable name is not? My variable names have "[" "]" as part of the names. I'm losing about 4,000 variables. Thank you

jerry898969 · ‎09-09-2015

Hi ballardw, Thank you for your reply. I have 11,664 variables in this text file that I'm reading in. The 3rd column is a year column so all the data within it is a 4 digit numeric value. There are no special characters within that field. Could the first line being the variable names and text cause it to default to character?

jerry898969 · ‎09-09-2015

I have a text file that is comma delimited and it has double quotes around the character fields. I have one header row and almost 1500 data rows. When I run this code it returns columns that are supposed to be numeric as characer. How can I fix this? proc import datafile="c:\temp\DBData.txt" dbms=dlm out=tempData replace ; delimiter="," ; getnames=yes; guessingrows=max ; run ; Thank you

jerry898969 · ‎08-10-2015

Hi Reeza, If I'm able to figure it out I will definitely post it here. Jerry

jerry898969 · ‎08-10-2015

Thank you Darrell. I have been unable to find anything that I could use just with SAS. I don't want to use a 3rd party site or software due to the sensitivity of my data. Someone suggested STATA has functions that calculate driving distance so I'm going to look into that. I guess I could calculate it with STATA then bring it back to SAS for the rest of the work. Thank you again, Jerry

jerry898969 · ‎08-10-2015

Hello, I have to find a way to calculate the actual driving distance not overhead distance but street driving. I'm not sure what the best way to approach this would be. I did see there is a function called Geodist but I'm not sure if that returns the overhead distance or street driving distance. I'm using sas 9.4 TS1M2. Thank you for any help you can give me.

jerry898969 · ‎08-04-2015

Thank you SASKiwi. That is what I ended up finding last night and I'm looking into it now. Thanks

jerry898969 · ‎08-03-2015

Is there are product or process within SAS where I can pass in a large list of addresses and have the correct address returned? I have a large file with many issues with the addresses and I'm unable to use an API or anything online. It all has to been done locally because of confidentiality issues. Any help would be appreciated. Thank you

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: Import text file with string longer than 32767

Re: Import text file with string longer than 32767

Import text file with string longer than 32767

Import within Enterprise Guide giving incorrect data types

Re: Importing excel with over 11,000 columns causes varname to change

Importing excel with over 11,000 columns causes varname to change

Re: proc import creating numeric variables as character

Re: proc import creating numeric variables as character

Re: proc import creating numeric variables as character

proc import creating numeric variables as character

Re: Driving distance between 2 lat & lon points

Re: Driving distance between 2 lat & lon points

Driving distance between 2 lat & lon points

Re: Standardization of US addresses

Standardization of US addresses