About SannaSanna

SannaSanna · ‎11-27-2020

Hi. I'm here again looking for help. This is the best place ever!! I am trying to run frequency counts for a large group of data by age. I need to run counts by specific age numbers as well as age groups. (The Age Groupings are the same ID patients but they are grouped) Is there a way to run this in one step? Thank you so much everyone! Here is a sample of my data: ID Age Quad Smi12 3 N Cha890 2 N Tse2987 18 S Bra7650 22 N Gon12409 31 N Rod23433 35 S Here is the output I want: Output Age Quad Freq 3 N 1 2 N 1 18 S 1 22 N 1 31 N 1 35 S 1 0-5 N 2 6-18 S 1 19-35 N 2 19-35 S 1 data re4; input ID $ Age $ Quad $; datalines; Smi12 3 N Cha890 2 N Tse2987 18 S Bra7650 22 N Gon12409 31 N Rod23433 35 S ; run; proc freq data=re4; tables age*quad/list missing;run;

SannaSanna · ‎11-17-2020

Hi. I have a table with categories that I need to merge into another table table. Unfortunately for me, there are no common columns to merge by. Can this be done? I need each row (from table1) to merge with every row in my second table. Does anyone have suggestions on how I may do this? I have over 10,000 rows from my first table that I must add from table 2. Here are a few records and an example of my expected output: Thank you for any help! Table 1 ID GEO 22454 C56 845880 C37 842387 C19 Table 2 PID_Item LEF FEH PHE MOH Output: ID GEO PID_Item 22454 C56 LEF 22454 C56 FEH 22454 C56 PHE 22454 C56 MOH 845880 C37 LEF 845880 C37 FEH 845880 C37 PHE 845880 C37 MOH 842387 C19 LEF 842387 C19 FEH 842387 C19 PHE 842387 C19 MOH

SannaSanna · ‎09-09-2020

Hi. Thank you for your help! My datasets are extremely large and having difficulty with resources and I just provided a brief example of the data. Perhaps the set of data I provided was not a good example, but I have also used Proc SQL to tie the tables together and still missing records. The merge is technically correct using the parameters to merge, however, there are missing join records. Is it true that the SAS PDV runs through the data once and if successful moves on to the next record to merge? What happens if one of my tables have some exact same row records (customer & lots of demographics) and the other table is a table of providers. After merging by 'Rx' (providers Wit & Wan) serve the same customers and possibly on same day. When merging (sorted by provider) it seems the merge is successful for the first sorted provider (Wan) but all those customer records did not merge with the second provider(Wit). Is it that the SAS PDV moves on/finishes after initial succcessful merge even though there are second possible successful merge? I'm stumped.

SannaSanna · ‎09-08-2020

Hi. Below is a sample of the data. I am merging by 'Rx'. My output table (want) is missing the second row for jen. customer table customer table race Rx jen w b12 mik h xyy rob b d20 service table Rx ph b12 wit b12 wan o18 chi xyy gon d20 rie Want jen w b12 wit jen w b12 wan mik h xyy gon rob b d20 rie

SannaSanna · ‎09-08-2020

I think thats it. its a one to many merge. What do you suggest as the best way to accomplish this?

SannaSanna · ‎09-08-2020

Hello!! I have two large tables I am trying to merge. Table 1 is called services and table 2 is customers. I used the data step merge below and it appears that i am missing some records. There can be multiple customers tied to the same service using the 'merge by unitA' but it seems that the code is picking and merging only on the first instance and missing subsequent customer records which should also be matched too but is missing- this is technically working but I am missing customer records. Can this be correct? : DATA YFYS YFNS NFYS; MERGE Service1(in=a) customer1(in=b); by unitA; IF A AND B THEN OUTPUT YFYS; IF A=1 AND B=0 THEN OUTPUT YFNS; IF A=0 AND B=1 THEN OUTPUT NFYS; RUN;

SannaSanna · ‎08-18-2020

Thank you so very much- I've been coding and re-coding Proc Transpose to get this to work, but this produced the exact results I need. Thank you again!!

SannaSanna · ‎08-18-2020

