topic Re: How to RENAME variables and then DROP originals in New SAS User

How to RENAME variables and then DROP originals

_maldini_ — Fri, 19 Nov 2021 20:51:11 GMT

I'm trying to rename variables and then drop the originally named variables and keep the newly named ones.

I have read this, this and this and cannot figure it out.

DATA meta.data_01;
	SET meta.data_01;
	
	(RENAME =	(
				Map_Alpha1_V1=BH_ApoA1_V1
				Map_Alpha1_V2=BH_ApoA1_V2
				Map_Alpha1_V3=BH_ApoA1_V3
				Map_Alpha2_V1=BH_ApoA2_V1
				Map_Alpha2_V2=BH_ApoA2_V2
				Map_Alpha2_V3=BH_ApoA2_V3
				Map_Alpha3_V1=BH_ApoA3_V1
				Map_Alpha3_V2=BH_ApoA3_V2
				Map_Alpha3_V3=BH_ApoA3_V3
				Map_Alpha4_V1=BH_ApoA4_V1
				Map_Alpha4_V2=BH_ApoA4_V2
				Map_Alpha4_V3=BH_ApoA4_V3
				Map_PreB1_V1=BH_PreBeta_1_V1
				Map_PreB1_V2=BH_PreBeta_1_V2
				Map_PreB1_V3=BH_PreBeta_1_V3
				);


	DROP = 		(              
		 		Map:
               	);
RUN;

Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 DATA meta.data_01;
70 SET meta.data_01;
71
72 (RENAME =(
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

73 Map_Alpha1_V1=BH_ApoA1_V1
74 Map_Alpha1_V2=BH_ApoA1_V2
75 Map_Alpha1_V3=BH_ApoA1_V3
76 Map_Alpha2_V1=BH_ApoA2_V1
77 Map_Alpha2_V2=BH_ApoA2_V2
78 Map_Alpha2_V3=BH_ApoA2_V3
79 Map_Alpha3_V1=BH_ApoA3_V1
80 Map_Alpha3_V2=BH_ApoA3_V2
81 Map_Alpha3_V3=BH_ApoA3_V3
82 Map_Alpha4_V1=BH_ApoA4_V1
83 Map_Alpha4_V2=BH_ApoA4_V2
84 Map_Alpha4_V3=BH_ApoA4_V3
85 Map_PreB1_V1=BH_PreBeta_1_V1
86 Map_PreB1_V2=BH_PreBeta_1_V2
87 Map_PreB1_V3=BH_PreBeta_1_V3
88 );
89
90
91 DROP = (
92 Map:
_
388
200
76
ERROR 388-185: Expecting an arithmetic operator.

ERROR 200-322: The symbol is not recognized and will be ignored.

ERROR 76-322: Syntax error, statement will be ignored.

93 );
94 RUN;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set META.DATA_01 may be incomplete. When this step was stopped there were 0 observations and 179 variables.
WARNING: Data set META.DATA_01 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1431.56k
OS Memory 33204.00k
Timestamp 11/19/2021 08:46:47 PM
Step Count 951 Switch Count 0
Page Faults 0
Page Reclaims 92
Page Swaps 0
Voluntary Context Switches 22
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8

95
96 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
106

Re: How to RENAME variables and then DROP originals

Reeza — Fri, 19 Nov 2021 21:08:39 GMT

When you rename a variable, it stays the same just the name changes.

So if you drop the variables that are renamed they are no longer in your data set. There are no old/new variables, just a single variable with a different name.

So basically, the 'drop' is automatic and you don't need to drop anything.

@_maldini_ wrote:

I'm trying to rename variables and then drop the originally named variables and keep the newly named ones.

I have read this, this and this and cannot figure it out.
DATA meta.data_01;
	SET meta.data_01;
	
	(RENAME =	(
				Map_Alpha1_V1=BH_ApoA1_V1
				Map_Alpha1_V2=BH_ApoA1_V2
				Map_Alpha1_V3=BH_ApoA1_V3
				Map_Alpha2_V1=BH_ApoA2_V1
				Map_Alpha2_V2=BH_ApoA2_V2
				Map_Alpha2_V3=BH_ApoA2_V3
				Map_Alpha3_V1=BH_ApoA3_V1
				Map_Alpha3_V2=BH_ApoA3_V2
				Map_Alpha3_V3=BH_ApoA3_V3
				Map_Alpha4_V1=BH_ApoA4_V1
				Map_Alpha4_V2=BH_ApoA4_V2
				Map_Alpha4_V3=BH_ApoA4_V3
				Map_PreB1_V1=BH_PreBeta_1_V1
				Map_PreB1_V2=BH_PreBeta_1_V2
				Map_PreB1_V3=BH_PreBeta_1_V3
				);


	DROP = 		(              
		 		Map:
               	);
RUN;
Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 DATA meta.data_01;
70 SET meta.data_01;
71
72 (RENAME =(
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

73 Map_Alpha1_V1=BH_ApoA1_V1
74 Map_Alpha1_V2=BH_ApoA1_V2
75 Map_Alpha1_V3=BH_ApoA1_V3
76 Map_Alpha2_V1=BH_ApoA2_V1
77 Map_Alpha2_V2=BH_ApoA2_V2
78 Map_Alpha2_V3=BH_ApoA2_V3
79 Map_Alpha3_V1=BH_ApoA3_V1
80 Map_Alpha3_V2=BH_ApoA3_V2
81 Map_Alpha3_V3=BH_ApoA3_V3
82 Map_Alpha4_V1=BH_ApoA4_V1
83 Map_Alpha4_V2=BH_ApoA4_V2
84 Map_Alpha4_V3=BH_ApoA4_V3
85 Map_PreB1_V1=BH_PreBeta_1_V1
86 Map_PreB1_V2=BH_PreBeta_1_V2
87 Map_PreB1_V3=BH_PreBeta_1_V3
88 );
89
90
91 DROP = (
92 Map:
_
388
200
76
ERROR 388-185: Expecting an arithmetic operator.

ERROR 200-322: The symbol is not recognized and will be ignored.

ERROR 76-322: Syntax error, statement will be ignored.

93 );
94 RUN;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set META.DATA_01 may be incomplete. When this step was stopped there were 0 observations and 179 variables.
WARNING: Data set META.DATA_01 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1431.56k
OS Memory 33204.00k
Timestamp 11/19/2021 08:46:47 PM
Step Count 951 Switch Count 0
Page Faults 0
Page Reclaims 92
Page Swaps 0
Voluntary Context Switches 22
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8

95
96 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
106

Re: How to RENAME variables and then DROP originals

_maldini_ — Fri, 19 Nov 2021 21:32:27 GMT

@Reeza Something is obviously wrong w/ my revised syntax...

Revised syntax:

DATA meta.data_01;
	SET meta.data_01;
	
    RENAME 
                Map_Alpha1_V1=BH_ApoA1_V1;
                Map_Alpha1_V2=BH_ApoA1_V2;
                Map_Alpha1_V3=BH_ApoA1_V3;
                Map_Alpha2_V1=BH_ApoA2_V1;
                Map_Alpha2_V2=BH_ApoA2_V2;
                Map_Alpha2_V3=BH_ApoA2_V3;
                Map_Alpha3_V1=BH_ApoA3_V1;
                Map_Alpha3_V2=BH_ApoA3_V2;
                Map_Alpha3_V3=BH_ApoA3_V3;
                Map_Alpha4_V1=BH_ApoA4_V1;
                Map_Alpha4_V2=BH_ApoA4_V2;
                Map_Alpha4_V3=BH_ApoA4_V3;
                Map_PreB1_V1=BH_PreBeta_1_V1;
                Map_PreB1_V2=BH_PreBeta_1_V2;
                Map_PreB1_V3=BH_PreBeta_1_V3;
RUN;

Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

69 DATA meta.data_01;

70 SET meta.data_01;

72 RENAME

73 Map_Alpha1_V1=BH_ApoA1_V1;

74 Map_Alpha1_V2=BH_ApoA1_V2;

75 Map_Alpha1_V3=BH_ApoA1_V3;

76 Map_Alpha2_V1=BH_ApoA2_V1;

77 Map_Alpha2_V2=BH_ApoA2_V2;

78 Map_Alpha2_V3=BH_ApoA2_V3;

79 Map_Alpha3_V1=BH_ApoA3_V1;

80 Map_Alpha3_V2=BH_ApoA3_V2;

81 Map_Alpha3_V3=BH_ApoA3_V3;

82 Map_Alpha4_V1=BH_ApoA4_V1;

83 Map_Alpha4_V2=BH_ApoA4_V2;

84 Map_Alpha4_V3=BH_ApoA4_V3;

85 Map_PreB1_V1=BH_PreBeta_1_V1;

86 Map_PreB1_V2=BH_PreBeta_1_V2;

87 Map_PreB1_V3=BH_PreBeta_1_V3;

88 RUN;

WARNING: The variable Map_Alpha1_V1 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 49 observations read from the data set META.DATA_01.

NOTE: The data set META.DATA_01 has 49 observations and 171 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 1515.71k

OS Memory 32436.00k

Timestamp 11/19/2021 09:27:33 PM

Step Count 1146 Switch Count 2

Page Faults 0

Page Reclaims 104

Page Swaps 0

Voluntary Context Switches 49

Involuntary Context Switches 0

Block Input Operations 288

Block Output Operations 272

90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

100

Re: How to RENAME variables and then DROP originals

Reeza — Fri, 19 Nov 2021 21:50:38 GMT

Run it in a clean session from the start.

DATA meta.data_01;
	SET meta.data_01;

Coding like this is bad style and not recommended.

So likely what happened is you ran it once and it converted everything already. Now you run it again and the old variables are no longer there - you've already renamed them so it throws an error letting you know.

So using the same name on DATA and SET statement is not recommended.

@_maldini_ wrote:

@Reeza Something is obviously wrong w/ my revised syntax...

Revised syntax:
DATA meta.data_01;
	SET meta.data_01;
	
    RENAME 
                Map_Alpha1_V1=BH_ApoA1_V1;
                Map_Alpha1_V2=BH_ApoA1_V2;
                Map_Alpha1_V3=BH_ApoA1_V3;
                Map_Alpha2_V1=BH_ApoA2_V1;
                Map_Alpha2_V2=BH_ApoA2_V2;
                Map_Alpha2_V3=BH_ApoA2_V3;
                Map_Alpha3_V1=BH_ApoA3_V1;
                Map_Alpha3_V2=BH_ApoA3_V2;
                Map_Alpha3_V3=BH_ApoA3_V3;
                Map_Alpha4_V1=BH_ApoA4_V1;
                Map_Alpha4_V2=BH_ApoA4_V2;
                Map_Alpha4_V3=BH_ApoA4_V3;
                Map_PreB1_V1=BH_PreBeta_1_V1;
                Map_PreB1_V2=BH_PreBeta_1_V2;
                Map_PreB1_V3=BH_PreBeta_1_V3;
RUN;
Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

68

69 DATA meta.data_01;

70 SET meta.data_01;

71

72 RENAME

73 Map_Alpha1_V1=BH_ApoA1_V1;

74 Map_Alpha1_V2=BH_ApoA1_V2;

75 Map_Alpha1_V3=BH_ApoA1_V3;

76 Map_Alpha2_V1=BH_ApoA2_V1;

77 Map_Alpha2_V2=BH_ApoA2_V2;

78 Map_Alpha2_V3=BH_ApoA2_V3;

79 Map_Alpha3_V1=BH_ApoA3_V1;

80 Map_Alpha3_V2=BH_ApoA3_V2;

81 Map_Alpha3_V3=BH_ApoA3_V3;

82 Map_Alpha4_V1=BH_ApoA4_V1;

83 Map_Alpha4_V2=BH_ApoA4_V2;

84 Map_Alpha4_V3=BH_ApoA4_V3;

85 Map_PreB1_V1=BH_PreBeta_1_V1;

86 Map_PreB1_V2=BH_PreBeta_1_V2;

87 Map_PreB1_V3=BH_PreBeta_1_V3;

88 RUN;

WARNING: The variable Map_Alpha1_V1 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 49 observations read from the data set META.DATA_01.

NOTE: The data set META.DATA_01 has 49 observations and 171 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 1515.71k

OS Memory 32436.00k

Timestamp 11/19/2021 09:27:33 PM

Step Count 1146 Switch Count 2

Page Faults 0

Page Reclaims 104

Page Swaps 0

Voluntary Context Switches 49

Involuntary Context Switches 0

Block Input Operations 288

Block Output Operations 272

89

90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

100

Re: How to RENAME variables and then DROP originals

_maldini_ — Tue, 23 Nov 2021 20:26:42 GMT

@Reeza I'm getting the same warning even after quitting and restarting the session and changing the data set name in the DATA step.

Can anything be easy in SAS?!

Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

68

69 /* Creating the library */

70 LIBNAME meta "/home/...";

NOTE: Libref META was successfully assigned as follows:

Engine: V9

Physical Name: /home/...

71

72 /* */

73 /* PROC IMPORT DATAFILE="meta" */

74 /* OUT=meta_import */

75 /* DBMS=CSV */

76 /* replace; */

77 /* getnames=yes; */

78 /* RUN; */

79

80 *-------------------------------------------------;

81 * CREATING THE DATASET TO BE USED IN THE ANALYSES;

82 *-------------------------------------------------;

83

84 /* DATA meta.data_01; */

85 /* SET WORK.IMPORT; */

86 /* RUN; */

87

88 /* PROC CONTENTS DATA=meta.data_01; */

89 /* RUN; */

90

91 DATA meta.data_02;

92 SET meta.data_01;

93

94 RENAME

95 Map_Alpha1_V1=BH_ApoA1_V1;

96 Map_Alpha1_V2=BH_ApoA1_V2;

97 Map_Alpha1_V3=BH_ApoA1_V3;

98 Map_Alpha2_V1=BH_ApoA2_V1;

99 Map_Alpha2_V2=BH_ApoA2_V2;

100 Map_Alpha2_V3=BH_ApoA2_V3;

101 Map_Alpha3_V1=BH_ApoA3_V1;

102 Map_Alpha3_V2=BH_ApoA3_V2;

103 Map_Alpha3_V3=BH_ApoA3_V3;

104 Map_Alpha4_V1=BH_ApoA4_V1;

105 Map_Alpha4_V2=BH_ApoA4_V2;

106 Map_Alpha4_V3=BH_ApoA4_V3;

107 Map_PreB1_V1=BH_PreBeta_1_V1;

108 Map_PreB1_V2=BH_PreBeta_1_V2;

109 Map_PreB1_V3=BH_PreBeta_1_V3;

110

111 /* EFFLUX */

112 Efflux_V2_V1_diff = Efflux_V2-Efflux_V1;

113 Efflux_V3_V2_diff= Efflux_V3-Efflux_V2;

114 Efflux_V3_V1_diff= Efflux_V3-Efflux_V1;

115

116 /* CLEVELAND HEART LAB */

117 ApoA1_V2_V1_diff = ApoA1_V2-ApoA1_V1;

118 ApoA1_V3_V2_diff= ApoA1_V3-ApoA1_V2;

119 ApoA1_V3_V1_diff= ApoA1_V3-ApoA1_V1;

120

121 ApoC1_V2_V1_diff = ApoC1_V2-ApoC1_V1;

122 ApoC1_V3_V2_diff= ApoC1_V3-ApoC1_V2;

123 ApoC1_V3_V1_diff= ApoC1_V3-ApoC1_V1;

124

125 ApoC2_V2_V1_diff = ApoC2_V2-ApoC2_V1;

126 ApoC2_V3_V2_diff= ApoC2_V3-ApoC2_V2;

127 ApoC2_V3_V1_diff= ApoC2_V3-ApoC2_V1;

128

129 ApoC3_V2_V1_diff = ApoC3_V2-ApoC3_V1;

130 ApoC3_V3_V2_diff= ApoC3_V3-ApoC3_V2;

131 ApoC3_V3_V1_diff= ApoC3_V3-ApoC3_V1;

132

133 ApoC4_V2_V1_diff = ApoC4_V2-ApoC4_V1;

134 ApoC4_V3_V2_diff= ApoC4_V3-ApoC4_V2;

135 ApoC4_V3_V1_diff= ApoC4_V3-ApoC4_V1;

136

137 pCAD_V2_V1_diff = pCAD_V2-pCAD_V1;

138 pCAD_V3_V2_diff= pCAD_V3-pCAD_V2;

139 pCAD_V3_V1_diff= pCAD_V3-pCAD_V1;

140

141 /* BOSTON HEART */

142 BH_ApoA1_V2_V1_diff = BH_ApoA1_V2-BH_ApoA1_V1;

143 BH_ApoA1_V3_V2_diff= BH_ApoA1_V3-BH_ApoA1_V2;

144 BH_ApoA1_V3_V1_diff= BH_ApoA1_V3-BH_ApoA1_V1;

145

146 BH_ApoA2_V2_V1_diff = BH_ApoA2_V2-BH_ApoA2_V1;

147 BH_ApoA2_V3_V2_diff= BH_ApoA2_V3-BH_ApoA2_V2;

148 BH_ApoA2_V3_V1_diff= BH_ApoA2_V3-BH_ApoA2_V1;

149

150 BH_ApoA3_V2_V1_diff = BH_ApoA3_V2-BH_ApoA3_V1;

151 BH_ApoA3_V3_V2_diff= BH_ApoA3_V3-BH_ApoA3_V2;

152 BH_ApoA3_V3_V1_diff= BH_ApoA3_V3-BH_ApoA3_V1;

153

154 BH_ApoA4_V2_V1_diff = BH_ApoA4_V2-BH_ApoA4_V1;

155 BH_ApoA4_V3_V2_diff= BH_ApoA4_V3-BH_ApoA4_V2;

156 BH_ApoA4_V3_V1_diff= BH_ApoA4_V3-BH_ApoA4_V1;

157

158 Map_PreB1_V2_V1_diff = Map_PreB1_V2-Map_PreB1_V1;

159 Map_PreB1_V3_V2_diff= Map_PreB1_V3-Map_PreB1_V2;

160 Map_PreB1_V3_V1_diff= Map_PreB1_V3-Map_PreB1_V1;

161

162 /* MPO_Ab_V2_V1_diff */

163 /* MPO_Ab_V3_V1_diff */

164 /* MPO_Ab_V3_V2_diff */

165

166 /* LIVER & KIDNEY FX */

167 ALT_V2_V1_diff = ALT_V2-ALT_V1;

168 ALT_V3_V2_diff= ALT_V3-ALT_V2;

169 ALT_V3_V1_diff= ALT_V3-ALT_V1;

170

171 AST_V2_V1_diff = AST_V2-AST_V1;

172 AST_V3_V2_diff= AST_V3-AST_V2;

173 AST_V3_V1_diff= AST_V3-AST_V1;

174

175 AlkPhos_V2_V1_diff = AlkPhos_V2-AlkPhos_V1;

176 AlkPhos_V3_V2_diff= AlkPhos_V3-AlkPhos_V2;

177 AlkPhos_V3_V1_diff= AlkPhos_V3-AlkPhos_V1;

178

179 Bilirubin_V2_V1_diff = Bilirubin_V2-Bilirubin_V1;

180 Bilirubin_V3_V2_diff= Bilirubin_V3-Bilirubin_V2;

181 Bilirubin_V3_V1_diff= Bilirubin_V3-Bilirubin_V1;

182

183 Albumin_V2_V1_diff = Albumin_V2-Albumin_V1;

184 Albumin_V3_V2_diff= Albumin_V3-Albumin_V2;

185 Albumin_V3_V1_diff= Albumin_V3-Albumin_V1;

186

187 Globulin_V2_V1_diff = Globulin_V2-Globulin_V1;

188 Globulin_V3_V2_diff= Globulin_V3-Globulin_V2;

189 Globulin_V3_V1_diff= Globulin_V3-Globulin_V1;

190

191 TotalProt_V2_V1_diff = TotalProt_V2-TotalProt_V1;

192 TotalProt_V3_V2_diff= TotalProt_V3-TotalProt_V2;

193 TotalProt_V3_V1_diff= TotalProt_V3-TotalProt_V1;

194

195 AlbGlobRatio_V2_V1_diff = AlbGlobRatio_V2-AlbGlobRatio_V1;

196 AlbGlobRatio_V3_V2_diff= AlbGlobRatio_V3-AlbGlobRatio_V2;

197 AlbGlobRatio_V3_V1_diff= AlbGlobRatio_V3-AlbGlobRatio_V1;

198

199 BUN_V2_V1_diff = BUN_V2-BUN_V1;

200 BUN_V3_V2_diff= BUN_V3-BUN_V2;

201 BUN_V3_V1_diff= BUN_V3-BUN_V1;

202

203 Creatinine_V2_V1_diff = Creatinine_V2-Creatinine_V1;

204 Creatinine_V3_V2_diff= Creatinine_V3-Creatinine_V2;

205 Creatinine_V3_V1_diff= Creatinine_V3-Creatinine_V1;

206

207 BUNCreatinineRatio_V2_V1_diff = BUNCreatinineRatio_V2-BUNCreatinineRatio_V1;

208 BUNCreatinineRatio_V3_V2_diff= BUNCreatinineRatio_V3-BUNCreatinineRatio_V2;

209 BUNCreatinineRatio_V3_V1_diff= BUNCreatinineRatio_V3-BUNCreatinineRatio_V1;

210

211 eGFR_NoA_V2_V1_diff = eGFR_NoA_V2-eGFR_NoA_V1;

212 eGFR_NoA_V3_V2_diff= eGFR_NoA_V3-eGFR_NoA_V2;

213 eGFR_NoA_V3_V1_diff= eGFR_NoA_V3-eGFR_NoA_V1;

214

215 eGFR_AA_V2_V1_diff = eGFR_AA_V2-eGFR_AA_V1;

216 eGFR_AA_V3_V2_diff= eGFR_AA_V3-eGFR_AA_V2;

217 eGFR_AA_V3_V1_diff= eGFR_AA_V3-eGFR_AA_V1

218 ;

219

220 /* REMOVING OUTLIERS */

221 IF Creatinine_V1 = 73 THEN Creatinine_V1 = .;

222 RUN;

WARNING: The variable Map_Alpha1_V1 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: Missing values were generated as a result of performing an operation on missing values.

Each place is given by: (Number of times) at (Line):(Column).

2 at 112:34 2 at 114:33 49 at 142:38 49 at 143:38 49 at 144:38 49 at 146:38 49 at 147:38 49 at 148:38

49 at 150:38 49 at 151:38 49 at 152:38 49 at 154:38 49 at 155:38 49 at 156:38 49 at 158:41 49 at 159:40

49 at 160:40 49 at 167:28 49 at 168:27 49 at 171:28 49 at 172:27 49 at 175:36 49 at 176:35 49 at 179:40

49 at 180:39 49 at 183:36 49 at 184:35 49 at 187:37 49 at 188:37 49 at 191:40 49 at 192:39 49 at 195:45

49 at 196:45 49 at 199:28 49 at 200:27 49 at 203:42 49 at 204:41 1 at 205:41 49 at 207:58 49 at 208:57

41 at 209:57 49 at 211:37 49 at 212:37 49 at 215:36 49 at 216:35

NOTE: There were 49 observations read from the data set META.DATA_01.

NOTE: The data set META.DATA_02 has 49 observations and 171 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

user cpu time 0.01 seconds

system cpu time 0.01 seconds

memory 1334.84k

OS Memory 24744.00k

Timestamp 11/19/2021 09:54:32 PM

Step Count 36 Switch Count 1

Page Faults 0

Page Reclaims 220

Page Swaps 0

Voluntary Context Switches 43

Involuntary Context Switches 0

Block Input Operations 320

Block Output Operations 280

223

224

225 /* PROC PRINT DATA=meta.data_01; */

226 /* Var Participant_ID; */

227 /* RUN; */

228 /* */

229 /* PROC CONTENTS DATA=meta.data_01 VARNUM; RUN; */

230

231

232

233 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

243

Re: How to RENAME variables and then DROP originals

PaigeMiller — Fri, 19 Nov 2021 22:03:04 GMT

The WARNING is extremely clear. The variable named MAP_ALPHA1_V1 is not in your data set, so you can't rename it.

You can see this by yourself by actually looking at the data set, or by looking at PROC CONTENTS for that data set.

Re: How to RENAME variables and then DROP originals

Reeza — Fri, 19 Nov 2021 22:08:31 GMT

Then if it's for just a single one, you're likely wrong and the computer is right, the variable doesn't exist in your input data set.
So it likely has a different name, spaces, spelling or something is off in the name.

Re: How to RENAME variables and then DROP originals

ballardw — Fri, 19 Nov 2021 22:15:45 GMT

@_maldini_ wrote:

@Reeza Something is obviously wrong w/ my revised syntax...

Revised syntax:

DATA meta.data_01;
	SET meta.data_01;
	
    RENAME 
                Map_Alpha1_V1=BH_ApoA1_V1;
                Map_Alpha1_V2=BH_ApoA1_V2;
                Map_Alpha1_V3=BH_ApoA1_V3;
                Map_Alpha2_V1=BH_ApoA2_V1;
                Map_Alpha2_V2=BH_ApoA2_V2;
                Map_Alpha2_V3=BH_ApoA2_V3;
                Map_Alpha3_V1=BH_ApoA3_V1;
                Map_Alpha3_V2=BH_ApoA3_V2;
                Map_Alpha3_V3=BH_ApoA3_V3;
                Map_Alpha4_V1=BH_ApoA4_V1;
                Map_Alpha4_V2=BH_ApoA4_V2;
                Map_Alpha4_V3=BH_ApoA4_V3;
                Map_PreB1_V1=BH_PreBeta_1_V1;
                Map_PreB1_V2=BH_PreBeta_1_V2;
                Map_PreB1_V3=BH_PreBeta_1_V3;
RUN;

In this case Your code only renames one variable.

RENAME Map_Alpha1_V1=BH_ApoA1_V1;

The semicolon here ends the rename. So the remaining statements like this are ASSIGNMENT statements:

Map_Alpha1_V2=BH_ApoA1_V2;

So if the data set does not have a variable BH_ApoA1_V2 the code 1) creates a variable of that name, 2) makes it with a missing a value and then 3) overwrites the existing variable Map_Alpha1_V2 with that missing value.

BTW, Proc Datasets will rename variables in place without use of a data step which can be much faster than the data step with large sets because it only changes the header information in the data set and does not process every record of the set like the data step must.

proc datasets library=meta;
   modify data_01;
   rename 
   			        Map_Alpha1_V1=BH_ApoA1_V1
				Map_Alpha1_V2=BH_ApoA1_V2
				Map_Alpha1_V3=BH_ApoA1_V3
				Map_Alpha2_V1=BH_ApoA2_V1
				Map_Alpha2_V2=BH_ApoA2_V2
				Map_Alpha2_V3=BH_ApoA2_V3
				Map_Alpha3_V1=BH_ApoA3_V1
				Map_Alpha3_V2=BH_ApoA3_V2
				Map_Alpha3_V3=BH_ApoA3_V3
				Map_Alpha4_V1=BH_ApoA4_V1
				Map_Alpha4_V2=BH_ApoA4_V2
				Map_Alpha4_V3=BH_ApoA4_V3
				Map_PreB1_V1=BH_PreBeta_1_V1
				Map_PreB1_V2=BH_PreBeta_1_V2
				Map_PreB1_V3=BH_PreBeta_1_V3
   ;

quit;

You can change labels, formats, informats as well. This procedure does not change the values of any of the data variables.

Re: How to RENAME variables and then DROP originals

_maldini_ — Fri, 19 Nov 2021 22:17:55 GMT

Solved. Thank you!