mlogan Tracker

Re: Redistributing numbers

mlogan — Wed, 09 Apr 2025 18:24:57 GMT

Hi RobPratt, I ran your whole code and it gives me the following table. Should I get rid of any part of your code? Thanks.

COURSE	ROOM_NO	ROOM_CAPACITY	ROOM_LOAD	NEW_ROOM_LOAD	Room_Status
CHEM101	C101	20	7	20	Available
CHEM101	C102	20	11	16	Available
CHEM101	C103	10	8	0	Available
CHEM101	C104	15	10	0	Available
BIO302	HB102	22	20	22	Available
BIO302	HB106	24	12	24	Available
BIO302	HB902	30	29	30	Available
BIO302	W102	30	31	30	Available
BIO302	AB102	40	27	13	Available

Re: Redistributing numbers

mlogan — Wed, 09 Apr 2025 18:20:02 GMT

Hi RobPratt, I ran your whole code and it gives me the following table:

Re: Redistributing numbers

mlogan — Wed, 09 Apr 2025 18:18:13 GMT

Hi RobPratt, I ran your whole code and it gives me the following table:

Updating Media

Re: Redistributing numbers

mlogan — Wed, 09 Apr 2025 17:56:23 GMT

Thank you RobPratt. It looks like we can move all students (12) from room HB106 and put them on AB102 and make room HB106 fully available. Also, I want the Room_Status flagged as AVAILABLE only when NEW_ROOM_LOAD=0. Would you please help a bit more.

Re: Redistributing numbers

mlogan — Wed, 09 Apr 2025 15:45:42 GMT

Re: Redistributing numbers

mlogan — Wed, 09 Apr 2025 15:39:34 GMT

Mank thanks Ksharp. Would it be possible for you to populate the column NEW_ROOM_LOAD in the Final_want file so that I know how they were redistributed? I also wanted to ensure that room W102's number went down from 31 to 30. Thanks.

Redistributing numbers

mlogan — Wed, 09 Apr 2025 01:17:27 GMT

Hi there,

I have the following dataset of the school where one course is offered at different classrooms. But in this case some classrooms are not full (ROOM_LOAD) for a given course. I wanted to redistribute the students in classrooms where there is still a capacity left and thus clear out a room and make it available for other use.

DATA HAVE;
    INPUT COURSE $ ROOM_NO $ ROOM_CAPACITY ROOM_LOAD;
    DATALINES;
CHEM101	C101	20	7
CHEM101	C102	20	11
CHEM101	C103	10	8
CHEM101	C104	15	10
BIO302	HB102	22	20
BIO302	HB106	24	12
BIO302	HB902	30	29
BIO302	W102	30	31
BIO302	AB102	40	27
;
RUN;

As a output, I want a table like this which will give me new student number (NEW_ROOM_LOAD) of each room after redistribution and also flag the room that come available (Room_Status). I have about 150 courses. That's why I need help with a dynamic code. Any help will be appreciated. I will really appreciate any help you can provide. Thanks.

COURSE	ROOM_NO	ROOM_CAPACITY	ROOM_LOAD	NEW_ROOM_LOAD	Room_Status
CHEM101	C101	20	7	17
CHEM101	C102	20	11	19
CHEM101	C103	10	8	0	Available
CHEM101	C104	15	10	0	Available
BIO302	HB102	22	20	20
BIO302	HB106	24	12	0	Available
BIO302	HB902	30	29	30
BIO302	W102	30	31	30
BIO302	AB102	40	27	39

Re: How to apply format to all numeric values all at once

mlogan — Wed, 21 Aug 2024 17:02:37 GMT

Thanks Ballardw. Your solution works for me, but I have a date field and _numeric_ function is converting the date field to numeric as well. Any solution to that?

Thanks.

How to apply format to all numeric values all at once

mlogan — Wed, 21 Aug 2024 14:35:03 GMT

Hi there,

I have a over 50 numeric variables and and I like to apply FORMAT to all at once (eg: Best32.). Is there a way to apply format to all numeric values without writing all variables in the script?

Thanks,

Mike

Connecting DB2 Database using sas base.

mlogan — Tue, 13 Sep 2022 03:11:22 GMT

Hi All,

I am having issue connecting to DB2 database server using sas base. Can someone assist me on how to accomplish that. I have tried following many online blog, but everything failed.

Thanks for your help

Shak

Re: Copy first observation till the end

mlogan — Mon, 16 May 2022 19:17:09 GMT

Hi mkeintz, Do you know how I can stop RETAIN function to copy the value all the way till the blank line? I want it to stop at one point when my another by value (sorted column) ends.

