About CodingDiSASter

CodingDiSASter · ‎12-14-2020

To import a raw CSV file to SAS, you can use a proc import function: Proc Import Datafile = "File Directory/File.csv" Out = library.dataset DBMS = csv Replace; run; The datafile section needs to include the file path all the way to the file name while the out section lets you name a library for your dataset or create a temporary dataset. the 'replace' option is not necessary but if you'll need it if you want to overwrite a dataset with the same name as the dataset in the 'out' statement. Also, if you change the proc import, and re-run it or re-run it to show someone; the replace statement will prevent errors when you decide to re-run the code.

CodingDiSASter · ‎12-14-2020

I've been learning about SAS in a course and I've been looking for ways to apply it to my job in analytical chemistry. Is it possible to use SAS to produce heat maps? It looks like SAS will be much more direct in figure customization compared to MPP. If I have data that looks like this: Sample_1 Sample_2 Sample_3 Sample_4 Sample_5 Sample_6 Control Control Control Treatment_A Treatment_A Treatment_A Compound_1 Pathway_1 0.31 0.98 0.02 0.96 0.81 0.59 Compound_2 Pathway_1 0.85 0.21 0.91 0.41 0.01 0.86 Compound_3 Pathway_1 0.58 0.98 0.15 0.46 0.02 0.62 Compound_4 Pathway_1 0.04 0.59 0.22 0.17 0.03 0.86 Compound_5 Pathway_1 0.40 0.89 0.44 0.84 0.35 0.21 Compound_6 Pathway_1 0.46 0.13 0.34 0.97 0.29 0.21 Compound_7 Pathway_2 0.82 0.42 0.71 0.29 0.82 0.92 Compound_8 Pathway_2 0.53 0.78 0.16 0.25 0.06 0.56 Compound_9 Pathway_2 0.67 0.60 0.94 0.15 0.40 0.53 Compound_10 Pathway_2 0.40 0.42 0.89 0.61 0.94 0.63 Compound_11 Pathway_2 0.48 0.86 0.11 0.69 0.44 0.09 Compound_12 Pathway_2 0.29 0.64 0.63 0.59 0.87 0.48 I can format the data however I'd like in Excell before I bring it into SAS if it makes it easier. Right now some of the lab members are running ANOVAs by cutting and pasting code into Graphpad so I've already got some ideas for using SAS to streamline things but I was wondering if it was possible to take it a step further. Thanks!

CodingDiSASter · ‎12-14-2020

You can use a proc sort function to remove duplicates by a given variable. In a given dataset 'have' we can remove duplicate names by: Proc sort data=have nodupkey; by name; run; The nodupkey lets you name a variable to remove duplicates named in the by statement (in this case 'name'). This code will not change the original dataset, only the output. If you need a new data set (example: a temporary set called 'want') with the duplicates removed, you can add an out statement: Proc sort data=have nodupkey out=want; by name; run;

Online Status	Offline
Date Last Visited	‎12-15-2020 02:30 AM

Re: Import csv file

Heat Maps in SAS

Re: Duplicated observations

Re: Duplicated observations

Re: Import csv file

Heat Maps in SAS

Re: Duplicated observations