About Mscarboncopy

Mscarboncopy · ‎03-14-2025

@TomThank you again. I did not think of this at all. Var1 is actually a string so that was exactly the issue. I transformed it in Numeric and that seems to have solved the issue. I am assuming transforming into numeric is the solution for any trailing? Am I right? As participants can easily add a leading space here and there. I like it that there are different ways to reach the same result. I have to investigate a little more as with your code I am getting an extra ID for some reason, as opposed to when I use the code from KSharp. But I am pulling from my data not the example I gave. Thank you for your guidance. It is really appreciated.

Mscarboncopy · ‎03-13-2025

@Tom @Ksharp What I am getting with Ksharp's code. It is what I need but I need the values to be there as well as the ID. OBS ID Var1 P1 P2 P3 P4 P5 B1 B2 B3 B4 B5 1 2222 9 1 C 2 3 2 3456 1 2 A 3 4 3 7689 4 5 D 6 7 4 8796 5 6 B 7 8

Mscarboncopy · ‎03-13-2025

It is so odd @Tom. I tried your code and this is what I get. We have data being collected separately and this is why the same participants are getting different IDs. I am trying to merge the files and keep one ID (which is in my example var ID) and one record per participant. When I do it the way Ksharp suggested I get them all in one record but I am missing all the data from Set1 This is your suggestion I will post next what I am getting with Ksharp's idea. Thank you for your patience. OBS new_id ID Var1 P1 P2 P3 P4 P5 Record_id B1 B2 B3 B4 B5 1 15 2222 15 9 1 C 2 3 2 10 3456 10 1 2 A 3 4 3 20 7689 20 4 5 D 6 7 4 12 8796 12 5 6 B 7 8 5 3 3 2222 C 5 6 7 8 6 1 1 3456 A 2 3 4 5 7 4 4 7689 D 9 1 2 3 8 2 2 8796 B 1 2 2 4

Mscarboncopy · ‎03-13-2025

Thank you @Tom . When I do that I have 2 records per ID in my merged file, as the variables are not all the same aside from Var1. I need a file with only one record per ID. I tried what Ksharp suggested and it worked, pending troubleshooting why the values from my set 1 are showing up as missing.

Mscarboncopy · ‎03-13-2025

Thank you @Ksharp This is exactly what I needed. I have a file "want" with only one record per id. All variables are in there (except the one I wanted to get rid of, after matching which is great) record_ID There is only one issue, for some reason all variables from set 1 have missing values, including id. I added all the variables here as indicated: h.definedata('id','P1', 'P2', 'P3', 'P4', 'P5'); Not sure what to do to make sure the values are not turned into missing.

Mscarboncopy · ‎03-12-2025

Hello. I have the following 2 data sets with different variables that I need to merge into one. My problem is that the second file ID is different from the first. The common var is only VAR1. I am not giving examples for what is in the other variables in each set as I do not think they will give me an issue. Just listing the names here for an idea of what my outcome would look like. Is there a way to reassign a record ID based on a common var like this? I would imagine creating a new ID var - dropping var record_ID and then renaming the new ID ID like in SET1. I can merge the file by VAR1 but it is not the output I am looking for, as I get 2 records per ID. SET 1 input ID Var1 P1 $ P2 P3 P4 P5; Datalines; 1 3456 2 8796 3 2222 4 7689 ; SET 2 Input record_ID VAR1 B1 B2 B3 $ B4 B5; Datalines; 10 3456 12 8796 15 2222 20 7689 ; What I need is to make record_id 10 12 15 20 become 1 2 3 4, based on that common VAR1 and have all variables in one record. Like this: ID VAR1 P1 P2 P3 P4 P5 B1 B2 B3 B4 B5 1 3456 2 8796 3 2222 4 7689 Thank you!

Mscarboncopy · ‎08-29-2024

One last thing. How do I make all of these labels a little bigger on each of the axis? Thank you!

Mscarboncopy · ‎08-29-2024

Thank you!

Mscarboncopy · ‎08-29-2024

I figured it out. It was my variable formatting. Now what I can't figure out is how to remove these tick mark on the Age axis. I do not need the 1.5 or 2.5. This is being generated in the code I shared and I cannot figure out how to change it. Thank you again.

Mscarboncopy · ‎08-29-2024

