topic Re: SAS CODE REQUIRED in SAS Enterprise Guide

SAS CODE REQUIRED

Sultana — Wed, 29 Dec 2021 06:26:57 GMT

Hello I have a sample CSV file which has 2 tabs future and Present both the Tabs contain IDs , funds and Elect, Here I need to identify the IDs that made a different elect for future than Present. can you please guide me to write a code .

one can try the transpose,and then concatenate the funds or assigning a key variable in 2 data sets future and present and then comparing both. use a merge statement , with a retain statement.I tried but aI an unable to this is just a sample I have 100 Ids in my dataset.

Re: SAS CODE REQUIRED

andreas_lds — Wed, 29 Dec 2021 07:53:33 GMT

You have attached an excel-file not a csv-file, csv-files don't have tabs, worksheets or any other fancy stuff known from excel-files. They are just text files often accidentally opened with excel which automatically "optimizes" the data, hiding what's really in the file.

From the text it seems that you have an excel-file.

To help you, i need the data you have in usable form: posted as working data step using datalines/cards.

Re: SAS CODE REQUIRED

Kurt_Bremser — Wed, 29 Dec 2021 08:08:18 GMT

Please post examples for both datasets as data steps with datalines, the result you want to get out of this data, and the code you tried.