It can't be done as far as I can see. The screenshot is from excel . But if you save as .csv then you can no longer get the formula used to create the value in the cell . Try opening the csv up again in excel and you will see there is no longer a formula . This is all before it has even touched SAS . ... View more

sorry - that was a tongue in cheek answer which solved %100 of the sample data provided , but perhaps indicated the problem description needed elaboration . too subtle... ... View more

where cid ne 103.... ... View more

If you have your calendar already in a dataset , you can add a counter  WORKING_DAY     WORKING_DAY_CNT 05AUG2019             1 06AUG2019             2 07AUG2019             3 08AUG2019             4 09AUG2019             5 13AUG2019             6 14AUG2019             7 16AUG2019             8  19AUG2019             9   Merge the working_day_cnt onto your "ID" dataset by the date ID_A     ID_B        Date               WORKING_DAY_CNT X           A            05AUG2019     1 X            A            07AUG2019    3 X           A           13AUG2019      6 Y          A            13AUG2019      6 Y          A            16AUG2019      8  Y          A            19AUG2019      9  M         C            14AUG2019      7   Then use first. processing and a retain statement to calculate your DBT  ... View more

Are you doing an assignment? with all due respect you will not learn anything if you keep getting other people to supply answers for you . What have you tried so far? What do you think the problem is ? Have you researched what an informat is ?  ... View more

Obviously a table needs to be created  .    You can use SAS to achieve this  .    Check out the examples .    ... View more

you initially said this was your code PROC IMPORT datafile=mouse; Mouse; Day3; Day6; Day9; Day12; Day15; Day18; Day21; 1 0.109 0.388 0.621 0.823 1.078 1.132 1.191 2 0.218 0.393 0.568 0.729 0.839 0.852 1.004 3 0.394 0.549 0.700 0.783 0.870 0.925 4 0.209 0.419 0.645 0.850 1.001 1.026 1.069 5 0.193 0.362 0.520 0.530 0.641 0.640 0.751 6 0.201 0.361 0.502 0.530 0.641 0.640 0.751 7 0.202 0.370 0.498 0.650 0.795 0.858 0.910 8 0.190 0.350 0.666 0.819 0.879 0.929 9 0.219 0.399 0.578 0.699 0.709 0.822 0.953 10 0.255 0.400 0.545 0.690 0.796 0.825 0.836 11 0.224 0.381 0.577 0.756 0.869 0.929 0.999 12 0.187 0.329 0.441 0.525 0.621 0.796 13 0.278 0.471 0.606 0.770 0.888 1.001 1.105 ; RUN that would be the incorrect way to create a dataset , because you don't use proc import and then type in the values. Are you saying your data is actually in an external file? ... View more

data mouse; infile datalines truncover; input Mouse Day3 Day6 Day9 Day12 Day15 Day18 Day21; datalines; 1 0.109 0.388 0.621 0.823 1.078 1.132 1.191 2 0.218 0.393 0.568 0.729 0.839 0.852 1.004 3 0.394 0.549 0.700 0.783 0.870 0.925 4 0.209 0.419 0.645 0.850 1.001 1.026 1.069 5 0.193 0.362 0.520 0.530 0.641 0.640 0.751 6 0.201 0.361 0.502 0.530 0.641 0.640 0.751 7 0.202 0.370 0.498 0.650 0.795 0.858 0.910 8 0.190 0.350 0.666 0.819 0.879 0.929 9 0.219 0.399 0.578 0.699 0.709 0.822 0.953 10 0.255 0.400 0.545 0.690 0.796 0.825 0.836 11 0.224 0.381 0.577 0.756 0.869 0.929 0.999 12 0.187 0.329 0.441 0.525 0.621 0.796 13 0.278 0.471 0.606 0.770 0.888 1.001 1.105 ; RUN; You have some lines that do not have values for all of the variables - e.g. Mouse 3 .  This code assumes that it is the last variable (Day 21)  that is missing - I can't tell from your formatting if this is a valid assumption .  ... View more

Yes, you can use explicit SQL pass through to create an Oracle table from SAS ... View more

Sounds like you are using Enterprise guide .   I can't test this on my current setup, but I think you could use copy files task to download your .xlsx from unix to windows .    https://blogs.sas.com/content/sasdummy/2013/05/20/export-and-download-any-file-from-sas-enterprise-guide/   ... View more

using regular expressions would be my recommendation.   But if you want SAS to find consecutive delimiters here is a highly inefficient method to do what you are asking for DATA A; B ='/opt/sas/platform/pm//work/calendar/CAL_END_AR______400@username'; DO I = 1 TO count(b,'_'); C = SCAN(B,I,'_'); D = SCAN(B,I,'_','M'); IF C NE D THEN DO; WANT=SCAN(C,1,'@'); PUT WANT=; STOP; END; END; RUN;   ... View more

I had the same problem and the note worked for me . It is like EG thinks you have multiple monitors and the popup window appears on a monitor which doesn't exist.    to help prevent the issue ,if you are working with multiple monitors, then any time you have a popup window (like query builder) move it to the same monitor that you have EG on .  ... View more

If your aim is to create an output dataset - try this: proc freq data=test ; table gender race/missing OUT=your_dataset; by age_group; run; ... View more