Hi,
I have a variable list:
%let sas_vnames = v1 v2 v3...etc.
And a corresponding var length list:
%let sas_vlngth = $10.^$30.$10.^etc.
I used ^ as an arbitrary delimiter.
This is the macro code to set the length:
SAS can count for you.
So if you have these three variables:
%let sas_vnames = v1 v2 v3;
%let sas_vlngth = $10.^$30.^$10.;
You can use code like:
length
%do index=1 to %sysfunc(countw(&sas_vlngth,^));
%scan(&sas_vnames,&index,%str( )) %scan(&sas_vlngth,&index,^)
%end;
;
To generate the statement:
length v1 $10. v2 $30. v3 $10.;
SAS can count for you.
So if you have these three variables:
%let sas_vnames = v1 v2 v3;
%let sas_vlngth = $10.^$30.^$10.;
You can use code like:
length
%do index=1 to %sysfunc(countw(&sas_vlngth,^));
%scan(&sas_vnames,&index,%str( )) %scan(&sas_vlngth,&index,^)
%end;
;
To generate the statement:
length v1 $10. v2 $30. v3 $10.;
I would suggest the following revised code:
%let sas_vnames = v1 v2 v3;
%let sas_vlngth = $10.^$30.^$10.;
/*RENAME EXCEL VARS TO SAS VAR NAMES*/
data sasnames_&i ;
/*BUILD LENGTH STATEMENTS*/
%macro put_lngth;
%let count=%sysfunc(countw(&sas_vnames,%str( )));
%put &count;
%do p=1 %to &count;
%let sas_var = %scan(&sas_vnames., &p.,%str( ));
%let sas_len = %scan(&sas_vlngth., &p., %str(^));
length &sas_var. &sas_len.;
%end;
%mend put_lngth;
%put_lngth;
set imported_file_&letter._&i.;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: