topic Re: SAS concatenate string and integer in New SAS User

SAS concatenate string and integer

adrfinance — Thu, 27 Feb 2020 10:24:22 GMT

I have two variables

one is named yr and is an integer e.g. 2017

and one called quarter taking values Q1, Q2, Q3 etc.

How can I produce a variable called Time which contains YearQuarter concatenated e.g. 2017Q1 etc?

I tried this:

rsubmit;
DATA dataset_1;
SET dataset_1;
Time=cat(yr, quarter);
RUN;
endrsubmit;

but it returns empty values

Re: SAS concatenate string and integer

PeterClemmensen — Thu, 27 Feb 2020 10:26:39 GMT

Works fine?

data test;
   yr=2017;
   quarter='Q1';
   time=cat(yr, quarter);
run;

Re: SAS concatenate string and integer

ed_sas_member — Thu, 27 Feb 2020 10:28:11 GMT

Pleas provide more details as this code works fine

data dataset_1;
	input yr quarter $;
	Time=cat(yr, quarter);
	datalines;
2017 Q1
2017 Q2
2017 Q3
;
run;

Re: SAS concatenate string and integer

adrfinance — Thu, 27 Feb 2020 10:29:40 GMT

Can you post your reply with variables names insted of using datalines?

Re: SAS concatenate string and integer

mkeintz — Thu, 27 Feb 2020 10:50:08 GMT

@ed_sas_member 's reply DOES have variable names. The datalines approach is used instead of SET statements to show you that the CAT functions works - you can compare the result to the original variables YEAR and QUARTER.