About GN0001

GN0001 · ‎01-19-2022

Hello team, Please disregard datatype. We have two data types in SAS: character and number Here what I need is to make these two look same: v123.12 and v12312 I need the second one look like first one. Respectfully, BlueBlue

GN0001 · ‎01-19-2022

Hello team, I have two datasets. One has a variable with character datatype as d123.22, the second dataset has a variable with character datatype as d12322. I need to make them consistent to be able to join them through this field. How can I reach there? Regards, BlueBlue

GN0001 · ‎01-19-2022

Hello team, I am going to join two datasets through a common field. But the variable in one dataset has this format: 1000 and it has this format in second dataset: 1000*01. How can take *01 from the second dataset to make variables look same. Regards, BlueBlue

GN0001 · ‎01-17-2022

/* data1, data2, data3, data4*/ %let readFrom = data1; data thisdata; set &readfrom; run; Hello team, On the code on the top, The macro variable readFrom reads from data1, data2, data3 and data4. Each time we replace readfrom variable macro with data1, data2, data3 and data4 I want to save the result thisdata in a table , which is read from data1 and then append to it thisdata when readfrom variable is replaced by data2. We keep the result data1, then append to it data2, then data3 and data4. Any help is greatly appreciated. Regards, blueblue

GN0001 · ‎01-10-2022

Hello, What does this mea: all values not assigned to other "pictures"? regards blue

GN0001 · ‎01-02-2022

hello team, Cleaning Data data cleanme; input group$ kilograms; cards; A 53.4 B 76.3 A 45.3 A 98.4 a 67.3 A 98.3 A 68.3 B 28.4 B 67.3 B 37.4 A 68.3 A 79.2 A 56.4 run; 1. Create a new dataset called cleanfinal from cleandata. 2. Set values for the Kilograms variable to between 20 and 40, inclusively. 3. If values in Kilograms are missing, or not in the 20 to 40 range, replace with the median Kilograms value found . (hint: you will do some conditional logic for Group 'A' and 'B', and you will set median kilograms for A and B)

GN0001 · ‎01-02-2022

Hello team, This code doesn't produce the result that is needed: data countrydata; input EmployeeID Province$ PostalCode$ Country$; cards; 737874 Ontario N0H1G0 CAD 876098 Quebec H4S1Y9 CAD 456231 Alberta T0J1K0 cad 874572 Manitoba R0K0V0 CAD 680562 Ontario K0K1A0 cad 737874 Ontario N0H1G0 CAD 874598 Quebec H4S1Y9 USA 455731 Alberta T0J1K0 cad 874372 Manitoba R0K0V0 CAD 680462 Ontario K0K1A0 cad 737374 Ontario N0H1G0 CAD 876298 Quebec H4S1Y9 CAD 456431 Alberta T0J1K0 USA 874572 Manitoba R0K0V0 CAD 6430362 Ontario K0K1A0 cad 737274 Ontario N0H1G0 CAD 873098 Quebec H4S1Y9 CAD 465633 Alberta T0J1K0 cad 874357 Manitoba R0K0V0 CAD 6834562 Ontario K0K1A0 cad run; data countrydata2; set countrydata; where Country = upcase(cad); run; Proc sort data= countrydata2 out = subsetme nodupkey; by ascending Country descending PostalCode; run; If we want to use ascending, can we do that? where Country = upcase(cad); doesn't filter the data. Any help is greatly appreciated. Regards, BlueBlue

GN0001 · ‎12-29-2021

Hello Reza, I couldn't find this documentation and it is not easy to understand what I am looking for. Many explanations and details about things that I don't need. The documentation helped me to the extent that I can use the picture statement if I want. Regards, blueblue

GN0001 · ‎12-29-2021

I have this code and I wonder what other %b-%y do? what about picture? proc format; picture fmt (default=6) other=%b-%y (datatype = date); run; Regards, blueblue

GN0001 · ‎12-29-2021

Hello team, I have the code below: I want to know why this part: trim(put(mbrDes,$CON.)) equals to DSS, it doesn't get equal to whole string. The code below doesn't generate errors: proc format; values $CON 'b' = 'DSS- PP' Run; Data want (Keep = mbrDes); format LineofBu $60. system $5; set have; LineofBu =trim(put(mbrDes,$CON.)); if LineofBu =: 'DSS' Then system = 'DSS'; run; Regards, blueblue

GN0001 · ‎12-20-2021

Hello all, What I mean is to receive one observation for those rows that are same if those observations are sorted properly. I don't know what word I need to use instead of grouping. I know in SAS before grouping, I need to sort my data. Thanks, blueblue

GN0001 · ‎12-20-2021

Hello team why don't I get a group by this code? data test1; input id sys dia; datalines; 1 23 24 1 23 24 2 12 13 ; Run; data grouping; set test1; by id sys dia; run; Am I not supposed to get only for rows for 1 23 24? Please advise me. Regards, Blueblue

GN0001 · ‎12-19-2021

This syntax didn't work: A subquery can not select more than one column... usually a subquery is used incorrectly in an expression proc sql; select * from have as a where dt=(select MAX(dt) from have as b WHERE a.id=b.id); quit; How can I fix this issue? Regards, Blueblue

GN0001 · ‎12-13-2021

Kurt, Can you please explain about this? thanks Blue blue

GN0001 · ‎12-11-2021

Hello Patrick, Something came to my mind. If memberId are same but observations are different across rows, then what happens? Thanks for your input, Blueblue

Online Status	Offline
Date Last Visited	‎07-29-2023 03:52 PM

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

How to use rename and drop statements in a data step

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: how to add a new variable in an assignment statement

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

call symputx vs. symput

what does && means in a macro in SAS?

Can anyone kindly please explain about this syntax as what it does?

Where clause requires a compatible variable.

To find the difference of two dates

Re: How to clean data to be able to join through it?

How to clean data to be able to join through it?

Join two sets of data with a field with a character data type

Append the result datasets

Re: what does proc format with picture do?

Replace missing with Median value

Ascending Descending sort where

Re: what does proc format with picture do?

what does proc format with picture do?

What does trim(put(mbrDes,$CON.)) generates?

Re: How grouping work in SAS

How grouping work in SAS

Re: How can we keep the most recent data with proc sort?

Re: How can we keep the most recent data with proc sort?

Re: How can we keep the most recent data with proc sort?