data import for Mixed Model Task help

[lshortna]

Hi there. I am trying to run a Mixed Model using the Tasks pane in SAS Studio. I have my xlsx file imported in my Server Files and Folders, but I can't seem to select or drag the specific file into the DATA drop down when trying the run the mixed model. My data file doesn't show up as an option to select. How do I get my data in to the Tasks tab?   

[Reeza]

---

@lshortna wrote:

 I have my xlsx file imported in my Server Files and Folders,

---

That means your file is uploaded but it does not mean it's ready for analysis. 

You first need to import the XLSX file to convert it to a SAS file ideally - use an IMPORT task and note where you're saving the file. You should probably create a permanent library to save the file. 

Then you can use the data tab shown in your screenshot to navigate to the file you've imported. 

Note that while you import the file you need to ensure your variables are imported correctly. This means that no values are truncated, that numeric variables have the type numeric and categorical variables can be either numeric or character. 

Import

https://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio?autoSta...

Mixed Modelling tips

https://video.sas.com/detail/video/4604338315001/tips-and-strategies-for-improving-mixed-models-perf...

---

@lshortna wrote:

Hi there. I am trying to run a Mixed Model using the Tasks pane in SAS Studio. I have my xlsx file imported in my Server Files and Folders, but I can't seem to select or drag the specific file into the DATA drop down when trying the run the mixed model. My data file doesn't show up as an option to select. How do I get my data in to the Tasks tab?   

---