Thanks.

Re: Copy first observation till the end

mlogan — Mon, 16 May 2022 17:13:36 GMT

Thank you mkeintz. It worked for me perfectly. Never used this RETAIN function before. Today I have learded something new.

Copy first observation till the end

mlogan — Mon, 16 May 2022 03:09:59 GMT

Hi all,

I have lat 4 year tuition fee laid out as Fee_YR_01-Fee_YR_04 and their corresponding increased rate Increase_YR_01-Increase_YR_04. I want 4 new rows which will calculate the tuition fee for the next 4 years based on their previous year tuitions and corresponding increase. But instead of calculating all 4 rows, I want the calculated output of the first row to be copied below all the way to the end.

I was able to do the calculation on the first row, but don't know how to copy downward. Can anyone help please. Thank you

data have;
	input Fee_YR_01 Fee_YR_02 Fee_YR_03 Fee_YR_04 Increase_YR_01 Increase_YR_02 Increase_YR_03 Increase_YR_04;
datalines;
1000	1050	1100	1150	0	20	20	20
1000	1070	1100	1150	0	20	20	20
3000	3100	3150	3200	0	15	15	15
3000	3200	3200	3300	0	15	15	15
;
RUN;

DATA Want;
SET  Have;

ARRAY Increase_Rate(*) Increase_YR_01 - Increase_YR_04;
ARRAY Fee_New(*)        Fee_New_AY_01 - Fee_New_AY_04;

Fee_New_AY_01=Fee_YR_01;
   DO i=2 TO dim(Fee_New);
   
	IF _n_=1 THEN fee_new(i) = FLOOR(( fee_new(i-1) * (1+(Increase_Rate(i)/100)) )/10)*10;
    
END;
DROP i;
RUN;

Expected Output:

Fee_YR_01	Fee_YR_02	Fee_YR_03	Fee_YR_04	Increase_YR_01	Increase_YR_02	Increase_YR_03	Increase_YR_04	Fee_New_AY_01	Fee_New_AY_02	Fee_New_AY_03	Fee_New_AY_04
1000	1050	1100	1150	0	20	20	20	1000	1200	1440	1720
1000	1070	1100	1150	0	20	20	20	1000	1200	1440	1720
3000	3100	3150	3200	0	15	15	15	3000	1200	1440	1720
3000	3200	3200	3300	0	15	15	15	3000	1200	1440	1720

Re: Dynamically Calculate of Variables

mlogan — Sun, 15 May 2022 13:32:17 GMT

Thank you Reeza. Your code worked for me. I just have slightly different requirements now and wondering if you can help.

I want the calculated output of the first row will be copied below all the way to the end.

I was able to do the calculation on the first line, but don't know how to copy downward. Thank you for your help.

data have;
	input Fee_YR_01 Fee_YR_02 Fee_YR_03 Fee_YR_04 Increase_YR_01 Increase_YR_02 Increase_YR_03 Increase_YR_04;
datalines;
1000	1050	1100	1150	0	20	20	20
1000	1070	1100	1150	0	20	20	20
3000	3100	3150	3200	0	15	15	15
3000	3200	3200	3300	0	15	15	15
;
RUN;

DATA Want;
SET  Have;

ARRAY Increase_Rate(*) Increase_YR_01 - Increase_YR_04;
ARRAY Fee_New(*)        Fee_New_AY_01 - Fee_New_AY_04;

Fee_New_AY_01=Fee_YR_01;
   DO i=2 TO dim(Fee_New);
   
	IF _n_=1 THEN fee_new(i) = FLOOR(( fee_new(i-1) * (1+(Increase_Rate(i)/100)) )/10)*10;
    
END;
DROP i;
RUN;

Expected Output:

Fee_YR_01	Fee_YR_02	Fee_YR_03	Fee_YR_04	Increase_YR_01	Increase_YR_02	Increase_YR_03	Increase_YR_04	Fee_New_AY_01	Fee_New_AY_02	Fee_New_AY_03	Fee_New_AY_04
1000	1050	1100	1150	0	20	20	20	1000	1200	1440	1720
1000	1070	1100	1150	0	20	20	20	1000	1200	1440	1720
3000	3100	3150	3200	0	15	15	15	3000	1200	1440	1720
3000	3200	3200	3300	0	15	15	15	3000	1200	1440	1720

Dynamically Calculate of Variables

mlogan — Mon, 09 May 2022 21:43:48 GMT

Hello,