Hi I am trying to create a simple graph with age group and gender but somehow it is not working. This is my code and the graph. I do not understand why it is spliting my age groups Proc format; Value agef 65-69 = 'Age 65-69' 70-79 = 'Age 70-79' 81-84 = 'Age 81-84' ; run; Data newfinal; Set FINAL; Format age agef. Region reg.; run; axis1 label=('Number of People') minor=(number=1) offset=(0,0); /* Define legend characteristics */ legend1 label=none value=('Men' 'Women'); /* Chart the values of AGE */ proc gchart data=newfinal; hbar age / subgroup=gender legend=legend1 autoref clipref coutline=black raxis=axis1; run; /* Add order= to response axis */ axis1 order=(0 to 24 by 2) label=('Number of People') minor=(number=1) offset=(0,0); /* Modify midpoint axis label*/ axis2 label=('Age' j=r 'Group') /* Create chart */; hbar3d age / freq freqlabel='Total in Group' subgroup=gender autoref maxis=axis2 raxis=axis1 legend=legend1 coutline=black width=3.5 space=2; run; quit; all numeric but I formatted the age to be able to show in the graph - might be what is causing the issue, the original data is numeric with the actual age of each participant. ID Age gender 1 Age 70-79 2 2 Age 65-69 1 3 Age 65-69 2 4 Age 81-84 1 5 Age 65-69 1 6 Age 65-69 2 7 Age 81-84 2 8 Age 81-84 2 9 Age 81-84 2 10 Age 65-69 2 11 Age 65-69 2 12 Age 70-79 1 13 Age 65-69 2 14 Age 65-69 2 15 Age 70-79 1 16 Age 65-69 2 17 Age 70-79 2 18 Age 65-69 2 19 Age 70-79 2 20 Age 65-69 1 21 Age 81-84 2 22 Age 65-69 2 23 Age 70-79 2 24 Age 65-69 2 Thank you!!!

Mscarboncopy · ‎09-06-2023

Absolutely. Thank you. I went back and found the issue in the code where I was dropping Source. Also, thank you for the idea you gave me of how to use source. I really like that. Best,

Mscarboncopy · ‎09-05-2023

I am sorry. I changed the second obs at the last minute, but did not change it in the input code. It was supposed to be 3 and 6 in the input also, to show that I might have a 3 but not have a 1. These values are not tied to anything and can be random. I would never have the same value repeating for any given Id. They are "sources" of documents used to code the data (i.e. the other variables in the file). A record (id) can have 1 source or more (up to 7). The reason to create new "values" is because a few Ids have only one Obs but more than one source and in those cases, the second and third source were dropped. The data file is created by merging a few different files. Would my only option be formatting the variable A to be wide and then use an array to assign the combinations? Ideally, I would end up with a long data set, as all the other variables are in that format. Thank you for your help @ballardw

Mscarboncopy · ‎09-05-2023

I need to create a new var (newvarA) with values starting on 8 from a variable A (1-7). The new values would be based on combinations of values in the first var (A). Any value that is not in the combination must be retained. 8 for example would be given when 1 and 3 are coded. 9 for 1 and 5. I might have one more combination to make. I tried this (below) and it is not working but I know this is too simplistic and I tried to find resources and could not. My output is all missing for newvarA. And I also do not know how to retain the single values. The missing values (always after the last value for each ID) also need to be retained, as the data file has other variables that create those missing values in A. I would appreciate any help. I use sas 9.4 Thanks, Data want; set have; if A ne . then do; if (A = 1 and A =3) then newvarA=8; if (A = 1 and A =5) then newvarA=9; end; run; DATA test; INPUT ID A ; CARDS; 1 1 1 3 1 5 1 . 1 . 2 1 2 5 3 1 3 . 3 . 3 . 4 1 4 3 4 . 5 1 5 2 5 5 5 . ; RUN; desired output ID A newvar A 1 1 8 1 3 5 1 5 . 1 . . 1 . 2 3 3 2 6 6 3 1 1 3 . 3 . 3 . 4 1 8 4 3 . 4 . . 5 1 9 5 2 2 5 5 . 5 . .

Mscarboncopy · ‎06-22-2022

This gave me exactly what I needed. I appreciate the patience.

Mscarboncopy · ‎06-22-2022

Thank you. This is what I had in mind. Will try it out. Difficult to show an output in this case. How would someone show an output for flagging ? My desired output is not the removal of the duplicate dates, it is simply flagging them.

Online Status	Offline
Date Last Visited	‎10-06-2025 11:32 AM

Re: Date format

Re: Date format

Re: Date format

Re: Counter with memory

Re: Counter with memory

Counter with memory

Re: Date format

Date format

Re: New warning

Re: New warning

Re: Counter with memory

Re: Date format

Re: New warning

Re: New warning

Re: New warning

Re: Date format

Date format

Re: Cleaning up a 3D chart

Re: Merging 2 data sets and assigning the same record_id based on comm...

Re: Merging 2 data sets and assigning the same record_id based on comm...

Re: Merging 2 data sets and assigning the same record_id based on comm...

Re: Merging 2 data sets and assigning the same record_id based on comm...

Re: Merging 2 data sets and assigning the same record_id based on comm...

Merging 2 data sets and assigning the same record_id based on common v...

Re: How to create a nice graph with age group and gender

Re: How to create a nice graph with age group and gender

Re: How to create a nice graph with age group and gender

How to create a nice graph with age group and gender

Re: Creating a new variable based on combination of values in another ...

Re: Creating a new variable based on combination of values in another ...

Creating a new variable based on combination of values in another vari...

Re: flagging same dates across different date var

Re: flagging same dates across different date var