About sasnewbie5

sasnewbie5 · ‎12-10-2018

Hmmm, I'm not sure why but when I run it it only shows 14. I did notice that the log says that 18 observations were created but it still only shows 14 in the output. I have absolutely no idea what's going on with this one.

sasnewbie5 · ‎12-10-2018

data Dept1Names; input name $ empid $; datalines; NELSON 254 MITCHELL 362 PEREZ 910 CARTER 935 ; data Dept1Salaries; input salary id $; datalines; 103100 254 100200 362 73500 910 88400 935 ; data Dept1; merge Dept1Names Dept1Salaries; keep name salary; run; /***Problem #2***/ data Dept2; input name $ salary; datalines; ROBERTS 74000 TURNER 89200 PHILLIPS 87000 CAMPBELL 104600 PARKER 87800 EVANS 73100 EDWARDS 72300 COLLINS 100500 ; data Dept3; input name $ salary; datalines; STEWART 102600 SANCHEZ 103300 MORRIS 87200 ROGERS 70700 REED 73000 COOK 88900 ; data Employee; set Dept1 Dept2 Dept3; run; The code under "Problem 1" created the first dataset via one to one merging. Then under "problem 2", I'm trying to concatenate the dataset from problem one with the other two newly created datasets.

sasnewbie5 · ‎12-10-2018

Ok so it seems that it does concatenate two of the three datasets. However, the one that I previously created does not concatenate with them. Can anyone provide any insight/solution as to why the first already-merged dataset won't concatenate?

sasnewbie5 · ‎12-10-2018

I have three datasets that I need to concatenate. One was created via a one-to-one merge of datasets, the other two are just regular datasets. I wrote the code but it only outputs data from the second set. I have attached the code I have so far, as well as the two datasets (I can attach the two individual datasets that were used to create the merged dataset called Dept1). Any help is greatly appreciated.

sasnewbie5 · ‎12-10-2018

Thank you so much Reeza!

sasnewbie5 · ‎12-10-2018

Got it, thanks so much for the clarification!

sasnewbie5 · ‎12-10-2018

Thanks Reeza! Is using SQL queries the only way to do an inner join in SAS? So far that's all I've found for creating an inner join.

sasnewbie5 · ‎12-10-2018

Thank you! You mentioned inner joins. All of the examples I've found online are showing it using only SQL statements. Is that the only way to address what you mentioned?

sasnewbie5 · ‎12-10-2018

I have attached a screenshot of the two datasets to this thread. The expected output is to use one-to-one merging to combine the two datasets and then list just the name and salary in the newly created dataset.

sasnewbie5 · ‎12-10-2018

I don't follow. The code I have is as follows: /*******/ data Dept1; set hw8.dept1names; set hw8.dept1salaries; run; /******/ Since I haven't specified any variables, how would I rename it? I'd prefer not to adjust any of the actual dataset content. Also, I have the two datasets that I'm referring to but I'm not sure if I can upload them to this thread or not. As you can probably tell, I'm very new to SAS and the SAS community.

sasnewbie5 · ‎12-10-2018

I have two separate datasets that I want to merge into one new data set. One dataset has the variables "name" and "employee id". The other has variables "salary" and "ID". I need to combine the two data sets and only list the "name" and "salary" variables in the new data set. How would I do that? The code I have so far lists all of the variables in both datasets and I'm not quite sure how to specify only the ones that I want. *Of note, in the first dataset, it's called "EmpID" and in the second it's called "ID". Any and all help is welcomed! Thanks!

sasnewbie5 · ‎12-07-2018

Good to know. I've accepted your solution VDD.

sasnewbie5 · ‎12-07-2018

Ohh ok, I understand now. Thanks guys!

sasnewbie5 · ‎12-07-2018

Thanks. How do you differentiate between it being a character versus a numeric variable?

sasnewbie5 · ‎12-07-2018

Thank you so very much SuryaKiran

Online Status	Offline
Date Last Visited	‎12-13-2018 11:42 AM

Re: Format variables in dataset

Format variables in dataset

Re: Create multiple datasets using one datastep

Create multiple datasets using one datastep

How to create dataset from raw data file?

Re: How to format date when creating a dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to create a character and numeric value with provided code?

Re: How to concatenate 3 datasets

Re: How to concatenate 3 datasets

Re: How to concatenate 3 datasets

How to concatenate 3 datasets

Re: How to create a new variable while using one-to-one merging

Re: How to create a new variable while using one-to-one merging

Re: How to create a new variable while using one-to-one merging

Re: How to create a new variable while using one-to-one merging

Re: How to create a new variable while using one-to-one merging

Re: How to create a new variable while using one-to-one merging

How to create a new variable while using one-to-one merging

Re: How to create a character and numeric value with provided code?

Re: How to create a character and numeric value with provided code?

Re: How to create a character and numeric value with provided code?

Re: How do I create new variable from another variable