Hello! I am trying to transpose a large table with array columns into rows. I would appreciate help! Thank you in advance! The data looks like this: ID1 Term1 Term2 Term3 Term4 Term5 Term6 a_78076 7600 7600 9875 4388 3709 er_866455 5436 9468 4009 4388 7600 3288 I need to create individual rows for each of the Term1-6 for each ID. Results to look like this: ID1 Term a_78076 7600 a_78076 7600 a_78076 9875 a_78076 4388 a_78076 3709 er_866455 5436 er_866455 9468 er_866455 4009 er_866455 4388 er_866455 7600 er_866455 3288

SannaSanna · ‎07-27-2020

Hi !!!!! I removed the 24 digits as length and both of your codes worked exactly the way I want! Thank you so very much!!!!!

SannaSanna · ‎07-27-2020

Hello! Thank you for responding. I am also unable to successfully run the first portion of the code? Perhaps I do not need string of 24 digits-- could that be the reason for the error message below? My log gives me an error of: WARNING: In a call to the CATS function, the buffer allocated for the result was not long enough to contain the concatenation of all the arguments. The correct result would contain 28 characters, but the actual result might either be truncated to 24 character(s) or be completely blank, depending on the calling environment. The following note indicates the left-most argument that caused truncation. NOTE: Argument 7 to function CATS('9999','9999','9999','9999','9999','9999','9999') at line 703 column 19 is invalid.

SannaSanna · ‎07-27-2020

Hi. Thank you for responding. I made attempt to use your code and I'm erroring out. My log tells me : ERROR: Illegal reference to the array tm, AND after the 'end' statement there is no matching do/select statement? Can you re-help?

SannaSanna · ‎07-27-2020

Hello SAS community! I love and appreciate all the help from this community. I’m seeking help with the following. I have a database containing individuals submitting information during 6 different periods. I am looking to 1) create a new string variable (24 bytes) which combines the data together from all 6 periods (4 bytes each). Maybe a concatenation? However, there may be blanks during a period in which I would like to input as ‘9999’. How can I do this? 2) I would also like to identify the individuals who submit the same receipts during different terms? Examples are the last two individuals (Term1 & Term5) (Term3 and Term6). I would like to create a separate dataset to identify those individuals for further analysis. Can anyone help me? Thank you so much!! ID1 Term1 Term2 Term3 Term4 Term5 Term6 a_78076 7600 9875 4388 3709 er_866455 5436 9468 4009 4388 7600 3288 ik_33442 9865 4009 6783 9865 3288 ev_965747 5436 9468 3288 4388 7600 3288 Want output and separate dataset for the last two individuals who submitted same receipts: a_78076 760099999875438837099999 er_866455 543694684009438876003288 ik_33442 986540096783999998653288 ev_965747 543694683288438876003288

SannaSanna · ‎09-29-2017

Also, would I need to change back or would it automatically default back to its original path after shutting down?

SannaSanna · ‎09-29-2017

found it. Its currently -Work "!Temp\SAS Temporary Files" If I am wanting it to be changed to an external drive would I enter the code as follows: -Work "J:\extDrive\bigdata" Exactly like that?

SannaSanna · ‎09-29-2017

Its a laptop and the conf file file is in my program files folder. Its runniing SAS 9.4

Re: _null_ and export file

Re: _null_ and export file

_null_ and export file

Re: First but not Blank

Re: First but not Blank

Re: First but not Blank

Re: First but not Blank

First but not Blank

Re: Finding inconsistencies within a group

Re: Finding inconsistencies within a group

Re: Finding inconsistencies within a group

Re: Finding inconsistencies within a group

Re: Insert rows

Re: Insert rows

Re: Combining data cells which may hold blanks

Groupings

Insert rows

Re: Table merging question

Re: Table merging question

Re: Table merging question

Table merging question

Re: Proc Transpose Arrays

Proc Transpose Arrays

Re: Combining data cells which may hold blanks

Re: Combining data cells which may hold blanks

Re: Combining data cells which may hold blanks

Combining data cells which may hold blanks

Re: Redirect paths

Re: Redirect paths

Re: Redirect paths