Bonjour à tous ,
je suis nouvelle. J'aimerai savoir comment transformer ma variable statut "pris_en_charge" sur un dossier en plusieurs colonnes (statut1, statut2,....) afin d'observer toutes les personnes qui prennent en charge le dossier.
Merci de m'aider
Salut @Vivek44 ,
Ca serait mieux de presenter la capture d'ecran de ta table avec la structure expectee.
Si le but est just transposer la colonne 'statut' en plusieures colonnes , utilise PROC TRANSPOSE comme en exemple ci-dessous:
proc sort data=have;
by nom matricule iddos statut;
run;
proc transpose data=have prefix=statut out=want (drop=_name_);
by nom matricule;
var statut;
id iddos;
run;
proc print; run;
Ca te donne:
Please show us a portion of the data, and for this portion of the data, show us the desired output.
You did not show us the desired output from this data. Please show us. Also, we need a good description of the logic you are using to create this desired output.
Does this code represent your data set example:
data have; input iddos $ statut :$15. nom $ matricule $; datalines; 2000 pris_en_charge Berlin 000777 2000 pris_en_charge Martin 000880 2000 pris_en_charge Louise 000666 5000 pris_en_charge Berlin 000777 5000 pris_en_charge Marc 000555 ;
Salut @Vivek44 ,
Ca serait mieux de presenter la capture d'ecran de ta table avec la structure expectee.
Si le but est just transposer la colonne 'statut' en plusieures colonnes , utilise PROC TRANSPOSE comme en exemple ci-dessous:
proc sort data=have;
by nom matricule iddos statut;
run;
proc transpose data=have prefix=statut out=want (drop=_name_);
by nom matricule;
var statut;
id iddos;
run;
proc print; run;
Ca te donne:
Merci, je vais essayer sinon on m'avait parlé d'une boucle
MERCIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.