About Emma_at_SAS

Emma_at_SAS · ‎12-08-2020

Thank you, FNY! It took me some time to find the cursor, but I found it! After selecting a section of code the "cut code" and "copy code" options become active!

Emma_at_SAS · ‎12-07-2020

Thank you Reeza for your suggested code. May you please add some notes to it and clarify what each part does? It is above my level of expertise and I cannot use it! Thank you

Emma_at_SAS · ‎12-07-2020

Thank you, Reeza, for your prompt response! Do you have a suggestion for where to start. I am planning to start from here: https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3235-2019.pdf but appreciate any suggestions. Thank you!

Emma_at_SAS · ‎12-07-2020

What is the most efficient way to prepare a report using SAS? I usually created Figures and Tables, copy them into a Word document, and create the report there. I wonder if there is a more efficient way for that. For example, where I write the code I add comments, titles for Tables and Figures, and when I run the whole program I also have my report ready. Thank you!

Emma_at_SAS · ‎12-04-2020

the desired variable names reside in a data set. Thank you!

Emma_at_SAS · ‎12-04-2020

%let numvar = 100; %let variable1 = age; %let variable2 = race; %let variable3 = country; %let variable4 = marital_status; *I have to add 96 more variables in this list for macro variables; *I want to create a loop for proc freq and create excel output; %macro freq_table; ods excel file="\\C:\output_frequencies.xlsx"; %do i = 1 %to &numvar; *this will go from 1 to 100; ods excel options(embedded_titles='on' embedded_footnotes='on' sheet_name="&&variable&i" sheet_interval = 'proc'); proc freq data = my_data_set varheader = namelabel nosummary; tables X1*V2*&&variable&i ; run; %end; ods excel close; %mend; %freq_table;

Emma_at_SAS · ‎12-04-2020

I have a large list of variables that I want to use in a loop as *&&variable&i Therefore, I want to introduce them as macro variables %let variable1 = age; %let variable2 = race; %let variable3 = country; %let variable4 = marital_status; and so on... I do not want to type "%let variable1", "%let variable2", "%let variable3" before each variable name because my list is so long. How may I write a code to receive the name of the variables and create the %let variable1 = before each variable. Thanks!

Emma_at_SAS · ‎11-23-2020

Finally, I could not import the .csv file but LIBNAME mylibname XLSX '\\C:\direction\filemname.xlsx'; worked very well with the correct rows and columns. The hint is that in the data step, I need to specify the Excel sheet that contains the data I want to work on (for me, it was sheet1) data mydata; set mylibname.sheet1; run; Another point was that I kept the data the same that was read from the .xlsx file. When I converted the file to SAS data, it changed the type of the variables and I did not want that. Thank you, everyone!

Emma_at_SAS · ‎11-19-2020

Thank you for reviewing my other thoughts and for your example code!

Emma_at_SAS · ‎11-19-2020

Thank you, Tom! I think that is the case for my data. The header values are long, on average even more than 13 characters.

Emma_at_SAS · ‎11-19-2020

Thank you, ballardw! I added your suggestion to my code, but I think it is taking very long to run the Guessingrows=max for my large data set. may I add 50 instead of max?

Emma_at_SAS · ‎11-19-2020

Thank you, KurBremser I do not need all the columns for my analyses. So, you think if I remove the columns from the .csv file, it may solve my problem? Also, if a large data really has so many variables, what is your suggestion to make a better design for data? Thank you!

Emma_at_SAS · ‎11-19-2020

My data set has 30,000 subjects and 2,400 variables. When I read the .csv file, it creates the same 2400 columns but some variables are not there. I tried both proc import and point-and-click in SAS-studio, both data sets in SAS have the correct number of rows and columns (when checking the dimension) but both are missing some of the variables (the number of missing variables is more when I used point-and-click) proc import datafile='\\X\SASdata\dataset.csv' out=dataset1 dbms=csv replace; run; Your help is much appreciated. Thank you!

Emma_at_SAS · ‎11-07-2020

Thank you for your suggestion! I will contact the SAS tech support.

Emma_at_SAS · ‎11-07-2020

Thank you Paige Miller for your suggestion. It sounds that the version of SAS-Studio that my institute runs does not support the CAUSALMED procedure. On the SAS documentation page, proc causalmed is listed under: SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=statug&docsetTarget=statug_causalmed_examples04.htm&locale=en 1- do you think that might be the case and my problem is the version of my SAS software? 2- Are you aware of any trial/student version that I may use for this specific analysis? Thank you!

Online Status	Offline
Date Last Visited	‎04-01-2024 06:21 PM

Re: Assigning 2 decimal places for output of Std error of Mean and Std...

Assigning 2 decimal places for output of Std error of Mean and Std Err...

Re: LENGTH of NUMERIC variables when combining SAS datasets

Re: LENGTH of NUMERIC variables when combining SAS datasets

Re: LENGTH of NUMERIC variables when combining SAS datasets

LENGTH of NUMERIC variables when combining SAS datasets

Re: identifying rows from the same family and adding a variable for th...

Re: identifying rows from the same family and adding a variable for th...

identifying rows from the same family and adding a variable for their ...

Re: Follow up question on the post "Insufficient space on file"

Re: Assigning 2 decimal places for output of Std error of Mean and Std...

Re: Assigning 2 decimal places for output of Std error of Mean and Std...

Re: LENGTH of NUMERIC variables when combining SAS datasets

Re: Failed to transcode data

Re: LENGTH of NUMERIC variables when combining SAS datasets

length of variable in ODS OUTPUT

Re: Testing all pairwise contrast for a categorial variable in PROC SU...

Re: An efficient method to merge datasets with multiple length for the...

Re: changing some levels for a character variable

Re: Reading SPSS data into SAS: some variable names are too long

Re: How to copy paste code with colors and format Cntrl+I in universit...

Re: Creating a list of macro variables for a large list of variables

Re: Preparing a well organized report with Figures and Tables and some...

Preparing a well organized report with Figures and Tables and some add...

Re: Creating a list of macro variables for a large list of variables

Re: Creating a list of macro variables for a large list of variables

Creating a list of macro variables for a large list of variables

Re: Importing .csv file to SAS studio

Re: Importing .csv file to SAS studio

Re: Importing .csv file to SAS studio

Re: Importing .csv file to SAS studio

Re: Importing .csv file to SAS studio

Importing .csv file to SAS studio

Re: How to use correlations in PROC CALIS for confirmatory factor anal...

Re: How to use correlations in PROC CALIS for confirmatory factor anal...

SAS Inner Circle Panel