I have tuition fees laid out for 4 years (Variables Fee_YR_01-Fee_YR_04) starting current year (Fee_YR_01). Variables Increase_YR_01-Increase_YR_04 in the sample dataset shows the proposed tuition fee increase rate (in percent) based on the previous year. I want to calculate the future tuition based on this proposed tuition increase rate (in the new variables Fee_New_YR_02 - Fee_New_YR_04). I want a dynamic solution for this calculation. Thank you all.

My data set looks like this:

data have;
	input Fee_YR_01 Fee_YR_02 Fee_YR_03 Fee_YR_04 Increase_YR_01 Increase_YR_02 Increase_YR_03 Increase_YR_04;
datalines;
1000	1050	1100	1150	0	20	20	20
1000	1070	1100	1150	0	20	20	20
3000	3100	3150	3200	0	15	15	15
3000	3200	3200	3300	0	15	15	15
4000	4150	4200	4250	0	15	15	15
4000	4200	4300	4350	0	15	15	15

;
RUN;

This is the output I want:

Fee_New_YR_02	Fee_New_YR_03	Fee_New_YR_04
1200	1260	1320
1200	1284	1320
3450	3565	3622.5
3450	3680	3680
4600	4772.5	4830
4600	4830	4945

Calculations: Fee_New_YR_02=Fee_YR_01 * 1.2 (increased by 20%)

I have shown you a small set of data. But I have 150 variables for tuition fees and 150 variables for the tuition rate increase. So I need help on how to do it dynamically.

Dynamic Calculations of Variables

mlogan — Mon, 09 May 2022 21:40:03 GMT

Hello,

My data set looks like this:

data have;
	input Fee_YR_01 Fee_YR_02 Fee_YR_03 Fee_YR_04 Increase_YR_01 Increase_YR_02 Increase_YR_03 Increase_YR_04;
datalines;
1000	1050	1100	1150	0	20	20	20
1000	1070	1100	1150	0	20	20	20
3000	3100	3150	3200	0	15	15	15
3000	3200	3200	3300	0	15	15	15
4000	4150	4200	4250	0	15	15	15
4000	4200	4300	4350	0	15	15	15

;
RUN;

This is the output I want:

Fee_New_YR_02	Fee_New_YR_03	Fee_New_YR_04
1200	1260	1320
1200	1284	1320
3450	3565	3622.5
3450	3680	3680
4600	4772.5	4830
4600	4830	4945

Calculations: Fee_New_YR_02=Fee_YR_01 * 1.2 (increased by 20%)

I have shown you a small set of data. But I have 150 variables for tuition fees and 150 variables for the tuition rate increase. So I need help on how to do it dynamically.

Dynamic Calculations of Variables

mlogan — Sun, 08 May 2022 23:38:05 GMT

Hello,

My data set looks like this:

data have;
	input Fee_YR_01 Fee_YR_02 Fee_YR_03 Fee_YR_04 Increase_YR_01 Increase_YR_02 Increase_YR_03 Increase_YR_04;
datalines;
1000	1050	1100	1150	0	20	20	20
1000	1070	1100	1150	0	20	20	20
3000	3100	3150	3200	0	15	15	15
3000	3200	3200	3300	0	15	15	15
4000	4150	4200	4250	0	15	15	15
4000	4200	4300	4350	0	15	15	15

;
RUN;

This is the output I want:

Fee_New_YR_02	Fee_New_YR_03	Fee_New_YR_04
1200	1260	1320
1200	1284	1320
3450	3565	3622.5
3450	3680	3680
4600	4772.5	4830
4600	4830	4945

Calculations: Fee_New_YR_02=Fee_YR_01 * 1.2 (increased by 20%)

I have shown you a small set of data. But I have 150 variables for tuition fees and 150 variables for the tuition rate increase. So I need help on how to do it dynamically.

Retaining label from csv import

mlogan — Sat, 26 Dec 2020 04:26:49 GMT

I wanted to retain the label on sas dataset after importing a file from csv file. Can someone please help me with the code. I wrote the following code and the label becoming as blanl on sas file. thanks.

PROC IMPORT DATAFILE="C:\test.csv"
OUT=want
DBMS=csv REPLACE;
GETNAMES=Yes;
GUESSINGROWS=14600;
RUN;

Converting character yyyy-mm-dd to mm/dd//yyyy format

mlogan — Tue, 13 Oct 2020 20:43:19 GMT

Hi there,

I have a column which is showing as character (yyyy-mm-dd) and I want to change that to mm/dd//yyyy date format, can someone please help.

Thanks,

Mike

Re: Uploading and copying file to and from SFTP site

mlogan — Sat, 09 May 2020 02:41:35 GMT

I have sas base installed on a local PC. I can use Enterprise Guide if I need to.