About jerry898969

jerry898969 · ‎01-18-2010

I was wondering how to create a data diagram using sas? Is it possible to use SAS through VISIO? I have a 60 table directory that I need to represent to my bosses and I'm not 100% how to do that without having to go to a different database software to do it. Thank You for any help

jerry898969 · ‎10-23-2009

_null_, Thank you so much for your help. I only had a bit to test it but it seems to be dead on. My full set is only around 1100 rows so it's small enough for this to work good. Thanks again

jerry898969 · ‎10-23-2009

_null_, Thank you for your reply. I have another issue that just popped up. How can I do this based on a user column? I have a user column and I have to take the top 20 rows per user and the first row of every 10 for each user. I do apologize for my newbie questions. Thanks for all the help

jerry898969 · ‎10-21-2009

_null_, Thank you so much I just got out of a meeting where they changed the requirements. Now I have to take the first 20 then the first row out of 10 row chunks. So first 20, 21,31,41 till the end. Do I still need to use SurveySelect to do this or can I do it a more simple way? Thank you again for your quick response.

jerry898969 · ‎10-21-2009

I'm having a hard time grasping how to use SURVEYSELECT. I have a data table that I need to take the top 20 rows then a random sample row out of 10 row chunks till my entire dataset has been gone through. So I have the first 20 then from 21 to 30 I need to randomly pick a row. Then from 31 to 40 I need to randomly pick another row and so on till it goes through my dataset. Is this possible use SURVEYSELECT? Any help would be greatly appreciated Thank You

jerry898969 · ‎10-01-2009

I fix that issue by using the correct DB. Sorry I wanted to delete the post not sure how.

jerry898969 · ‎10-01-2009

When I create a libname to my ms access db it only shows me the tables not the queries. Can this be changed? I have created some view tables within microsoft access and the only way to do that is with a query. I need to be able to view that ms access view table in sas. Thank you

jerry898969 · ‎10-01-2009

_null_ & Cynthia, Thank you so much for all your help. I got it using catx('0d0a'x,a,b); I opened my access data in a form and the rows were split. Thank you so much

jerry898969 · ‎10-01-2009

Thank you both for your replies. _null_ your solution looked like it was going to work but when I try and display it in a form it shows "THIS IS A TEST JUST A TEST" with a small box character between them. Your proc export statement helps me for a completely different issue. Thanks for the help. Cynthia, I did like you said and exported the data to a text file and then looked at it with a binary/hex viewer. It looks like 0D 0A is what is the hex value for carriage return and line feed. I'm sorry if you mentioned this but how within SAS can I add this to my string? I'm do apologize if I'm not grasping it correctly. Thank you

jerry898969 · ‎09-30-2009

Cynthia, Thanks for all your help but i'm still having problems. I'm pretty much taking SAS Data and exporting it to Microsoft Access. What I need to do is have the string I create in SAS display correctly in Access. I wanted to see if there was a carriage return or line feed character in SAS so when it exports to Access and I display the data will be displayed correctly with a carriage return or line break between the strings I concatenated. Is there such a thing?

jerry898969 · ‎09-28-2009

kmg, I was just going to post a question about that. I'm going to stick with you example for now. It seems to be working good for now. Thank you so much to both of you.

jerry898969 · ‎09-28-2009

Barheat, Thank you so much for your help. I'm going to try what you suggested. Thank You

jerry898969 · ‎09-28-2009

kmg, Thank you so much I think that did it. Do you know if there is a way to put a return between the notes? Currently the field is defined as length notes $32767. If the field is defined as that big is there anything bigger? I have no control over the field size i'm just afraid that if they have 4 rows that have almost that many characters what will happen when it tries to concatenate them? Thanks again for all your help

jerry898969 · ‎09-28-2009

Hello to all, I've run into an issue that I need a bit of help with. I have a table that has a ID, ONum, notes columns. What i'm trying to do concatenate every notes obs into one obs based on similer ID & ONum with a space inbetween every concatenation. ID ONum notes -- --------- ---------- 11 10001 "This is a Test" 11 10001 " of SAS" 11 10002 "Today the weather was good" 11 10002 "Busy Shopping" 44 19999 "Fishing" 55 77777 "Working on car" 55 77777 "Hunting" 55 77777 "Swimming" After data step I need the data to look like this ID ONum notes -- --------- ---------- 11 10001 "This is a Test of SAS" 11 10002 "Today the weather was good Busy Shopping" 44 19999 "Fishing" 55 77777 "Working on car Hunting Swimming" Thank you to anyone who can help

jerry898969 · ‎09-17-2009

Daniel and Scott, Thank you both for your replies. I was pulled away from this issue till tomorrow so I didn't mean any disrespect by not replying right away. I stated the size incorrectly. My original table is about 16mb(1,600K) when I do the data step that table becomes 220mb(220,000K). So i'm going from a small table to a really big table. I will definitely do all your suggestions ASAP 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

How to diagram SAS set of tables?

Re: Best way to use PROC SURVEYSELECT

Re: Best way to use PROC SURVEYSELECT

Re: Best way to use PROC SURVEYSELECT

Best way to use PROC SURVEYSELECT

Re: Libname/Microsoft Access

Libname/Microsoft Access

Re: Adding a line feed character when joining two columns into one col...

Re: Adding a line feed character when joining two columns into one col...

Re: Adding a line feed character when joining two columns into one col...

Re: Trying to concatenate strings from multiple obs into 1 obs.

Re: Trying to concatenate strings from multiple obs into 1 obs.

Re: Trying to concatenate strings from multiple obs into 1 obs.

Trying to concatenate strings from multiple obs into 1 obs.

Re: Table size issue