topic Re: Data step query in SAS Programming

Data step query

Ajitesh — Sun, 24 Oct 2021 09:06:15 GMT

Hi Everyone,

I am facing issue in data manipulation. Please help.

I have input file as

Input File
ID Date Flag1
ABC 24-Oct-21 23
ABC 23-Oct-21 45
ABC 8-Oct-21 33
XYZ 24-Jul-21 44
XYZ 25-Jul-21 98

Output require-

ID Date Flag1 Date2 Flag2 Date3 Flag3
ABC 24-Oct-21 23 23-Oct-21 45 8-Oct-21 33
XYZ 24-Jul-21 44 25-Jul-21 98

Re: Data step query

Ksharp — Sun, 24 Oct 2021 10:16:05 GMT

The most simple way is PROC SUMMARY.

data have;
input (ID      Date         Flag1) (:$20.);
cards;
ABC 24-Oct-21 23
ABC 23-Oct-21 45
ABC 8-Oct-21   33
XYZ 24-Jul-21   44
XYZ 25-Jul-21 98
;

proc sql noprint;
select max(n) into : n
 from (select count(*) as n from have group by id);
quit;
proc summary data=have;
by id;
output out=want idgroup(out[&n] (date flag1)=);
run;

Re: Data step query

PaigeMiller — Sun, 24 Oct 2021 10:24:29 GMT

@Ajitesh wrote:

Hi Everyone,

I am facing issue in data manipulation. Please help.

I have input file as

Input File
ID Date Flag1
ABC 24-Oct-21 23
ABC 23-Oct-21 45
ABC 8-Oct-21 33
XYZ 24-Jul-21 44
XYZ 25-Jul-21 98

Output require-

ID Date Flag1 Date2 Flag2 Date3 Flag3
ABC 24-Oct-21 23 23-Oct-21 45 8-Oct-21 33
XYZ 24-Jul-21 44 25-Jul-21 98

Why do you need to do this? What analysis will you be performing on this data? Most times, analyses are easier performed on long data sets which you have, rather than wide data sets.